Remove Replication:
Its quite some time that I blog… but good news is I have some good stuff to blog on… so...
2009-12-16
12,477 reads
Its quite some time that I blog… but good news is I have some good stuff to blog on… so...
2009-12-16
12,477 reads
Everyone who wants to know about how transaction replication works and how to improve the performance of transaction replication must...
2009-12-03
2,158 reads
I realize that we all should know when the support of Microsoft sql server will expire. we should have this...
2009-11-13
702 reads
Today I was just thinking about to know what is the difference between sql server vs.. other DBMS/RDBMS. so thought...
2009-11-04
1,413 reads
Today I was just thinking about to know what is the difference between sql server vs.. other DBMS/RDBMS. so thought...
2009-11-04
1,989 reads
Trigger:
When you create trigger for insert and delete we will get two reference table as “inserted” and “deleted” respectively now...
2009-10-30
1,507 reads
I saw too many questions on forum asking step by step process of configuring replication I have these links in...
2009-10-28
1,145 reads
Today was browsing the Blog http://blog.sqlauthority.com/ Pinal Dave expert on Sql server and great Blog writer. Got surprise to see...
2009-10-23
660 reads
I write several blog about replication and mansion commands and stored procedure related to transaction replication, but I would like...
2009-10-23
1,351 reads
This blog is having some useful commands we use for replication and troubleshooting.
>>Some useful commands and stored procedures
How it works:
Log...
2009-10-23
18,578 reads
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item Planning for Change
Comments posted to this topic are about the item Importing Excel files into SQL...
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers