Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Tekreader

    SQL 2005 TRACE DURATION

    Hi, In order to find procs ran more than 1 minute in sql 2000 we do like this select * from tracetable where DURATION/60000 > 1 can anyone tell me what value i should use for 2005 trace duration,Because in sql 2000 it is saved as milliseconds but in sql2005 it is saved as microseconds.
  2. Tekreader

    Index size

    Can anyone tell me how to find the index size in table. Sp_spaceused will give me all the indexes space used in a table.But i want to find each index space used in a table in sql 2000. Thanks
  3. Tekreader

    Auditing Deletes in table

    Helo Sql friends, Can anyone tell me is there a way to audit Deletes in a table in Sql server 2000 or 2005 databases. In production database some records are deleted by some one,I can not revoke the write permission, But I want to audit who is deleting the records.Can anyone tell me...
  4. Tekreader

    count(*)

    Can Anyone Tell me is there any script to get number of records in each table in a database for Sqlserver2000. Thanks TekReader
  5. Tekreader

    Table schema modified date

    Hi SqlSister, I want to find this in Sql 2000.If not possible at all,Let me know how to find in sql 2005. Thanks a lot for the Reply
  6. Tekreader

    Table schema modified date

    Hi Can anyone tell me How to find the table schema(definition of table) changed date in Sql server? ie When any user alter a atble want to find when it was altered. I know cdate in sysobjects will not update the value to show the date. Thanks Tekreader

Part and Inventory Search

Back
Top