Search results for query: *

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...

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.)

After several hours of trial and error and Googling i was able to resolve this issue by simply removing all breakpoints in the scripts. breakpoints are not allowed when running packages in the 64-bit environment. I literally had to open all script tasks on all packages remove the breakpoints...

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...

Noted....Thanks Bowley...

This is Perfect! You are the MAN!!! :) Quick question though, does this grab the usuage of all SP's or just the ones that have been executed recently enough to have a exection plan still cached? Bowley...

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...

I dont have that installed on there.

Still continues to lose connection after being idle.

Still continues to lose connection after being idle, even while pinging a server on the Domain. There has been no changes to the DHCP server settings. Can you provide a link to the SQL SP4? --Bowley

Enterprise Edition SP4 8.00.2039 again, i do not believe the issus is server specific seeing that; 1. It happens on all of our servers (5) 2. This just started happening 3. My Other computer does not have this issue. The PC that this is happening to is not on the domain, its just on the...

The machine is running XP professional. I cant seem to find a SP4...

The AUTO-CLOSE is not checked on any of the DB's. (This is happening all of the servers/databases i connect to from query analyzer)...This is why i believe it is caused from client specific setting/service. it also only happens with QA...EM appears to be fine... Also i forgot to mention that...

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...

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...