Forum Replies Created

Viewing 15 posts - 46 through 60 (of 783 total)

  • RE: Find Hung Jobs

    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

    Regards
    Sushant Kumar

    February 17, 2012 at 7:32 am

    #1448496

  • RE: Find Hung Jobs

    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...

    Regards
    Sushant Kumar

    February 17, 2012 at 7:02 am

    #1448474

  • RE: Linking SQL Server 2000 to 2005

    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

    Regards
    Sushant Kumar

    February 13, 2012 at 6:31 am

    #1446201

  • RE: Log Shipping 'skipping' all logs and not restoring

    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...

    Regards
    Sushant Kumar

    February 10, 2012 at 10:03 am

    #1445677

  • RE: Why remotely connecting to SQL 2005 express failed?

    halifaxdal (2/10/2012)

    Up

    IS it working now?

    What was the fix?

    Regards,

    Skybvi

    Regards
    Sushant Kumar

    February 10, 2012 at 8:50 am

    #1445629

  • RE: Linking SQL Server 2000 to 2005

    John Bates-251278 (2/9/2012)

    This should be easy but maybe I have forgot a lot about version 2000.

    On a 2000 instance, I created a linked server to a 2005 instance on another...

    Regards
    Sushant Kumar

    February 10, 2012 at 5:57 am

    #1445491

  • RE: Ideal C: for SQL Server

    Anamika (2/9/2012)

    Hi,

    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...

    Regards
    Sushant Kumar

    February 9, 2012 at 12:32 pm

    #1445242

  • RE: Transaction

    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...

    Regards
    Sushant Kumar

    February 9, 2012 at 6:06 am

    #1445020

  • RE: Transaction

    GilaMonster (2/8/2012)

    Yes.

    Thanks.

    Then these begin and rollback transactions are used for whcih TSQL statments??

    Regards,

    Skybvi

    Regards
    Sushant Kumar

    February 8, 2012 at 1:58 pm

    #1444778

  • RE: Transaction

    GilaMonster (2/8/2012)

    Delete from tableabcd where starttime <= 2011/07/01

    That's all you need. Deletes are atomic, they complete or rollback as a single operation. A delete can't partially succeed.

    hi gail,

    ...

    Regards
    Sushant Kumar

    February 8, 2012 at 1:52 pm

    #1444773

  • RE: Why remotely connecting to SQL 2005 express failed?

    halifaxdal (2/7/2012)

    Issue persists, no more clue?:crying:

    Did you follow closely what lowell told about changing Port number?

    Regards,

    Skybvi

    Regards
    Sushant Kumar

    February 7, 2012 at 1:59 pm

    #1444123

  • RE: Why remotely connecting to SQL 2005 express failed?

    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

    Regards
    Sushant Kumar

    February 7, 2012 at 12:32 pm

    #1444054

  • RE: Maintenance plan's schedule

    Bru Medishetty (2/7/2012)

    No, it will not have any multiple occurrences. It will execute the next time it is supposed to execute (after the current execution is completed)..

    Let's say the execution...

    Regards
    Sushant Kumar

    February 7, 2012 at 12:30 pm

    #1444052

  • RE: Why remotely connecting to SQL 2005 express failed?

    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...

    Regards
    Sushant Kumar

    February 7, 2012 at 11:51 am

    #1444023

  • RE: Why remotely connecting to SQL 2005 express failed?

    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...

    Regards
    Sushant Kumar

    February 7, 2012 at 9:34 am

    #1443913

Viewing 15 posts - 46 through 60 (of 783 total)