Viewing 15 posts - 136 through 150 (of 1,790 total)
I wouldn't consider option 2 workable or even possible. I haven't tried it but I'm guessing that the command will be rejected, hopefully. Regardless, I wouldn't try it.
As to...
February 14, 2012 at 11:23 am
sunny.tjk (2/10/2012)
I've the following events and no filtersSQL:BatchStarting
SQL:BatchCompleted
Audit Schema Object Access Event
Existing Connection
RPC completed
Audit Login
Audit Logout
Unless you are looking for connection information to be collected I would remove the Audit...
February 10, 2012 at 9:49 am
What events do you have selected and do you have any filters in place aside from the default?
February 10, 2012 at 9:07 am
Ok, I understand the DR replication solution you are using.
For the replication suggestion, you would create scripts for your publication and subscriptions. However you would change the @sync_type property...
February 2, 2012 at 10:11 pm
Actually, the trigger that I wrote was wrong for another reason, i.e. I wasn't summing the values for the multiple invoice entries per customer but it wouldn't have (and didn't...
February 2, 2012 at 9:34 pm
Typically most SAN replication includes the option of KEEP_REPLICATION in their database recovery models. With that being said the best way that I can think of that you can keep...
February 2, 2012 at 2:40 pm
I actually think it is a little easier than that but please ensure that what I am doing is what you need.
alter trigger trg_UpdateCustBalance
on dbo.invoice
for insert
as
set nocount on
begin
update...
February 2, 2012 at 2:24 pm
There should be no difference between the two. Definitely a mystery......
December 19, 2011 at 11:43 am
Wondering if somehow it doesn't execute the Reconfigure when using the GUI.?.?
Very odd but glad that helped.
December 19, 2011 at 11:31 am
Have you read this - http://sqlserver-qa.net/blogs/replication/archive/2009/02/11/5327.aspx
Let me know what you find. Thanks.
December 19, 2011 at 11:05 am
Barkingdog (12/4/2011)
Our company just installed SnapManager for SQL last week. (I have never used the product before, I'm not familiar with their distinction bewteen aggregate, Volume, and LUN, but...
December 5, 2011 at 6:38 am
Dev (12/2/2011)
Literally I must kick myself (if I can) for not knowing major fact about a forum where I spend most my time.
I guess I understand but the...
December 2, 2011 at 6:21 am
The first question that you have to ask is what you are looking to monitor. I know that SolarWinds has some alerting and monitoring that plays well with SQL Server...
November 30, 2011 at 3:55 pm
Viewing 15 posts - 136 through 150 (of 1,790 total)