Question: Why does Database Mirroring Monitor report that my mirror is disconnected?
This question was sent to a discussion list via...
2009-02-18
1,601 reads
Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?
This question was sent...
2009-02-17
2,052 reads
Question: If the principal fails while running in high performance mode, what options do I have for bringing the mirror...
2009-02-16
4,545 reads
How Do I Configure SSIS to Work With a Named Instance?
By default, SSIS (SQL Server Integration Services) uses the msdb...
2008-12-11
12,665 reads
How many mirrrored databases can I have on a server?
10 mirrored databases per server is the recommendation for a 32...
2008-11-18
6,404 reads
The following was sent to me by my friend and colleague Dave Miller:
Dave's Email:
Wanted to pass along something I hadn't...
2008-08-21
1,604 reads
Error when importing RegServer list from SQL 2005 to SQL 2008
I discovered the already known bug in SQL 2008 that...
2008-08-19
3,078 reads
Automatic Failover - an incomplete solution
Automatic failover with Database Mirroring is great, but what about all of the other things that...
2008-08-18
2,078 reads
SSIS access permissions are managed via Component Services. It is the DCOM object named MSDTSServer. Here are the steps to...
2008-08-13
45,492 reads
Error Logs Part II -- Enumerating the error logs
In my first post on SQL Server Error Logs, I briefly mentioned using...
2008-04-25
1,739 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers