Duh ..

I am able to port any over 100 GB db on MSSQL from server to server , so this DOES work, since I have used it also in...

Hi ,

*** Don't just give the hungry man a fish, teach him how to catch it as well.

In my opinion this is exactly what I did ; )

Ok...

There is a solution to be able to deploy sql scripts from folder structure ... so that the dba would do a simple double-click .... regardless of the where the...

:: Tested on Win7 and Sql Server 2008

:: THIS SCRIPT GOES TO ALL SUBFOLDERS AND RUNS THE

:: YOU NEED THE FOLLOWING FOLDER STRUCTURE:

:: ROOT - THIS IS WHERE...

2005 does not have table variables ...

declare @table table (id int, [name] varchar(10), gender char(1))

declare @MaleNames table (id int identity(1,1), [name] varchar(10))

insert into @table values (1,'John','M')

insert into @table values (2,'Sue','F')

insert into @table values (3,'Jane','F')

insert into @table...

for the most bravest here is a perl script to run multiple sql scirpts ...

requirement: the scirpts should be numbered:

1.RUN.scriptname.sql

2.RUN.scriptName2.sql

3...

n. RUN.scirptname3.sql

and placed in the same directory as...