Viewing 15 posts - 331 through 345 (of 485 total)
Why the restriction on the prizes (export thingy)?
A real shame I am in UK and would really like 1st prize.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
October 31, 2002 at 7:39 am
What are you trying to achieve, totally uninstall SQL, recover to the original database files ?
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
October 29, 2002 at 9:01 am
remember to change the name of the server internally.
sp_dropserver oldservername
sp_addserver servername, LOCAL
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
October 27, 2002 at 1:15 pm
running
dbcc inputbuffer(spid)
will return the first portion of what is being executed.
Also run profiler and capture the Completed events and look for the one with the correct spid.
The problem...
October 27, 2002 at 1:14 pm
This is a neat way of doing it
sp_msforeachdb '?..sp_spaceused'
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
October 27, 2002 at 1:10 pm
For a reference on the security architecture http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/Default.asp
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
October 27, 2002 at 12:59 pm
I always combine it with DBCC FREEPROCCACHE, to force the server to clear all buffers. The only thing I can believe is that the results of the query are associated...
October 27, 2002 at 12:37 pm
You can use a trusted connection by using the -T option, if you specify neither -U or -T it will assume a username of sa, and if you haven't specified...
October 27, 2002 at 12:29 pm
Further more if the t2 can have more than one row for the an id value then you have to use the not exists method. This is an area where...
October 27, 2002 at 12:21 pm
EXEC performs the SQL in a different scope to the calling TSQL, you can therefore not use variables declared outside of it.
You need to use sp_executesql
declare @comp_failed as int
SET @strSQL...
October 27, 2002 at 12:16 pm
You can use this
go
/*******************************************************************************
Written By : Simon Sabin
Date : 25 October 2002
Description : Returns the spaceused...
October 27, 2002 at 12:13 pm
Not sure what you mean by "create the indexes and then index it", once you create the index the table is indexed.
If putting more than one index on a table...
October 27, 2002 at 12:06 pm
Not possible, you have to declare the cursor every time.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
October 27, 2002 at 12:04 pm
I think thats a valid point.
Essentially all education is a means to quantify someone. I think a degree provides more into someone as a person. When employing somone when you...
October 27, 2002 at 12:02 pm
A queue length of 140 is scary.
Questions
What percentage of the table will be updated?
Is cid on work the primary key?
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
October 27, 2002 at 11:55 am
Viewing 15 posts - 331 through 345 (of 485 total)