Viewing 15 posts - 1,336 through 1,350 (of 1,790 total)
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 27, 2008 at 8:56 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 27, 2008 at 8:49 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 27, 2008 at 8:42 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 27, 2008 at 8:23 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 27, 2008 at 8:14 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 26, 2008 at 3:41 pm
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.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 26, 2008 at 3:30 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 25, 2008 at 10:53 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 25, 2008 at 9:41 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 25, 2008 at 8:12 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 25, 2008 at 7:53 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 22, 2008 at 3:01 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 22, 2008 at 2:56 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 22, 2008 at 2:48 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 22, 2008 at 11:59 am
Viewing 15 posts - 1,336 through 1,350 (of 1,790 total)