First we need to know the name and file location of the Model database files. When you change the location, make sure to keep the same name. […]
Category: SQLServerCentral Syndication
All posts in this category get syndicated to SQLServerCentral.com
How to move the Master database
The catch to moving the Master database is that you must also move the Resource database. Microsoft states that the Resource database must reside in […]
How to add your CMS server to a group
You cannot add a connection to your CMS server, on your CMS server. Well that is what I thought until SQLSaturday in Houston, where John […]
T-SQL Tuesday Mirroring and SSWUG
This month’s T-SQL Tuesday is hosted by Allen Kinsel (Blog|Twitter) and covers “disasters and recovery”. My favorite DR solution is mirroring. Mirroring is easy to […]
My DSN Does Not Work on Windows 64bit
How to create a DSN on Windows 64bit for your 32bit application
When to use SQL Mirroring Timeout
How to set SQL Mirroring TIMEOUT and 2 scenarios where you want to.
Automate SQL Logins to DR Site
Here is how to automate copying your SQL logins to your DR server.
The Ugly Truth about “Run As” – Part 3
No safe option in Windows 7 to run as an alternate user.
The Ugly Truth about “Run As” – Part 2
“Run As” was removed from Windows Vista! SysInternals has a fix.
The Ugly Truth about “Run As” – Part 1
“Run As” is not as secure in Windows XP as we thought
You must be logged in to post a comment.