Yes, that was the idea. The uniqifier column could of course just as well be set to 0 always, or be a tinyint that is always set to 42 (you...

Uhm, not quite sure what you want here. I assume you mean SQL Query Analyzer, right? What do you want to do? Look at how the data is stored? Then...

Greg: Actually, it is not an exclusive table lock. It is a compile lock for compiling an execution plan for the stored procedure. The lock above it is a Schema-Stability...

What do you mean by returning null? In a resultset, or as a return parameter? What does the procedure do?

Uhm, it might be me that is a bit slow today, but what exactly is a virtual logon? Is it an Oracle term?

Here is a completely different solution:

CREATE TABLE dbo.INDICATORTABLE

(

othertablepk INT NOT NULL PRIMARY KEY NONCLUSTERED

, uniqifier BIT NOT NULL DEFAULT 1

, CONSTRAINT INDICATORTABLE_fk_OTHERTABLE FOREIGN KEY...

"an esquel"

I have not tried this, but I assume this should work:

exec master..xp_cmdshell '"c:\program files\winzip\winzip32.exe" –min –a –r -en c:\atlas\Users.zip c:\atlas\Users.txt'

Are the two databases owned by the same SQL Server login account?

Because what you are saying with this query is really "Delete all rows where RecordID=2 and where the subquery does not return anything". The subquery of course always returns 4...

I am not really sure what you mean with "[not] touching the PK and referenced by it FKs". You cannot drop a table if there are other tables with foreign...

Marc, alternative 2 is the way you should do this.

I just remembered that the original question of the thread has not really been answered yet.

Rich, does your Product table have a clustered index? I assume your query looks something...

Is it SQL Server 2000's Enterprise Manager or SQL Server 2005's Management Studio we are talking about here?

SQL Server (2000 and 2005) runs as a service under a specific account, which can also be LocalSystem. If you are going to access remote locations you need to make...