Post reply

VBS script to find out database details in SQL Server 2005

  • December 14, 2011 at 7:04 am

    #247610

    Hi All,

    I have attached two files one is txt file and one is error file. I am executing the txt file as a vbs script but it is shows error. Please suggest where I am lacking. The same kind of script I am executing for other purposes also and they are running fine.

    Thanks in advance.

  • December 15, 2011 at 2:29 am

    #1421788

    I think your attempt to open the connection is failing because you have single quotes round the database name ("blah Initial Catalog='DBA'") and you simply swallow the error ("On Error Resume next").

    There are many ways to trace messages between client-server (e.g. Profiler or NM34) or you can simply debug the VBA (step by step). Simple !

    HTH

    Dick

    congrats to Jeff Moden for winning X-DBA (but I bogied this one first)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply