sp_sproc_columns

Technical Article

RE: Script out logins and users

  • Reply

quote: why not select * from syslogins syslogins doesn't contain the password. I believe you could do something like the following, but I wouldn't mess with it as long as there are easier ways. On source server: DECLARE @binpwd sysname, @sidid binary(16) select @binpwd = a.password, @sidid = a.sid from sysxlogins a, syslogins b where […]

You rated this post out of 5. Change rating

2003-12-29

Blogs

Simple Talks Episode 7

By

The season 1, seventh episode of Simple Talks is out. Check it out, with...

A New Word: the McFly effect

By

the McFly Effect – n. the phenomenon of observing your parents interact with people...

Key mappings in Visual Studio Code

By

At a recent conference I was asked how I executed code during my presentation....

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers