Viewing 15 posts - 721 through 735 (of 768 total)
Hello SQL DBAs,
I needed little more clear information on this column: 'Msrepl_Tran_Version'.
I configured the 'Transactional Publication with Updatable Subscriptions'. I created the DB: "sourav" and included only one article(table):' tab_pk'....
November 18, 2009 at 2:13 am
I performed the below steps:
(1) Taken the backups of the DB(Mirror) in the Principal Server and Created the same name DB in the Mirror server and tried to restore the...
November 16, 2009 at 3:28 am
Thanks Dipali.
By the way, can you send me the steps to configure the mirroring and also to do the failover(if you have prepared one doc for your reference)?
I'm trying the...
November 12, 2009 at 3:03 am
My purpose is solved by running the below query ::
DBCC CHECKIDENT('table_name', RESEED, 0) --> [0: if I want to start the counter value from 0]
Thanx for all your help in...
October 15, 2009 at 12:16 pm
Very Much Useful Document, Thank you so much.
October 8, 2009 at 8:43 am
Lynn,
Thought I couldn't understand properly from your response how to fix my problem, but thanx for your response.
Can you suggest any doc(PDF) so that I can go through the same...
September 12, 2009 at 11:22 am
Thanks Gail for prividing the links. Much useful.
However, can you please let me know -
--whether any standard metrics (predefined std value) is available to judge the perfmon counter values to...
September 2, 2009 at 6:42 pm
Thanks Adi..The response was quite vivid. 🙂
September 2, 2009 at 12:08 pm
I checked that already. But was looking for some other document containing some real-time scenarios.
Can you please provide one if you are aware of?
September 1, 2009 at 5:43 pm
Hello Raj
Our Sr. DBA team did SQL Cluster Failover to rectify the issue!!
September 1, 2009 at 12:31 pm
No yar, I can't do that even..as batch jobs are running on the server.. and running processes status are in "suspended".
August 31, 2009 at 7:36 pm
Thanks for your response Raj. But the mentioned situation happened on Production only!
Therefore no question of "Recycling the SQL Service", as it will incur temp downtime during the business hrs.
Any...
August 31, 2009 at 7:10 pm
Thanks Mayank, JAson for all your response..
I have noticed one more thinj..
(1) While executing the query as:: DBCC inputbuffer(77)--SPID,
I'm getting one result.
---------------------------------
Output::
Exec ImportComponents '459087',''
(2) DECLARE @HANDLE BINARY(20)
SELECT @HANDLE = sql_handle...
August 31, 2009 at 5:48 pm
Viewing 15 posts - 721 through 735 (of 768 total)