Is there any reason not to create a pointer or alias for the first server using the SQL browser capabilities, to redirect connections to the second server so as all...

Check to see if there are other jobs with that same service account that are failing or if anything else uses that account where the permissions could have changed at...

There are server variables that can show you total runtime data on CPU, IO, or such (@@idle for example). This is stored in one lump sum as in, total since...

Are you using a domain account for the connection, or local account?

If you have TempDB that is full, you do not want it to grow (or don't have the space), you do not want to add another file on another drive...

Should not stop log shipping, DEPENDING on how you have it setup to transfer the files to another location.

I work with a 210 GB database where I had to manually...

Licensing between 2005 and 2008 has changed regarding instance licensing. The below quote had been taken from the SQL Server 2008 Pricing and Licensing EULA, last updated July 2008. Might...

On top of that, I was looking over stored execution plans and poof... all were wiped out. No one online did a freeprocache or other database equivalent, but the cache...

I am a bit out of my element here, but I did not see anything directly of what is on the bad page. Is the table corrupt or is the...

For the answer to your question, yes, you want in index. If this table is causing blocks, most likely want to take it off the heap, especially if you re...

I used a "cheap" method while I was waiting on Net to get Confio up and running. Do you have Excel 2010 with power pivot that you could query a...

I typically make my own version of sp_who2 that I can run and it gives me the handle stuff already with some code of what is being run, reads on...

sp_help_revlogin << search MSDN KB for this for logins.

Getting all orphans back up... try this (I use something like it I modded from a Pinal Dave Blog, in a different...

I was looking for an out of the box SSIS solution to make sure things were not complicated if I am not around for DR reset. I was hoping that...

Just going to throw this out there since it may be another approach. It has been long since I have done this and recall how to script entirely for you...