I've updated the T-sql text in my previous reply ! (also included tabulation-char) .

Watch out for UDF's. sp_stored_procedures...

tricky but maybe ...

-- ALZDBA dd 18/03/2004

-- convert sp to with encryption

set nocount on

DECLARE @SearchString varchar(255)

Declare @WhichProcs varchar(255)

Declare @sp_owner varchar(255)

select @WhichProcs = '%spc%',  @sp_owner = '%'

DECLARE @spcount int,

 @spLoopCount int,

 @proc_name...

First take a look at the articles diogenes0412 mentioned !

then try this.

Clone sqlserver-server (i.e. keep servername,...)

- install windows...

- what's the filter-factor of the columns in your index ?

- what portion of data would be part of your query ?

as you have noticed, RI should have an index per FK-definition (unless the overlap is matching columnorder and sortdirection), otherwize indexes might not be used for RI-purposes.

Maybe use this to put them offline when sqlserver is started :

(you must be sysadmin to install this)

use master

create procedure sp_MyOwn_SetUserDbOffline

as

set nocount...

- are there any indexes on the foreign-key-columns to support the delete-join ? (with all child-tables)

- If yes, are the columns in the same columnorder and sortorder(asc/desc) as the parent...

keep in mind you are working with a heap table ! (indid =0 )

If you want to defrag a heap, you'll have to put a clustering index on it.

check BOL

create a dummy-db and transfert it to your SQL2k with the copy database wizard. It gives the possibility to migrate userid's.

dont just do it from the prod-db, because it performs...

I hope this gets you started :

SELECT  sysFile.groupid AS GroupID

, SUBSTRING(sysFile.groupname,1,30) AS FilegroupName

, SUBSTRING(sysObj.name,1,30) AS ObjectName

FROM sysobjects sysObj

 INNER JOIN sysindexes sysIdx

  ON sysObj.id = sysIdx.id

 INNER JOIN sysfilegroups sysFile...

What do you want to do ?

datepart(hh,**) will only return hours-part.

Datepart(mi,..) will only return minutes-part.

why not compare to convert(datetime, convert(char(10),getdate(),121) + ' 07:00:00'))

from Books Online :

DATEPART

Returns an integer...

Ad it to the comments on http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=32&messageid=11677 

- you could just have an alert raised when a file grows (e.g. error 5005 might be logged). Then extract the info from sql-log or windows-eventlog.

- you can gather the...

Correct.

no offence meant , just adding the symptoms.

I know that was the goal, but having a 48Kb table using +500Mb is what happened . After creating the CI sizes were back...