Hi, I have a very strange problem. I have one sql 7.0 box, and one sql 2000 sp3 box. An ASP app that we've been running off of the 7.0 is now running about 10x slower on the 2000 box. The 2000 has more ram, faster processor, and both are running on WinNTsp6a. I have checked all the possib...more >>

I get "Access Denied" message when I choose one of the remote SQL server and the entire services list is blank. What has gone wrong? Please help........more >>

I've been getting the following error message whenever I try to connect to my remote server to work on some cubes. "Cannot open connection to Analysis server 'WRPBI' Error in data [possible data corruption]" How can I fix it? I've reinstalled Analysis Manager but it didn't help. Thanks...more >>

I have 2 tables: Table: UserTable Field: Id (pk) Field: FullName Table: MarriageTable Field: MarriageId (pk) Field: Husband Field: Wife The MarriageTable.Husband and MarriageTable.Wife fields BOTH have to be valid users from the UserTable. In SQL Server I'm creating a relationship...more >>

I have created one trace with Security Audits event only and about 10 data columns and no filter. Which runs fine SQL profiler. I just want to trace users activity on server. But I want to keep this trace running on the server. How can I setup to run trace on server from client. I have admin rig...more >>

Hi, I installed SQL server 2K on my winXp Pro, and have created a few tables in my sql database. When I want to enter some data using Query Analyzer from the Tools menu...but for some reasons it never bring up Quezy Analyzer... Any ideas? thanks in advance.......more >>

How can I see how many SQL CAL's I have on my server. I know how many I am licenses for, but want to make sure I regulate this on this server. Is there a license manager I'm not finding? -- Spencer http://www.wasatchsoftware.com...more >>

I have a field in a table that contains ten digit value representing a datetime. Is there any way to convert it to default datetime format. Plese Help me Thanks -- Message posted via http://www.sqlmonster.com...more >>

Hi! how can i use if condition in where clause of select statement I want the work like this but this is not working correct select * from Table1 where if (@a>1) field1=@a else ...more >>

Hello, I am receiving this error when I try to execute a Stored Procedure in SQL Server 2000 using SYBASE dblib. I have been able to connect to connect to SQL Server from Unix, but when I try to execute a Stored Procedure via dblib, I get the error: "Error 17805 Invalid buffer received f...more >>

I am running an accounting program that uses SQL Server 2000 SP3 for the back end and uses Access 2003 RT for a user interface. There is about 200000 rows per table with about 150 tables. My problem is that at what seems to be a random interval everyone that has the accounting system running o...more >>

Hi, I have created a datagrid within an ASP.NET page that links to an SQL table - this works just fine. One of the columns retrieves the date which a particular row was populated. However, the format which the date is returned is: 19.12.2004 13:03:25 I only want to display the date t...more >>

Hi all I have 2 MS SQL Servers (one in the English Language version, one in German). On each server I have the same database (one for testing, one for work). When I'm queriing a datatable from vb.net I'm getting problems with a a datetime parameter: The English Language Version acce...more >>

Hi, I have two tables: table 1 contains customer information, and table 2 contains order information. Table 2 is updated everytime a customer orders some goods. Therefore, a customer, for example, can appear within table 2 on, say, a total of 5 occasions. I would like a column in tab...more >>

I have this problems during the debug of a stored procedure: 1) In the immediate windows variabile are not set (these are nulls) 2) The step by step don't highilight the current line in yellow but highlight some empty lines I have SQL Server 2000 I have also deleted the stored and re-create...more >>

Is there a SQL command which will kill or exit all batches in the query analyzer? For example I have this script: query1 query2 GO query3 query4 query5 GO Is there a way so that when I check @@ERROR after query1 that query2,3,4,5 do NOT get executed? GOTO's cannot see beyond the ...more >>

I am pretty new to SQL but have been asked to purchase 10 user cals for our employees. Would anyone know what needs to be done to load the cals for the clients to be able to access the server. Thanks in advance for any help ...more >>

Is there a maximum number of connections allowed to the developer, or is 32767 per instance as for the enterprise edition - anyone know?...more >>

Hi everyone I'm trying to transfer an SQL Database using an Access Project. Its Access 2003 running 2000 file format. The ADP file I have open is connected to a SQL Server on a remote machine. I'm transferring from the remote server to my local server. Both are MSDE. The process seems...more >>

Hi, Could anyone help me? I'm trying to create a datagrid using ASP.NET. It works fine except the coloum that is supposed to display the entrydate is blank. All the other information displays correctly. I used the following code to create the table on the SQL server. CREATE TABL...more >>

We appear to have a problem with our diagrams in SQL 2000 Enterprise manager - The diagrams either disappear so that when you click them there is nothing to view or alternatively the tables show with no fields. This problem doesn't affect all diagrams, but a large proportion of them. Any idea...more >>

Hello I have a SQL table of three field Machineid, Int IP Address, varchar(16) Duplicate, bit I would like to create a stored procedure that can be run that will take this table sort by machine id and as it is looping though the recordset compare the previous MachineID to the current ...more >>

Hi, Is it possible to update two tables with the same information with one click of a button? My code in the aspx page is this. strInsert = "Insert Firsttable ( u_firstname, u_secondname ) Values ( @Firstname, @Secondname )" strInsert = "Insert Secondtable ( u_firstname, u_secondname )...more >>

Hello all, I've converted a database from Oracle 8.1.7 to SQL Server 2000. The following SQL statement works in Oracle, but I cannot get the statement to work in SQL Server: select substr(u.o_userdesc,1,(instr(u.o_userdesc || ',' , ',')-1)) from dms_user u where o_userdesc = 'Administrator' ...more >>

Hello. I'm researching about the ways I can create an installer of the SQL (2000) objects for an application. At the present time we're using a set of calls to osql utility from a VB application. But the maintenance of the scripts is becoming cumbersome. Does MS provides utilities for t...more >>

Here's what I am trying to do: I have a large SQL script that I need to run often. I want to be able to run it and get a summary of the errors that occurred (possible info - where the error occurred, etc.). If at all possible I would like to stop execution of the script at the point of er...more >>

Experience with clustering and SAN storage technologies Can any one explain about the above lines thanks NOOR ...more >>

Hello SQL Scripters, I have the following MS/SQL server 2000 Script: ******************* use NorthWind GO declare @RecordCount int ,@SelectString varchar(80) ,@QueryString varchar(80) ,@sQuote varchar(1) set @sQuote='''' set @QueryStri...more >>

Hello SQL Scripters, I have the following MS/SQL server 2000 Script: ******************* use NorthWind GO declare @RecordCount int ,@SelectString varchar(80) ,@QueryString varchar(80) ,@sQuote varchar(1) set @sQuote='''' set @QueryStri...more >>

There is a large table with a multiple-column index. What is the proper way to search using these columns so the multiple-column index is used? Thanks. ...more >>

Greetings ! We need to find if MS SQL has an API for connecting C++ components to it. We don't know if "extended stored procedure (xp)" is the way to go. Why do we need that ? We must implement a synchronization software layer to make sure an ODBMS has the same values as tho...more >>

Is it possible to configure Enterprise Manager to connect to a remote server on a non-standard port, without changing the port for ALL of the registered servers? I see that I can use the Client Network Utility to change the "default port" for TCP/IP. But I have several servers registered, and...more >>