Viewing 15 posts - 1 through 15 (of 653 total)
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.
November 5, 2009 at 7:52 am
I think thats the only way, because you are dealing with individual rows. I assume you are using cursors in your repetition.
November 5, 2009 at 7:49 am
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...
August 21, 2009 at 3:59 am
how many stored procs do you have? there's some good advice posted above.
March 2, 2009 at 5:11 am
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...
June 19, 2008 at 3:17 pm
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...
June 19, 2008 at 3:11 pm
i think i misunderstood your problem.
June 19, 2008 at 1:41 pm
do it and see if you get an error.
June 19, 2008 at 1:35 pm
it seems like a silly thought but make sure that the date column actually has data.
June 19, 2008 at 1:33 pm
in the messed up script use FIND and Replace
find ALTER DATE
and replace with CREATE DATE
June 19, 2008 at 1:26 pm
it looks like you are missing the AS on your aliasing
dbo.getMemberFullName(s.student_lname, s.student_fname, s.student_mi) student_name,
June 19, 2008 at 1:23 pm
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.
June 19, 2008 at 1:19 pm
Giorgio Maglia (6/18/2008)
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...
June 18, 2008 at 3:13 pm
whats in the folder??
June 18, 2008 at 3:08 pm
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?
June 18, 2008 at 3:07 pm