GilaMonster (12/10/2010)

---

SanDroid (12/10/2010)

---

Unfortunately, this opens another can of worms:

What happens when you hide an application feature that a Novice was using somewhere that requires him to make a $250.00 M$...

Personally I'd definitely go with keeping it but take it out of the maintenance plan.

In terms of maintenance plans, I remember when I first started administering SQL and came across...

Fortunately I don't think that advert has made it to the UK yet! I think the biggest problem is that no one has really decided what "The Cloud" is. There...

Not quite sure why everyone else is focusing on tempdb when touchmeknot said right from the start that "I do know that the temp DB grows, however, when I check...

By default the tempdb is set as Simple recovery model, so I doubt the tempdb transaction log file would be the cause.

If you do find it the SQL Server...

Have you seen this :

http://www.sqlservercentral.com/articles/Disaster+Recovery+(DR)/63311/

not sure if it will work for you in your situation, but it's saved my bacon in the past.

I guess the first thing you need to determine is which file or files are taking up the space. Probably worth going through making a note of the space used...

Simply export the Houston database to your new Dallas database using the "Copy objects and data between SQL Server databases" option, and when selecting the objects to copy, leave the...

Well to me at least the send-mailmessage statement looks fine. Have you checked that from that server you are able to send e-mail via that smtp server without logging in...

Completely agree. In a way I think it's almost the most difficult area to deal with, since apart from anything else you're not just dealing with some abstract object, you're...

To be fair, changing from the default values doesn't mean...

Haha, that's a fair point and probably quite true, but it...

I'm surprised no one has commented on the actual article that Steve referenced. Personally it annoyed the hell out of me, especially the headline grabbing conclusions which to my mind...

I've always said that there are three types of computer users :

1) Know little or nothing about computers, admit that fact and will always ask for assistance. They can be...

For me my biggest bug bear in terms of SQL authentication is the apparent assumption from some quarters that Windows Authentication is always the answer, that there is no legitimate...