How to move the MSDB database
First we need to know the name and file location of the MSDB database files. When you change the location, make...
2011-07-13
943 reads
Ryan Adams
How to move the Model Database
First we need to know the name and file location of the Model database files. When you change the location, make...
2011-07-12
6,162 reads
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...
2011-07-11
1,343 reads
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...
2011-07-06
1,285 reads
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...
2011-06-14
695 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers