I created a blog for people interested in joining the project. If you want to join just send me an email at brenbart@yahoo.com.

http://sqlservergui.blogspot.com

Is there a stored procedure in the database that kicks off the month end routine? If so you'd just be able to muck around with that and fire it...

First to answer your question: No, I've never heard of any software that would do that.

However, could you change the way the month end kicks things off?

Meaning...

Oops! Didn't mean to do that. I was just checking to see if I could.

What do you have checked on the reporting tab of the maintenance plan?

I actually noticed and undocumented stored procedure called xp_execresultset.

You can't see the code since it's an extended stored procedure. (xprepl.dll) My guess is that it runs a...

In Enterprise Manager-SQL Server Agent-Jobs look at the specific jobs that failed. Right click and check the job history. Also check the SQL Server logs as well as...

I tried subscribing and kept getting some sort of cookie error when I tried to confirm. I emailed the help address and got some useless spam back that essentially...

It seems like sql server ought to be able to this by itself since as part of replication process you can have it "compress" snapshot files. Of course BOL...

RE: sp_attach_single_file_db

It actually works either way.

According to BOL the only difference is that sp_attach_single_file_db automatically does some cleanup with replication. This only matters if you are doing replication and...

Just for the heck of it I typed the url http://www.db2central.com.

I came up with a plain looking Login/Password page. It makes me wonder...

Are there DB2 sites like this out...

Ok, last thing I'm going to say on this then I'll leave the dead horse for others to beat.

Sure, you can do it without a while loop but when did...

Senior DBA: Grey hair, cautious to the point of paranoia, never volunteers for anything not strictly database related and has a tendency to chitchat about normalization.

Junior DBA: Younger, willing to...

Now why did the multiple spaces get removed?

'Have___a__Nice_day!' to

'Have_a_nice_day!'

When I wrote this originally I was scrubbing some data that had a ton of problems like this. It had been...