Forum Replies Created

Viewing 6 posts - 61 through 66 (of 66 total)

  • RE: Using SQL Profiler to Resolve Deadlocks in SQL Server

    Jonathan Kehayias (2/1/2009)

    Comments posted to this topic are about the item <A HREF="/articles/deadlocks/65614/">Using SQL Profiler to Resolve Deadlocks in SQL Server</A>

    well explained and very helpful. Thanks for sharing

    March 10, 2010 at 3:23 pm

    #1131677

  • RE: xp_cmdshell copy option is not working

    First check if the file is accessible from query analyzer and/or the file actually exists

    March 10, 2010 at 3:17 pm

    #1131676

  • RE: Should I Backup The Systems DBs and If so Which ones and why

    YSLGuru (3/9/2010)

    I actually know the common reasons or recommendations for why one would typically backup the system databases on a SQL Server 2005 box and which system DB's but I...

    March 10, 2010 at 3:10 pm

    #1131672

  • RE: Backup

    d.srikanth50 (3/10/2010)

    How to know backup is sucess or not using select query?please let me know?

    Get the job id of the job from sysjobs table in msdb and then try quering...

    March 10, 2010 at 2:54 pm

    #1131666

  • RE: How to use Database mail feature in SQL Server 2000

    mohammed moinudheen (3/8/2010)

    Comments posted to this topic are about the item <A HREF="/articles/SQL+Server+2000/69475/">How to use Database mail feature in SQL Server 2000</A>

    Good use of linked server to make use of...

    March 10, 2010 at 2:16 pm

    #1131651

  • RE: Change Instance Name

    Hi,

    You can try below options:-

    1) Collect current instance configuration using sp_helpserver

    2) Drop the old server and create a new one.

    sp_dropserver ‘old_name’

    go

    ...

    February 24, 2010 at 3:51 pm

    #1124656

Viewing 6 posts - 61 through 66 (of 66 total)