If you go with the permanent table and SPID approach, this isn't the case. SPID belongs to a connection. As a result, any given SPID is unique for...

The GO command is a command that applies to Query Analyzer. It signifies the end of a SQL batch. It's not executed on the server. As a...

The Q article says SQL Server SP 3 has the fix, but the other article doesn't say anything about an SP having the fix for SQL 2K.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

I'm not sure this can be done with Profiler. You can get the execution plan and those sorts of things, but if you're are using variables LIKE @@IDENTITY and...

Even if the object is a reserved word, the object can be qualified using brackets [] as this example demonstrates:

CREATE TABLE [Table] (

TableID int IDENTITY)

GO

Is the issue that you are losing the execution plan or that the data that will be touched by the stored procedure isn't in cache? Both of those can...

Perhaps this is the actual bug (SQL7):

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q276234

And again for SQL2K:

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q290622

I was aware of an issue with single user mode if the maintenance plan is set to try and fix minor...

DBCC BUFFER, with the appropriate trace.

http://www.sqlservercentral.com/columnists/achigrik/sqlserver7someusefulundocumenteddbcccommands.asp

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Replication is pretty straight forward, but as has been discussed in another thread, one of the problems is resyncing the data once the "production system" comes on-line.

Log shipping...

Right, which means if he can wrap the dynamic SQL statement with a stored procedure which creates the temporary table there, he can go with #. However, if he...

If he's having to set grant permissions every time he's added a user, unfortunately that means no roles at all have been used. You make a good point, though,...

Chris makes a good point in that you'll need to shrink the log file after the backup. Here's a link to the Microsoft Knowledge Base article on the subject:

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q272318

Also,...

But from a performance perspective, if the client isn't on the same system as the SQL Server, TCP/IP has the best performance of the network libraries. One of the...

Did you get a chance to see the Yukon demo? Anything of interest shown?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Another thing to investigate! I've seen all the standard "Microsoft prefers you use sp_executesql" but I've not run any specific tests. Since it's a "(server internal)" system stored...