The script includes these steps: STEP 1: CREATE EMPTY Databases STEP 2 - CREATE Logins WITH SERVER ROLESPERMISSIONS STEP 3 - COPY LINKED SERVERS STEP 4 - COPY SERVER OPTIONS STEP 5 - COPY CREDENTIALS STEP 6 - COPY AGENT JOBS STEP 7 - COPY DB Mail STEP 8 - COPY CERTIFICATES STEP 9 […]
2020-05-22 (first published: 2020-05-13)
354 reads
The script includes these steps: STEP 1: CREATE EMPTY Databases STEP 2 - CREATE Logins WITH SERVER ROLES\PERMISSIONS STEP 3 - COPY LINKED SERVERS STEP 4 - COPY SERVER OPTIONS STEP 5 - COPY CREDENTIALS STEP 6 - COPY AGENT JOBS STEP 7 - COPY DB Mail STEP 8 - COPY CERTIFICATES STEP 9 […]
2020-05-22 (first published: 2020-05-12)
1,095 reads
Greg Larsen shows you how to determine if you are running the standard, enterprise, or developer edition of SQL Server.
2017-03-02
3,772 reads
By Steve Jones
After my wallet misadventures, I ordered a Tile Slim to track my wallet. It...
Although I don’t write about it much on this website, I am on the...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Is there a better way to write this nested join query? I'm concerned about...
Hello I've inherited some dev environment which looks like was abandoned, but I'd like...
The script runs but gives me "no data to export" I see data in...
Ask SSC