Is there actually a backup exec database or is it using the MSDB database. It appears from your error that it is MSDB. Are you seeing the error consistently? Odd...

Sounds like you are looking for a pretty serious audit solution. There are some that like to home-grow theirs but that can be a bit tedious and ultimately you will...

Funny, I had not looked at this before but in reading BOL the functionality is very similar. From what I remember Oracle had similar functionality and the Oracle DBA's that...

Just saw this solution on Buck Woody's blog site. Thought it was probably too late for you but not for others. This doesn't exactly fit your problem as you were...

Very sorry about that. The link I was referring to was http://support.microsoft.com/kb/918483.

Not so sure that applies based on the errors that you provided.

Have you installed the performance dashboard...

Did you select to have the snapshot created immediately when you created your subscription? If so, then it sometimes takes time for the snapshot to be developed and it will...

Are your SQL Server Error Logs clear or are they any errors that can be noted here?

I would be curious if this KB article applies.

I almost hate posting this but.... After you are done with all your maintenance, indexes, dbcc, make sure you take a backup before you release the converted databases to your...

Glad to hear that the rewrite helped.

Very much agree with Jeff in that looking at Execution plans and query costs alone can be dangerous especially when changing things bring...

Loosely quoted from Steve "I don't know how to change it in this generation". Nor do I as a whole BUT, I can within my own family and that is...

I have two work laptops running XP Pro and one laptop personal / work running Windows Vista Ultimate. I don't mind it but it certainly isn't something that I would...

There is a great function here - http://www.sommarskog.se/arrays-in-sql-2005.html that works well and I'm sure you could tweak it to charindex on the "/" rather than comma's. If this is a...

Wouldn't DTS be a better option? Seems somewhat security risky all the way around and putting a lot of work into a VBScript which there are utilities to do. Just...

You could insert the output of sp_spaceused (consider using sp_MSForeachtable to get this data) and then create a string to execute based on some logic that would include looking at...

Sorry but according to 2008 BOL it states "You cannot import registered server information into SQL Server 2008 from earlier versions of SQL Server."

Hopefully you don't have a bunch to...