If you post a script of your stored procedure someone may be able to help.  It sounds like you are not referencing it or it's parameters correctly.

You can save the following code as a VB-Script (.vbs), and execute it like a .BAT file.  Or, execute the code using DTS, or as a Scheduled Task.  You don't have...

Here is a VB example using SQLDMO to list the server groups and their registered servers (there are many other collections that may be looped through such as Logins, Databases,...

Using the SQL-DMO object library you can programmatically loop through server and object collections to achieve the result you want.

When scripts are generated using EM the first thing generated are the IF EXISTS... DROP [object] commands for the objects that need to be recreated.

If you execute your script once in...

You can set the row limit programmatically using VBA per the following examples.

To limit the number of rows sent to the client to 100:

  Application.SetOption "Row Limit", 100

To allow unlimited...

Here is a version of your code that will give you the output specified in your original code, providing the connection string is valid and CHIL0708A1 is a table or...

I am using "XSql Object Compare" to keep databases in sync.  It is doing a great job.

Store the maximum length in the controls .Tag property and insert this code into each forms class module:

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)

'we eliminate key strokes causing controls...