Jayanth has the protocol here. Contact support and ask, but I wouldn't be surprised if they didn't do this. The CUs have been tested, and I'm not sure they'd go...

You might check out Ola's scripts. Lots of people use them instead of maintenance plans

http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/

Can you connect to "(local)"

I'd give it back. Ultimately it doesn't mean as much to me as to the player.

Visual Studio installs SQL Server Express as part of it's package.

The .\SQLEXPRESS is a named instance. The MSSQLSERVER should be the default instance you installed.

The maintenance plans are fairly basic and resolve the database names when the plan is built. It's one reason why so many people avoid them as they advance in their...

Peter Maloof (7/9/2011)

---

Wow! Talk about doin' it in style! Congrats, Jeet! Only the second person to have their 3,000^th hit be a home run!

I predicted an infield single on July...

If you use Configuration Manager to assign the account, it should add the rights.

If you use log shipping, the account will need read/write access to the folder where it stores...

WayneS (7/8/2011)

---

Does this mean...

that is great. A nice read

Umm, should I disable a few accounts today?

BTW, this is interesting: http://gigaom.com/cloud/facebook-trapped-in-mysql-fate-worse-than-death/

TGIF

Actually not so much. Leaving for the UK on Sunday, will be out of touch for most of the next week. Behave.

Be aware that indexed views are good, but if you use them, you are increasing the load on your database. This view has to be maintained whenever you change data...

I've not had an issue with service accounts and saving passwords, except when I have shared accounts.

Make sure that you pick a domain account that DOES NOT have "change password...