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 is_expiration_checked =...

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?

Ok, that info was in your origenal post. What are you trying to analyse?

no attachement