That may be possible. When the system first got here, I assumed that their people knew what they were doing with SQL Server and didn't bother to look at...

Thanks for the confirmation. I'd read through the BOL documentation on all the options, but just wanted confirmation that I was reading it all correctly.

Haha. Funny you should be the one to reply. I'm looking at their backup jobs with the intention of moving them to SQL Backup. Great product at...

Ha. The statement was generating a table scan for one table (the child with the grandchild hanging off of it). I indexed the column it was scanning, and...

I just ran across the link below, which confirms what I was afraid of. The rowlock will tell sqlserver where to start with locks, but the server can escalate...

We probably could get out of the way for an insert every 9 seconds, but the interval isn't guaranteed to be 9 seconds. It could be less than that....

My question is more about if its possible to get the schema and save it via t-sql or DTS. You can't easily automate generating scripts from enterprise manager or...

C:\Inetpub\mailroot\Badmail or wherever you have inetpub set up for.

There are 2 places to setup mail. one is under suport services, where you select the profile. This one...

You could technically use DTS to export the data out of a table to CVS file or anything you can imagine. That wouldn't export the schema, though. Is...

Thanks for the suggestions.

We've tried paring down what we delete to something very small (a handful of the parent records with all associated records), but since data is coming in...

Is there anything in the windows event log?

The whole point of this is to allow me to do aggregates based on a shift. Our shifts run 8 to 8 (ie, 8AM to 8PM to 8AM) and...

That works, too. And its 11 characters shorter! Don't have that large of a resultset, so I don't see a performance difference (at least right now... this...

The network is a train wreck. The plant was built and then people started adding computers, then they started plugging them together. It has slowly evolved into the...

That'll do it. And much more cleanly than anything I would have come up with. Or at least much less code...

Muchos gracias, Señor!