Probably not answer you are expecting but you can try red gate sql data compare, http://www.red-gate.com/products/SQL_Data_Compare/index.htm

It should be able to generate the scripts for you.

I think thats the only way, because you are dealing with individual rows. I assume you are using cursors in your repetition.

I did think about getting a home server with raid but because of the cost (read credit crunch) I decided to use the free online offerings like http://www.mesh.com...

how many stored procs do you have? there's some good advice posted above.

I share your thoughts, but sometimes you might get a third party app for which the owners will provide you with encrypted stored procs. your hands are tied in that...

if you are new to sql i'd suggest that you run the individual selects before unioning them its much easier for you to nail the problem.

oh and follow Steve advice...

i think i misunderstood your problem.

do it and see if you get an error.

it seems like a silly thought but make sure that the date column actually has data.

in the messed up script use FIND and Replace

find ALTER DATE

and replace with CREATE DATE

it looks like you are missing the AS on your aliasing

dbo.getMemberFullName(s.student_lname, s.student_fname, s.student_mi) student_name,

dbo.getFullStatus(s.student_status)...

I think this is more of a windows problems than a sql. i also created a trace file manually and it inherited the permissions of the folder.

Giorgio Maglia (6/18/2008)

---

SQL2005 sp2

I've set up a trace to write to a centralized location. I've granted the necessary permissions to the SQL service account to the target location and...

whats in the folder??

i think the maximum is as far as provided by your computer memory. is there any reason why you want to use a table variable if at all?