I Have setup a remote distributor for my replication setup with the Backup with Sync option enabled. I am taking full backup of distribution db once...
I have the following replication setup in my PROD Servers. ServerA -> ServerB -> ServerC ServerA is the Publisher ServerB is the Distributor. Push...
I have the following replication setup in my PROD Servers. ServerA -> ServerB -> ServerC, ServerD, ServerE, ServerF ServerA is the Publisher ServerB...
I have a user database in DEV and UAT environment. Copy of UAT database is restored on DEV. There is a query that runs for 1 second in DEV and 34...
I have a user that has showplan privileges but not able to access the databases. Pls help. List of steps i did... Created a SQL Server Login by the...
I got an error while executing a Job that is accessing (SELECTing) a linked server table. Error Message Msg 229, Sev 14, State 71, Line 1 : SCHEMA...
When i use a self-mapping from ServerA -> ServerB, What would be the login id that will be linked on ServerB for my local login on ServerA? Say...
We have a transaction replication setup which has 4 publications. In one of the publications (which already has 6 articles), we are trying to add an...
i am getting an error while executing a job that runs a piece of code accessing a Linked Server. Error and Code below... Error Message Msg 7421, Sev...
Hi All, On Friday we configured Transactional Replication for one Publisher/Distributor and 2 Subscribers in production. We configured Replication...
In one of the production servers, we have mirrored sessions on one database. The Principal & Mirrored Server are in SP2 and we are planning to...
Currently i have limited access (View Definition on few DBs, View Server/Database State, ShowPlan) to one of the PROD Servers i support. Replication...
I have a set of DMVs that is executed by a set of users. And i need to give them View Server State access for those DMVs. Is there any way i can...
I have Developer Edition and for testing DB Mirroring i installed two instances (. and ./TEST) in my workstation. Since DEV-Ed needs enable T1400 at...
Can i add multiple email ids in the same operator? i dont have any permissions on exchange server but i need to send notifications on job failures...
I have a database backup maint plan in one of our servers which has two tasks. the first one is a T-SQL task that would move all the backups files...
I have a Windows Domain group APPDBA. This APPDBA group is having sa privileges in one of the database servers. Now, that everybody needs access to...
In one of our Production Server we have 12 user databases. Yesterday i configured mirroring for one database. After the mirroring was successfully...
How do I find which version of SQLXMLBulkLoad is installed on my server? pls respond...
declare @var bit select @var = 0 if ISNULL (@Var,'') = '' print 'yes' else print 'no' the result is yes when i pass 0. But when i pass 1 for @var,...
Separate names with a comma.
