Hello all, How can I tell how much memory SQL Server is using on a server. On Windows 2000, whenever I go to Task manager/processes/memory usage SQL Server seems to be showing 1,744,124K. On all of my servers with various size, usage of databases, all of them show SQL Server to be using abo...more >>

I have a script or SP that takes a very long time to perform multiple tasks, and after each one there is a PRINT statement that shows the time and what was just accomplished, to help me monitor what's happening and estimate how long it will take. In a script, I can put a GO after each PRINT to c...more >>

hi guru's would appreciate if someone could show how to list all the clustered indexes in the database. if it can done as a output of single query it would be fine. the output should be the table name, column name and clustered index name. thanx bala ...more >>

Hi, I currently have a ms access update query that runs perfectly well and quicly in access however I now need to add this query to convert this qeryu to oracles equivelant sql syntax and add it to the end of an oracle sql script. Unfortunately Im not having much success although i seem to...more >>

In a situation where you have two tables in a hierarchy like this: create table authors (authorid int identity (1,1)) create table books ( authorid int, bookid int identity (1,1) ) Is there any disadvantage to having the primary key and the clustered index as a compound key, like this: ...more >>

Hi I am creating new SQL Server Tables using SQL Server 2005. I have set primary key to the tables .But I do not know how to assign Foreign key to the tables .I need to do some joins later and that is why I have to put Foreign key to the table . The Primary key is visible and can be assigned ...more >>

Dear Group The scaenario is as follows: FirstName and LastName are separate columns in the contact table and I want to be able to search e.g. for the FirstName and part of the LastName at the same time e.g. 'John A' should return 'John Adams'. Would be grateful if you can give me some hint ...more >>

Ok, here's my dilemma. We're running SQL Server 2000 with the default db setting for the ANSI_WARNINGS option set to off. However, we still get "Warning: Null value is eliminated by an aggregate or other SET operation" messages. To eliminate getting the message, we use the SET ANSI_WARNINGS O...more >>

i reinstall the sql server on the machine, and use attach file method to get the database back, and it works well on the server, which means i can get the data using Query analyser, but when i use the web application to access the database, it always come out with error message, it seems that th...more >>

I am trying to do a select statement with SQL 2000 for all records containing any number of lowercase letters. I have tried the following 2 statements and they both seem to match both lowercase and uppercase letters. SELECT * FROM customers WHERE name LIKE '%[a-z]%' SELECT * FROM customers...more >>

Ok, I inherited this database and there is a field that stopres a select statement. Is there anyway possible to execute the value of the field within a select statement? For example: the table: Name "george" lookupForName "Select orders from Ordertable" So maybe something like select...more >>

Consider a table that holds Internet browsing history for users/machines, date/timed to the minute. The object is to tag all times that are separated by previous and subsequent times by x number of minutes or less (it could vary, and wouldn't necessarily be a convenient round number). This will ...more >>

Web server: win2003 server with iis6 DB: sql server 2000 I have 50+ remote offices running an Access 2002 app which connects directly to sql server at a 3rd party hosting company, in part using an odbc connection on the workstation. We recently moved our database (and our web site) in-hou...more >>

BEGINNER QUESTION I have a table which has a compound primary key consisting of two columns. One of these columns is a foreign key which is generated in another table by an identity. I want to be able to generate the other primary key column value automatically when an insert occurs but...more >>

Hi, I have an application where I need to find out about the following information regarding SQL server: Processors enabled i. Threads allocated ii. Priority Can somebody throw some light on this. How are the processors related to the threads running and the priority is w.r.t. what? Th...more >>

To set up the problem, paste this into QA: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WorkOTRate]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[WorkOTRate] GO CREATE TABLE [dbo].[WorkOTRate] ( [TimeFrom] [smalldatetime] NOT NULL , [TimeTo] [...more >>

Hello, Somebody accidently deleted a record with cascade deletes and took out about 80 records. The database has been used heavily since then. How do I put back the data? I have spent hours researching BOL and all I can find is how to restore the database to a point in time. But tha...more >>

All, I have a problem regarding SQL Server 2000 SP3, I have SP that calls other SP and it inserts about 30,000 records as a time, in the development environment (MS Windows 2003 Enterprise, 256 RAM, 3.0 GHz Intel Processor) takes about 6 seconds to run this SP. But, with the same Software bu...more >>

Hi, I am planning to install sql server 2000 sp4 on my clustered server running in active/passive mode. I plan to stop all sql services using cluster administrator, install the service pack from the primary node and then reboot all nodes. Are there any missing steps that need to be done or pr...more >>

SQL Server 2000 SP3. Is it possible for the @@ROWCOUNT function to return NULL after a statement? I am troubleshooting a relatively large stored procedure with multiple SELECT statements and a couple of INSERTs into table variables. Immediately after each statement I save the value returned...more >>

Hi there. I apologize if this topic had already been covered. I'm trying to find out whether I can load up a data dump files, generated off of a 64bit SQL server on Itanium, to a 32bit MSSQL 2K server. If anyone has tried this before, please let me know your findings. Thank you very much in ...more >>

Hi all The SET IMPLICIT_TRANSACTIONS ON syntax turns on Begin Transaction by default, yet when the ROLLBACK command is used everything in that session gets rolled back. Is there a way to use the set implicit command to rollback only the last transaction? Thanks in advance Driesen -- ...more >>

I am experiencing the following problem; I boot my Windows 2000 sp#4 machine. I check sqlservr.exe's memory usage in Task manager. It is ca 20 mb, everything is OK. Then I run this query; select postoffice, count(*) as counter from tblTable where postoffice is not null group by postoffice ...more >>

I wish to create a user that can backup any or all databases in our SQL Server 2000 Instance. I thought there would be a server role for this function, however I can only find that after I grant access of a database to the user, then I can choose ds_backupoperator. I want to create a user that w...more >>

I have a WHERE clause that could be an "=" or a "LIKE" depending upon if the passed variable is populated or not. I would like to know the best way to write the WHERE clause to make it dynamically switch between the 2 and make best use of the indexes. CREATE TABLE myTable(ID INT PRIMARY KEY CL...more >>