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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 14, 2012 at 11:23 am
Great. Glad that worked.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 10, 2012 at 10:18 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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 2, 2012 at 2:24 pm
I like your idea about Habitat for Humanity Steve.
I have one of those "dream jobs" when it comes to technology, great use of technology, busy with challenges, work from...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 13, 2012 at 6:43 am
There should be no difference between the two. Definitely a mystery......
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 30, 2011 at 3:55 pm
Viewing 15 posts - 136 through 150 (of 1,790 total)