Hi,

The answer to your question is pretty straightforward for those of us who have dealt with the same type of problem

Identity columns cannot be NULL, as the value is either...

Just to throw another US$0.02 in on the subject...  I require that any job that performs mass updates use the READ UNCOMMITTED option in the job, and that a cursor...

Thanks for everything folks - got the data I needed late last night, and it's been safely merged back into a new production db.

Just a quick reflection:  I had a...

Hey SQLBill

Here's the logs from ERRORLOG and error message (and I also renamed the logfile as you suggested).  "dbname" substituted for the actual...

Jon,

It looks as though you're trying to do all of the maintenance in one shot (at least from just looking at your command line).  We had the same problem when...

Thanks for taking the time Steve, for this memorial to man who, like everyone, had his flaws, and his great moments.

I was in college as well when Reagan...

When one uses DETACH and ATTACH, the physical files that comprise the database (data and log files) are "delinked" from the database.  This is useful when you need to move...

In addition - if using the MS Performance Monitor - add "Physical Disk" and check:

• Disk Queue - it should be zero or a low number.  If this is *consistently* high,...

We also use replication extensively - between servers here and remotely - and yes, although users aren't dropped, the rights are trashed - a royal pain in the <your word...

This is definately the problem -- if working with Win2K or greater, then you want the latest MDAC (2.7 or 2.8) - downloadable free from Microsoft.

That should clear your problem.

Depending on the speed at which transactions are coming in, and whether they are being logged (bulk inserts are not logged by default), a trigger can be used to "summarize"...

To DEFAULT or not to DEFAULT - that is the question -- answered here in probably the best way possible, "It's up to your preferences".

I straddle the middle of the...

Just some quick thoughts on this issue (I need to get my US tax return e-filed quickly - and this morning )...

You may...

Doing the upgrade on a dev server first, and testing applications is good advice if this is a fresh machine and the applications have not yet run under SP4.  If...

Upgrade to SP4 is a breeze - I've done it 4 times now (on separate servers).

SP4 can be found at:

http://www.microsoft.com/downloads/details.aspx?FamilyID=79c3b1bf-21be-404c-a921-139a6a17f8eb&DisplayLang=en

Unpack and run it.  Note that if there is no...