I'd suggest a rebuild to get into a known state, and then see what happens.

That's a great link. I'll have to add it in the newsletter. Thanks!

When I was on the East Coast, we made contingencies, but our company could actually survive for a day or two without the systems. So it was harder to convince...

Triggers fire, but depending on what you've coded, perhaps you're missing something. Showing the details will help us decode it.

also, have you checked the code that is used in the...

I believe you can nest 32 transactions. Most other nesting options seem to have stack of 32 (http://msdn.microsoft.com/en-us/library/ms143432%28SQL.90%29.aspx)

What you wrote doesn't make sense to us. We can't see the data, and we can't see the rules or results you need. Based on your first post, I'm not...

If you shrink after rebuilding, you can re-fragment the indexes. When the shrink moves pages, it puts them where it can, so you easily can undo your rebuilding work.

If you...

The ALTER INDEX command is used: http://msdn.microsoft.com/en-us/library/ms188388%28SQL.90%29.aspx

You can also use a maintenance plan to do this. Create a new one that does it on a weekly basis. Or check scripts...

Why should it error out? does the table not exist?

You don't shrink the log for performance. You might want to read this article: http://www.sqlservercentral.com/articles/64582/

You'll have to do some work. I might start here:

http://msdn.microsoft.com/en-us/library/aa214450%28SQL.80%29.aspx

I've typically just had a holiday table since each business handles them differently. It will allow you to easily query for any off days, as Jeff mentioned, that are specific...

If you want to roll your own, you'll need to make multiple passes through the table to clean things up (potentially). You'll need to set rules for how you handle...

SETUSER was my first thought. If it's SQL related, then that covers tracks.

However since so many people use the same pwd on other systems, getting the hash from SQL and...

:-), had to thank Allen publicly for responding to my query.