Yes and no.

I used to work for a not-for-profit company that had SQL Server and Access, but no decent devleopment tools. (Couldn't/wouldn't pay for decent MS tools, so had...

Hey! How come nobody is mentioning how good Access is!? :hehe:

Are you talking specifically SQL backups, or file backups also?

In any case, whatever you do, I would get a seventh server specifically for backups. Or a good tape drive...

Has SQLPrompt improved in the past several years? I tried a free trial of it 3 or 4 years ago. It worked pretty good, but I found it...

I've installed just the management tools before and not had a problem.

I don't remember if the intellisense will work on a SQL 2005 database or not, but it...

Yeah apparently a different person. Which is why I pointed out the user name. Guys like that need to be slapped, but I really want to see their...

Agreed.

The cases where I would use that RAISERROR would be when I'm running admin scripts that I only run very infrequently.

I've done similar (though less fancy) things with...

I never did find a way to get the print statement to happen immediatly, but this article tells how to accomplish basically the same thing wiht RAISERROR with the NOWAIT...

I thought this was a good tricky one. 😛

Has anyone used shared scalable databases? It's something I've been mildly considering on and off.

Anything interesting in the Windows event log, or the SQL logs for the time that this happened? Or didn't happen as the cas may be...

Grant Fritchey (1/6/2009)

RBarryYoung (1/6/2009)

GilaMonster (1/6/2009)

Which edition...

If it's showing up in the history, then it sounds like it's running.

Perhaps it's immediatly failing, or starting then immediatly stopping?

If you drill down into the details of...

If you right-click on the job in SSMS, and hit view history, does it come back with anything at all?

I have a server that gets rebooted every Sunday at 4AM that is hanging up somewhere in the process. If we go into the server room, point the KVM...