SQL Tidbits Mar 2012

March 2nd 2012

  • SQL Server Profiler trace can be stored inside a SQL Server table.

March 1st 2012

  • In order to find the list of server roles and its members, run the system stored procedure sp_helpsrvrolemember in master database.
  • Amar

    What jobs would you run for maintenance