Check to see if you have an anti-virus or other product that is blocking port 25 on your machine.

The performance benefits and the space savings. I've always found it difficult to get additional storage on our SAN, so compression gives me a lot more leeway from a time...

You can just open SSMS query window and run a sp_helptext against the view to see the code.

Ask the guys who built the server would be my first suggestion 😀

Depending upon the hardware vendor they may have tools that can be installed on windows that can retrieve...

If you are going to do something like that you should put...

Why not just set a default on the column for the date that you want?

I've been that human being (well if you can call me that) that sits there overnight to check on alarms and make sure that they are valid before notifying someone.

It's...

I'm not sure how you could.

To move the log ship files you need to be able to move the physical log dumps between two locations, or be able to access...

The trouble is that there really isn't a perfect monitoring solution.

Tivoli for example may look at an application being down and associate it to SQL even when it's not a...

Your problem appears to be right here

failed with the following error: "Could not find server 'ErrorLog' in sysservers.

It looks like you have a stored procedure called "GenerateErrorHandling" which utilizes a...

Create two different folders and put the contents of each into a different folder.

There are articles around about the best folder structure for the two (ie put one in a...

Don't let the commonality of some of the files deceive you, one CD is the tools and the other the server.

You could extract both .ISO images to a drive and...

Or select left(foo, 5) from bah

The question was a tad ambiguous at best.

How about use a longer password, or setup with Windows authentication only?

Awesome stuff. Man I hate group policies.