Yes, I should have spotted this the first time. Just get rid of the SELECT and it should work.

If you ever get a syntax error message, your first port...

Not true. A temp table will persist until it is dropped or the user connection terminates. ...

Raghu

Not sure what you're asking. A trigger is a spcecial kind of stored procedure that runs when a table is updated, inserted into or deleted from. Could you...

We know that, but we don't know what help you need. Was the query you posted successful? If not, in what way was it not? Did it...

Do the two databases have the same amount of data on them? Do you rebuild your indexes and update your statistics regularly? Have you compared the execution plans...

Rajesh

Can you not just use dbcc checkident (Discount, reseed, 1)?

John

I would say give them read-only access, and if they want anything changed, ask them to supply you with a script. I think if you go for anything less...

Rajesh

Please will you post your CREATE TABLE statement and the code you are using to reseed the identity value.

John

Karthik

Use sp_executesql with an output parameter.

John

And the error message you get is...?

... and it's helpful to have SQL Server 2000 Books Online, although I think you can download and install that separately. Speaking of which, make sure you regularly download...

Yes, install the SQL Server 2000 and SQL Server 2005 client tools on your desktop and you'll save time connecting to your servers - assuming there are no firewalls stopping...

James

If you suspect the databases aren't being used at all, then run a Profiler trace against them for a week or a month or however long you need to. ...

Karthik

I would advise you to write a script that uses INFORMATION_SCHEMA.COLUMNS to generate the query that will count the NULLS in each column in each database. It won't be...

One way of doing it is to pipe the output of net start to a text file and then examine the contents of that file. I'm not saying that...