hi all-
is there any way to, as the subject so subtly states, force valdation to
fail? mind you, i don't want a false positive (failed validation message
with no data discrepancies) - i want to somehow prevent records from getting
replicated around, if possible. i'm trying to test ways of solving failed
validation issues, and need as many test cases as possible.
i'm dealing with anonymous merge subscriptions if that makes a difference...
thanks in advance,
-ben
Ben,
you could temporarily modify the merge trigger so your data change is not
logged or do a bulk insert without the FIRE_TRIGGERS option.
HTH,
Paul Ibison
Showing posts with label mind. Show all posts
Showing posts with label mind. Show all posts
Wednesday, March 28, 2012
Monday, March 12, 2012
How to find out the current recovery mode for a given database
Never mind, I found it from an old post:
SELECT DATABASEPROPERTYEX('Mydb', 'Recovery')
"Zen" <zen@.nononospam.com> wrote in message
news:u%236G$sllGHA.3588@.TK2MSFTNGP02.phx.gbl...
> Hi,
> Would you know how I can find out if my database is set with full or
> simple recovery mode? Thanks!
>Hi,
Would you know how I can find out if my database is set with full or simple
recovery mode? Thanks!|||Never mind, I found it from an old post:
SELECT DATABASEPROPERTYEX('Mydb', 'Recovery')
"Zen" <zen@.nononospam.com> wrote in message
news:u%236G$sllGHA.3588@.TK2MSFTNGP02.phx.gbl...
> Hi,
> Would you know how I can find out if my database is set with full or
> simple recovery mode? Thanks!
>
SELECT DATABASEPROPERTYEX('Mydb', 'Recovery')
"Zen" <zen@.nononospam.com> wrote in message
news:u%236G$sllGHA.3588@.TK2MSFTNGP02.phx.gbl...
> Hi,
> Would you know how I can find out if my database is set with full or
> simple recovery mode? Thanks!
>Hi,
Would you know how I can find out if my database is set with full or simple
recovery mode? Thanks!|||Never mind, I found it from an old post:
SELECT DATABASEPROPERTYEX('Mydb', 'Recovery')
"Zen" <zen@.nononospam.com> wrote in message
news:u%236G$sllGHA.3588@.TK2MSFTNGP02.phx.gbl...
> Hi,
> Would you know how I can find out if my database is set with full or
> simple recovery mode? Thanks!
>
Subscribe to:
Posts (Atom)