And I was actually questioned about why I would bother posting today's editorial[/url].

Why aren't you taking backups of the system?

Speak of Murphy and he will appear. Right...

If he runs scripts to create procedures like this:

CREATE PROCEDURE MyProc ...

instead of like this

CREATE PROCEDURE dbo.MyProc ...

--or

CREATE PROCEDURE myschema.MyProc ...

You'll see what's occurring. It will create the...

When this happens, you actually need a little bit of space to shrink the tempdb and you might not have it. One option would be to add another file to...

People have to set up the backup, monitor it and fix it when it goes wrong. The actual execution should be scheduled and automated, you're right. But far too many...

BWA-HA-HA-HA

That was good.

To the Denizens of The Thread, posters & lurkers, may you all have a happy new year and many happy returns of the day.

And to the posters, with their urgent,...

Shut down the server, muck with the file using an editor as Steve said, restart the server. Tada. Totally hosed database.

Just adding a note to your original question and the excellent answer already provided.

Not only can you restore up the chain in terms of versions, but you can restore...

Excellent, excellent, excellent post. Nothing is more important than verifying backups, except, verifying that you know how to run a restore. You're absolutely right when you say that backups are...

Lynn Pettis (12/29/2009)

---

Congrats Gus. How about sending some of that good luck my way. Can't seem to catch a break at all.

Kassondra was in a car accident Sunday...

GSquared (12/29/2009)

---

For anyone here a month or so ago, I have good news on the employment front. Starting a new job with a much better company in mid-Jan. ...

I agree, I'd start with Maintenance plans since you're just starting out.

The mechanism for scheduling operations within SQL Server is a service called SQL Server Agent. By default it's installed...

You don't mean sp_configure do you? All the SQL Server settings, memory allocation, all that stuff? Or are you really looking even lower level at the server instance itself? If...

You will still need to update statistics. I'm pretty sure the...