Search results for query: *

Not sure if this is the best Forum, but does anyone know of a way in SQL 2005 (via a script) to monitor for long running transactions. I can see that there is a Perfmon counter that covers this but for whatever reason it is not returning any values? Any help much appreciated. Kind Regards B

Hi All We have deployed 64-bit SQL infrastructure. We have since found that our Monitoring tool (MOM 2005) only has a 32-bit client (which will install on the 64-bit platform in WOW. However the down side is that SQL 2005 only installs its 64-bit performance counters which the MOM Agent cant...

Hi All Im new to vb scripting. Does anyone know how to get a vb script to check for files in a network share? (not a folder). I will alert when there 'x' files and raise a critical alrte when there are 'y' files. The network share is also on a cluster if that makes any difference? The...

Ive an agent that is assigning itself to the wrong site. Is there away of hardcoding Adv cliets to particular site? Any help much appreciated...

Does anyone know of a tool or script that can generate a Vista crash? I need to test Application Exception Monitoring? (also catchs OS crashes) Any help much appreciated. Cheers Andrew

Hi All I need a Script (VB) to check within the 'Webproxylog' table (of the latest 'ISALOG_<yyyymmdd>_web_000' database) to determine if their is a value within the 'ProcessingTime' that has exceeded 30 seconds. Any suggestions \ resources? Any help much appreciated! Kind Regards Andrew

Hi All Is it possible to run a TSQL query (aka 'SELECT * FROM' etc) from within a VB Script. Ive made the following connection from the VB Script, is this the right method of connecting into SQL to then run the TSQL Query? ---------- strDBServerName = "." Set objSQLServer =...

Hi All Im looking to run a script periodically to check the value of certain field within a certain Table. Im new to SQL scripting, so any help much appreciated. The only caveat is that the script has to be a VB Script. Knd Regards A

Hi All Im looking to run a script periodically to check the value of certain fields within certain Tables. Im new to SQL scripting, so any help much appreciated. The only caveat is that the script has to be a VB Script. Knd Regards A

DBCC SHOWCONTIG returned the following info on the table Im concerne3d about. The “Extent Scan Fragmentation” is the value I’m concerned about as it indicates fragmentation. DBCC SHOWCONTIG scanning 'GroomHistory' table... Table: 'GroomHistory' (1253579504); index ID: 0, database ID: 6 TABLE...

Can anyone see an issue with the WMI querybelow? Im looking to monitor for when a particular Process is detected... select * from __InstanceCreationEvent within 30 where TargetInstance ISA ‘win32_process’ and TaregetInstance.Name = ‘notepad.exe’ The above WMI query doesent seem to fire...

Does anyone know of a way of monitoring the execution times of a Stored Procedure? We need to be Alerted whenever a certain Stored Procedure has exceeded a certain time threshold... Any help much appreciated

Being a 'newbie' to scripts... do you have any such examples of a 'certsian product'?

Does anyone know af a SQL query that I could use to run as a SQL Job that will mean it will run and run. Im looking to test some monitoring scripts to detect for long running SQL jobs. However Im new to scripts and am not sure how to generate a long running script in SQL? Any help much...

Or a little noise at least.... does anyone know how to generate a noise using a script? I need a script to a get an Admins attention whenever we have a particular issue on a console. There are better ways in my opinion but in this case I have no say. Any help much appreciated. Script will...

Im looking for some assistance as to how best to monitor a long-running SQL Jobs via a script? (SQL Agent Job - Process Event Cache) Would this be best achieved with WMI? Any help much appreciated... cheers

This is the current VB script, you can see the number of IF clauses in the middle, Im looking to plug a further one in. The script goes on to create events within product called MOM. Any help much appreciated!: ' ' Set these values as required ' Const FOLDER_NAME =...

When attempting to plug in the If UCase(Right(strPathName, 4)) = ".TXT" Then Im getting an error saying that Ucase is not a Collection? Any ideas?

Guys Im new to scripting a looking for a simple 'If' query to check if a file is of a particular file extension e.g. Txt ... and then I'll continue with other actions. Any help much appreciated!! Cheers

Thanks again Tsuji, will have a play shortly, cheers!