Post reply

IMP Stored Procedures

  • November 28, 2007 at 6:35 am

    #69461

    Dear All,

    I am new to Sql server and need the SP's which are used on daily basis for administration.

    regards,

    Ninad

  • December 2, 2007 at 1:38 pm

    #756321

    There aren't daily ones.

    what are you trying to do? What is IMP?

    Or what have you been asked to do? If you're new to being a DBA, there are quite a few articles on this site, specifically in the last week or so, on daily DBA stuff.

  • December 3, 2007 at 10:48 am

    #756579

    the ones i use mostly

    are

    sp_who2: to find out current connections and who's blocking who.

    and

    DBCC INPUTBUFFER (SPID)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply