Thanks for the response. I agree SSMS isn't great, but I know where the sharp edges are and it works well. ADS feels limited to me, and semi-functional. It works...

Nothing to do with the question, nor the fact that it is Christmas:

Does anyone else find that the "Stay signed in" option has ceased to function over the past...

Merry Christmas, everyone. Hope you enjoyed it

Merry Christmas to everyone, Happy Holidays, and congrats to the top 3.

I'll get prizes out after Christmas.

I think Agent works really well in many cases. There are enterprise schedulers, and most cost money because they handle complex things. I agree, it's generally worked very well for...

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, 8 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