Hi

Without wanting to sound rude..

What do you mean this "To maintain consistency with other tables I am maintaining Identity column as first column in staging table too "

Hi

Cud u give more details ...

2 ways come to my mind ... may not be correct since we dont have the details from you.

1 - Keep a flag whihc tells...

Hi

You can also use the activity monitor under management in SSMS. Here you can add filters including "blocking "filters to see the processes that are causing the blocking in your...

Hi

Whenever you job encounters a error it will quit. You can set what to do when the job fails , be default its quit the job when a failure occures....

Sugesh do u mean taking a copy of production database and restoring it as a Test db. Is'nt he asking about recovering the test db ?

Yes. Chances of getting a hardware or even software failure is high. Why did u choose log shipping ?

Hi

Jeff , Gail -

Does this mean creating each table in a diff file group . This way user will have option to restore only the table that user requires...

Hi

do you mean to say incorrect columns or incorrect rows.

Select * will return all columns , maybe you dont require all of these.

If its returning incorrect data then probably you...

You do have the public role inside the database as database role.

Hmm... no such event near to where iam. Microsoft should

give a gift to everybody who uses their product ... atleast to developers. 😛 . Arent we developers also doing some...

Two important things pointed out here are if customer is happy then the project can be said to be a success (what level of success ... it depends) and the...

Dont think so.

Hi

by validate do you mean checking for existence of the users and whether they are connected to the appropriate database. Or you want to compare whether the same users exist...

Hi

can u explain what you are trying to do.

The error message means that the server (linked server i presume) is being accessed. i.e its in user.

Hi

I agree with Grant.

Is the procedure calling any other procedure before inserting the rows?