Use sp_helprevlogin

https://support.microsoft.com/en-us/help/918992/how-to-transfer-logins-and-passwords-between-instances-of-sql-server

technically, I would think that you would work a half day and then knock off, so if you normally start at 8 am your time, you would knock...

This actually isn't quite right unless you are living in Arizona.  But I think you live in Colorado.  In that case, the proper time zone is "Mountain Standard Time". ...

Strangely, I tried the code and it reported a syntax error... the only thing that didn't was the Convert statement, which didn't give the right time. A niggle, I...

The identity is not necessarily the max value. I can use identity_insert or dbcc checkident(reseed) and end up with different values. The max in the table might be far different...

Are you looking for the max value in a table or are you looking for the last value used? (or next one needed)?

These are different things. The identity doesn't ensure...

• This reply was modified 6 years, 6 months ago by Steve Jones - SSC Editor.

Change is change. Whether its better or not is something we have to evaluate, test, experiment with, and decide. I worry about people getting caught up in thinking we need...

What Jeffrey said. The logins need to match by name. You can script the logins differently or use the ALTER USER or sp_change_users_login to fix things

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-change-users-login-transact-sql?view=sql-server-ver15

Congrats and thanks, everyone, for playing. It was a fun year.

Looks like things are final with :

1. Ditka
2. SSC Ravens
3. Orange Engineers
4. Way0utwest Cowboys

Shhhhhhhhh

Excellent, and thanks

We have them here as well, but sometimes finding the older ones is hard

https://www.sqlservercentral.com/articles/sql-server-build-lists

Merry Christmas and Happy Holidays.

Traveling back from the UK tomorrow and some catchup this weekend, so likely no Star Wars. Two kids home. Might go see it next week when...

I don't know if there are more or less journalists, but there are certainly less traditional journalist jobs that existed for a few generations. That job evolved, and some people...

Well, I'm out of the top two. Good luck next week, but my RB game was weak, and my opponent's, quite strong.