Right; thanks for your help.

Cheers

I changed the code to the following:

<%@Language=VBScript%>

<% option explicit %>

<!--#include file="../includes/adovbs.inc"-->

<%

dim objRS

set objRS = server.createobject("adodb.recordset")

dim strSource

strSource = "Provider=SQLOLEDB.1;DRIVER={MS SQL-Server};UID=MyUserID;PWD=MyPassword;DATABASE=Sailors;SERVER=MyServerName"

dim sqlStorProc

sqlStorProc = "qAllBoatNames"...

Thanks for the information. I adjusted the code:

<%@Language=VBScript%>

<% option explicit %>

<%

dim adOpenStatic, adLockBatchOptimistic, adUseClient

adOpenStatic = 3

adLockBatchOptimistic = 4

dim objRS

set objRS = server.createobject("adodb.recordset")...

Which one of the two is most widely used?

Security vulnerabilities?

Buffer overruns?

Encryption?

I'd shake your hand for all of your help. However - Thank you very much for your assistance.

So the output file would be like:

oc:\scripts\results_createtablescript.txt.out'

Would this be the final script?

USE master

GO

-- create a database

CREATE DATABASE database1

ON

( NAME = database1,

FILENAME = 'c:\program files\microsoft sql server\mssql\data\database1.mdf',

SIZE = 4,

...

Would the script look like this?

--

EXEC xp_cmdshell'isql.exe -S nameofmyserver -U mydbouserid -P mydbopassword -id:\scripts\createtablescript.sql -od:\scripts\sp_who.out'

--

Is id: residing at the c drive (c:\scripts\createtabescript.sql)?

If od: is the output, will it generate...

mdamera,

In your block of code, where do I reference the name of my script? I understand the following of your code:

EXEC xp_cmdshell - executing xp_cmdshell

'isql.exe = ?

-S = nameofmyserver...

Below is an example of my create database script.

-----------

USE master

GO

CREATE DATABASE database1

ON

( NAME = database1,

FILENAME = 'c:\program files\microsoft sql server\mssql\data\database1.mdf',

SIZE = 4,

...

I'm using SQL Query Analyzer to run the create database script. After the the last Go command, prior to the next block of code to create database2; I want to...

Steve,

Thanks for the reply. If I remove the identity and perform the copy, I'll have to reset the Identity. How will this effect the current recorders? Will they acquire an...

Andy,

Thanks for the feedback. I too, agree with the need for RAID - (RAID5) and using SQL's dynamic memory. I mentioned that another box was need for the SQL server....