Generic Script Resource | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Generic Script Resource

Hi, We have a Health Care app that is installed on SQL Server 2005 EE 654 bit Cluster with Windows 2003 R2 64bit. This app doesn’t reconnect users upon failover. As a result I would like to use the "Generic Script" resource which will call a Windows Script Host script and reset our IIS server.
I followed the following link: http://msdn2.microsoft.com/en-us/library/aa369319(VS.85).aspx
I’m using VBScript option within and to test out I added the following script:
Set ss = CreateObject("WScript.Shell")
ss.run "NOTEPAD.EXE",1
If I run this of a command prompt on each node, this just works fine, but If I were to embedd this in the Generic Script resource using wscript <script name>, the following error message pops:
"An Error occured attempting to set the properties. The filename, directory name or volume label syntax is incorrect"
Appreciate any help on this. Thanks

I don’t see its a SQL related problem and have you checked under VS 2005 based forums in thsi regard.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |