Yes, you can put three maintenance tasks in your one maintenance plan. If you double-click on your maintenance plan, you can edit it to add the extra steps to...

It's been a LONG time since I upgraded from Sybase to SQL Server. I went from ASE 10 (I think) to SQL Server 2000 (the newest version at the...

First baseman? The Orioles have a first baseman - when this did happen 🙂

We haven't had a "real" first baseman all season (okay - and still don't). But...

For what it's worth, we started doing simple formatting like this within the database code as well for pretty much the same reason - it's less hassle to implement database...

John,

I'm not sure this will help you as I'm not sure this is the same problem. The problem I had was a developer could not run a SQL Agent...

As previous stated, there are quite a few links on this forum that address this issue. This is one of my favorites.

http://www.sqlservercentral.com/Forums/Topic914723-391-1.aspx

Cindy

I suggest creating a format file. I don't know if what you're trying to do "should" work without it, but in the past, I have always used format files...

I don't have an answer for the specific error, but I have some suggestions on what you can try.

1) Have you confirmed the MSCS cluster failovers and...

I had to research it the first time. At least this time, I knew the answer. My biggest excitement - actually remembering something "all the way" back to...

You're on the right path.

1. What is the difference between All instances & Select instances from the list?

"All instances" is the same as selecting each entry in...

Perry,

Thanks for the response (And yes - I do read your articles!)

The first question is the biggest point of contention. I don't personally feel we need a...

As an Oriole fan (said with bag over head), I can relate...

Shawn,

You beat me to my favorite - followed by - "Let's reboot the database server to see if it fixes it" ( where...

Responding to a post I started in May. I have the resolutions (well, sort of...). While I'm pretty sure I'm the only on this forum who cares, I'll...

Per BOL - sysadmin, db_owner, and db_ddladmin will all work.

http://msdn.microsoft.com/en-us/library/aa258259(SQL.80).aspx

Cindy