Viewing 15 posts - 496 through 510 (of 1,790 total)
NJ-DBA (8/18/2010)
There must be some way to govern how many changes it makes before committing a transaction...
Open Replication Monitor and look at the Subscription Watch List tab for the publisher...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 18, 2010 at 5:01 pm
sqlservercentral-606110 (8/18/2010)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 18, 2010 at 11:02 am
vishal.gamji (8/18/2010)
You could create something yourself based on the sys tables
Sounds painful. There are companies out there that make big money doing this so not sure that I would want...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 18, 2010 at 8:32 am
TABLEDIFF - Comes free with SQL Server. Check it out in Books Online.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 18, 2010 at 8:22 am
Perry Whittle (8/18/2010)
you need to add that drive as a dependency to the SQL Server instance you wish to use it on.
Yeah - I figured as much as well and...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 18, 2010 at 8:19 am
Via script try creating a database to that drive and let me know what you get for an error.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 18, 2010 at 8:11 am
IF there are queries / statements being executed that have the password in them then that is what they should be focusing on, not keeping you from seeing the execution...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 17, 2010 at 9:13 am
ashish.kuriyal (8/17/2010)
then in that case I think we need to setup the auditing on every connection getting connected to database.
Indeed. The only way to guarantee that you are getting all...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 17, 2010 at 9:01 am
Well, that kinda works. It really doesn't guarantee that you are catching every connection to that database. That will provide you a list of all that are presently using the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 17, 2010 at 8:46 am
niyinks (8/17/2010)
I have read the new link and still am slightly out of my depth, please could you just give pointers on how to get the table into the desired...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 17, 2010 at 6:40 am
Hehe - after checking Gila's post it appears she posted the wrong link. Try this one;
http://www.sqlservercentral.com/articles/Best+Practices/61537/
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 17, 2010 at 6:11 am
niyinks (8/17/2010)
No idea about the clustering but my last post describes the national table
I'm not sure if you know this but this forum is supported by people that are giving...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 17, 2010 at 6:09 am
Twinsoft SME (8/13/2010)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 13, 2010 at 1:45 pm
Huge disclaimer: I don't know the support that MS offers for this!!!!
I have done some research recently on this due to a consideration of putting tempdb on SSD's and...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 13, 2010 at 11:57 am
Thanks Paul and Gail. Definitely great observations. Not sure if the OP is even following the thread but I certainly appreciate it. 😛
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 13, 2010 at 6:59 am
Viewing 15 posts - 496 through 510 (of 1,790 total)