I would agree with David.

If the local service is the agent service account and local admins are removed from sysadmin that would cause issues.

What is thhe service account for...

For the ease of troubleshooting (and since you are using SQL logins anyway) can you please use (if you have it) or dl from MS if you havent SP_HELP_REVLOGIN (specific...

I use this to turn off password expiration for all users.

You may modify as needed:

DECLARE @sql AS VARCHAR(500)

DECLARE @current_user AS VARCHAR(50)

DECLARE Reset_expiration_cursor CURSOR FOR

SELECT name FROM sys.sql_logins --WHERE...

Duplicated post?

Please see mmy response http://www.sqlservercentral.com/Forums/Topic1243935-146-1.aspx

Sorry if this has already been stated but what user are you using (AD or SQL)?

Also where are you trying to create the LS (on the server or remotely)?

Are you...

sjimmo (11/2/2011)

---

Didn't realize that I am being elitist.

Yes, I am a Sr DBA - why? Because my company says so. What makes me one, act of a...

sjimmo (11/2/2011)

---

adb

Would you expect your junior DBA to know about disk partition alignment, NTFS cluster size, RAID types,

TempDB - placement and number of datafiles, NUMA, instant file initialisation, AWE,...

Cheeky 😉

jasonmorris (10/19/2010)

---

"Anyone doing a backup/restore with SSMS wizzard will have a (very) bad point (unless he uses it just to generate the script, then he's lazy -> good point)."

What is...

Isnt that what i said?

And yes, if yoou only wanted to restore 'certain' details, that would be transactional replication.

- Win. (10/18/2011)

---

Granting EXECUTE permission on a stored procedure:

The following example grants EXECUTE permission on stored procedure

HumanResources.uspUpdateEmployeeHireInfo to an application role called Recruiting11.

[font="Courier New"]

USE AdventureWorks2008R2

GRANT EXECUTE ON OBJECT::HumanResources.uspUpdateEmployeeHireInfo

...

WHITE_DRAGON999 (10/18/2011)

---

Would love to take a risk; there are so many times when I feel I just want to walk out that door and see where it will take me....

Your going to raffle off a flight on Virgin Galactic to a DBA who correctly answers questions over a 5 week period?