Viewing 15 posts - 46 through 60 (of 782 total)
SQL_Surfer (2/17/2012)
Thanks for the information. Does SQL server stores the hung state in any of its tables?
See this :-
http://www.mssqltips.com/sqlservertip/1949/sql-server-sysdmoswaitstats-dmv-queries/
Regards,
Skybvi
February 17, 2012 at 7:32 am
If you want to check the jobs hung, you can just go to sql server agent and see the job activity monitor
and see the status of hte job ( idle...
February 17, 2012 at 7:02 am
John Bates-251278 (2/10/2012)
The Linked Server connection is working well without me making any changes.We can close this post.
Thanks, John
How come ??
Regards,
Skybvi
February 13, 2012 at 6:31 am
Jinu43 (2/10/2012)
I have same issue.Where did you forced the restore option or which changes you made on primary server??
Thanks in advance.. 🙂
You can do the 1st restore log after full...
February 10, 2012 at 10:03 am
halifaxdal (2/10/2012)
Up
IS it working now?
What was the fix?
Regards,
Skybvi
February 10, 2012 at 8:50 am
John Bates-251278 (2/9/2012)
On a 2000 instance, I created a linked server to a 2005 instance on another...
February 10, 2012 at 5:57 am
Anamika (2/9/2012)
I have a DB Server with 64 GB RAM. the HDD is partitioned as C: 26GB and D:108GB. I have SAN with 1TB (clustered). many times...
February 9, 2012 at 12:32 pm
Thanks Sean and Gail.
Just 1 question more,
Would the case be different if I am updating 2 tables which have triggers attached to them whcih fire upon updating the particular columns...
February 9, 2012 at 6:06 am
GilaMonster (2/8/2012)
Yes.
Thanks.
Then these begin and rollback transactions are used for whcih TSQL statments??
Regards,
Skybvi
February 8, 2012 at 1:58 pm
GilaMonster (2/8/2012)
Delete from tableabcd where starttime <= 2011/07/01That's all you need. Deletes are atomic, they complete or rollback as a single operation. A delete can't partially succeed.
hi gail,
...
February 8, 2012 at 1:52 pm
halifaxdal (2/7/2012)
Issue persists, no more clue?:crying:
Did you follow closely what lowell told about changing Port number?
Regards,
Skybvi
February 7, 2012 at 1:59 pm
halifaxdal (2/7/2012)
when I telnet the server with port 1433, it gives me a blank screen other than a blinking cursor, is that normal?
Yes, its normal.
Regards,
Skybvi
February 7, 2012 at 12:32 pm
Bru Medishetty (2/7/2012)
Let's say the execution...
February 7, 2012 at 12:30 pm
halifaxdal (2/7/2012)
SKYBVI (2/7/2012)
halifaxdal (2/7/2012)
I did some configuration on Windows Firewall, not sure if I did it correctly, it is still not working, please see the attachments for the screenshots.Thanks.
Can you...
February 7, 2012 at 11:51 am
halifaxdal (2/7/2012)
I did some configuration on Windows Firewall, not sure if I did it correctly, it is still not working, please see the attachments for the screenshots.Thanks.
Can you do this...
February 7, 2012 at 9:34 am
Viewing 15 posts - 46 through 60 (of 782 total)