Viewing 15 posts - 136 through 150 (of 1,158 total)
Any statements executed prior to a BEGIN TRANSACTION statement would not be rolled back. Everything after would be.
It's worth noting every statement has its own implicit transaction and they...
December 23, 2013 at 3:14 am
grantbanjo (9/16/2013)
I have already read the following article regarding replication monitoring, but it was at a higher level than I'm seeking.
If you want to perform simple comparisons I'd look at...
December 19, 2013 at 8:24 am
muthyala_51 (9/19/2013)
you can't setup transactional replication for tables without primary keys. How did it work?
You cant publish articles without a primary key. You could have a subscriber without...
December 19, 2013 at 8:19 am
On our development environment we have weekly full backups and have an automated process to create daily database snapshots.
There is no need to perform all three in one go. ...
December 19, 2013 at 8:16 am
gaddamshiva (12/18/2013)
hi....1. what is diff b/w snapshot,transactional,merge replications in sql server 2008 r2.
2. what is exactly auditing is the server level or database level?
http://lmgtfy.com/?q=what+is+sql+server+auditing+at+the+database+or+server+level&l=1
Sorry....
December 19, 2013 at 3:34 am
CK2 (12/18/2013)
I would use the OUTPUT Parameter approach suggested.It's more appropriate given the circumstances you describe.
I wouldn't use that approach for a simple date calculation. There are no table references...
December 18, 2013 at 10:05 am
You would have to copy a more recent full backup from the live server and restore using NORECOVERY, that should work. There no way of copying DB files and...
December 18, 2013 at 6:52 am
Zohaib Anwar (12/18/2013)
December 18, 2013 at 6:38 am
I'm not sure I follow 100%.
You have a primary db (somewhere) and two secondary's (US & UK). The UK restore has failed for some reason you don't mention whilst...
December 18, 2013 at 6:31 am
Here is my problem, I have some stored procedures where the defintion from this query is not the same as when scripting the stored procedure in an alter statement.
Does...
December 18, 2013 at 1:58 am
The only backup which could adversely affect logshipping is a log backup from another source, such as a manual transaction log backup. This would break the LSN chain.
December 16, 2013 at 7:27 am
happycat59 (12/12/2013)
Unless the index is unique and that subsequently gets violated, it is perfectly valid to have different indexes on publisher and subscriber.
Exactly. Adding indexes on the subscriber is...
December 16, 2013 at 7:25 am
The SSMS route will fail when connecting to the remote server. I would look at using TSQL as this is controllable and you can pick the required steps for the...
December 16, 2013 at 2:48 am
ui ranejeb (12/14/2013)
Here it is a sample:http://sqlhint.com/sqlserver/scripts/tsql/programatically-create-transactional-replication-using
Be careful with this example. It includes far more than you need to add an article to an existing publication.
You only need sp_addarticle...
December 16, 2013 at 2:37 am
Viewing 15 posts - 136 through 150 (of 1,158 total)