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 TouchToneTommy 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: *

  • Users: bowl3y
  • Content: Threads
  • Order by date
  1. bowl3y

    Comments in a Stored Procedure

    Has anyone ever heard of a stored procedure having too many comments? While investigating the slowness of a SP I discovered that if i removed everything but the code the procedure went from 10 seconds to 2??? any ideas? the comments were about 70 lines long the entire sp was less than 100...
  2. bowl3y

    Get alist of Running DTS Packages SQL 2005

    I'm attempting to retrieve a list of all DTS Packages that are running using TSQL in SQL 2005. has anyone Built anything like this? Is there a Sys table i need to reference? Bowley (If it won't work, Make it... if it breaks in needed fix'in anyways.)
  3. bowl3y

    Script files failed to load.

    I have numerous DTS files that contain script files on a 32-bit server with no problems when running. However, after deploying these packages to a 64-bit server I have began recieving an error on all script files that state: Error: 0x5 at "script name"" The Script files failed to load. Has...
  4. bowl3y

    Audit on Stored Procedures

    Does SQL 2005 maintain any form of an Audit on how often OR when stored procedures are Executed? My Dataware house currently has ALOT SP's and I am wanting to clean it up a little. And Not knowing which ones are system critical is a pain. I have tossed around the idea of adding a simple insert...
  5. bowl3y

    Query Analyzer Connection issues

    Ok...check this...I can open Query analyzer(QA) and connect to any of our SQL servers just fine. I can do EVERYTHING/ANYTHING i need/want to do. HOWEVER...if i'm idle for too long or if i minimize QA and then bring it back up and attempt to expand a database object,(SP,view, usertables etc.etc...
  6. bowl3y

    Query analyzer

    Ok...check this...I can open Query analyzer(QA) and connect to any of our SQL servers just fine. I can do EVERYTHING/ANYTHING i need/want to do. HOWEVER...if i'm idle for too long or if i minimize QA and then bring it back up and attempt to expand a database object,(SP,view, usertables etc.etc...

Part and Inventory Search

Back
Top