Ganesh

Please supply table DDL in the form of a CREATE TABLE statement, sample data in the form of INSERT statements, and the result set you expect to see. If...

Example 1 fails because you can't have a variable setting the database name. Example 2 fails because the dynamic SQL that you use executes in a different context from...

First of all, you need already to have a full backup and a differential backup of your database. If you do, then restore from the full backup with no...

You could try something like this:

DECLARE @tv table (reviewed char(1))

IF @reviewed IN ('P','B','N') INSERT INTO @tv VALUES ('P')

IF @reviewed IN ('F','B','N') INSERT INTO @tv VALUES ('F')

IF @reviewed = 'N' INSERT...

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...