Pick one of the problem table, say, PS_EOCM_EDUP_TMP7 and run the following script

select *,StatsDate = stats_date(object_id,stats_id) from sys.stats where object_id = object_id('PS_EOCM_EDUP_TMP7 ')

note the value for StatsDate. If you have...

If my understanding of your question is correct, you can write a simple script to delete that dummy colum and then add an identity column for the seed. Post a...

What credentials are you using to run the bulk insert statement? If using windows auth, please check if that windows account has access to that file. When using windows authentication,...

Are you try to connect remotely via SSMS or from your application? If via SSMS, you should be able to connect to it using SQL auth. As you mentioned that...

Make sure no record has value NULL for those changed from NULL to NOT NULL, or the insert will fail. Also, it might be wise to comment out the drop...

I take you do have a backup of your system dbs.

I would suggest you restore them from your backups on any available SQL2005 instance as a user database so you...

You need to restore the .mdf, all .ndf and .ldf files. .ndf are secondary data files.

Given that you are restoring onto the same server/instance with just a differenct db name, all the logins (and permissions) will still work on the new db without any change....

Thanks Gail & Steve. I fully understand. This question is answered and closed.

Thanks Gail, Paul Randal demoed fix a system table corruption (user partially deleted record from system table in SQL2000 db) and you helped someone in a post by delete a...

42 attempts so far with no success but majority speak the right answer should be for this one. Obviously, the submitter is responsible for it. However, it will add value...

xp_cmdshell returns 0 or 1 for the code it runs (if the underline code can return 0 or 1). Get your vbscript to return 1 for failure, that way you...

I have used tab to format the script for easy reading. If you copy and past the script into QA, you may receive some error message. Replace ' ...