Showing posts with label mind. Show all posts
Showing posts with label mind. Show all posts

Wednesday, March 28, 2012

How to FORCE failed validation?

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

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!
>