I've been a big fan of Identity columns for years. At least since v 6.5. [ I think I used it in version 6.0, but that was years ago. ]

But,...

If at all possible, I'd recommend getting a new server for the upgrade. This forces you to really document the key system info such as linked servers, sp_configure, logins,...

Thanks, I missed that at first. But with the correct password, I now get error = 0, but after rollback, the table is empty - no non-logged records.

Yes,

make sure it can store nulls.

but try below,it puts a null

into a datetime field.

create table ##test

(myddd datetime null, myaaa varchar(10) )

insert into ##test values ( NULL, '111')

select *...

If you use a global temp table,

the object name will show up in the tempdb exactly as ##AC_Updates. This is unlike a non-global temp table. So you need...

If the "application" you are refering to includes database triggers, procedures, etc, then you can search the syscomments table.

Better still, dump all triggers and procedures to a text file, and...

If you must use a third-party solution, use the one you are using for all your other system backups. Veritas is good.

but I agree with Steve, do what ever...

If you just want to occasionally look at the activity, perhaps Lumient Log explorer will work,

but if you have a real business/application need, then either use a table trigger,...

I remember reading this same tread months ago.

Good attitude, experience, and knowledge. But if you really want some insight, put your self in the hiring managers position....

I've seen this error with SQL7 & NT4.

And, the solution was just as prescribed by MS (no action required).

If the master database did not exist at all,

then in...

Andy, Keep pushing the limits! Gotta agree with you, there is more to data integrity than just nightly backups. As for solutions, as you have indicated, it all depends....

In this time of zero latency between systems, snapshot does seem a bit outdated.

But you were right-on with the focus on Business requirements. In many of the large corporations...

Thanks for highlighting.

Worthy of going into a best practices category! I suspect quite a few of us overlook the 24 hour exposure of our backups until the nightly...

If you are looking for a way to fully automate both the backup of the primary server, and to then restore the secondary server, you may want to take a...

Gotta agree with Andy.

Would love to use WA, but there is always something...that is the issues Andy outlined.

Actually, cannot think of a situation where we used WA for any web...