Viewing 15 posts - 54,991 through 55,005 (of 59,067 total)
Master, MSDB, and TempDB are defaulted to "Simple" recovery. Master can be changed to Full Recovery and then I think you can do a transaction log backup. Not 100% sure, though.
September 18, 2007 at 7:42 am
Thanks, Mark... it takes DOS-like wildcards (*) as well...
September 18, 2007 at 7:36 am
Have BCP do a Queryout from a sproc or a view that does a union between some column names and data... keep in mind that all of the data must...
September 17, 2007 at 9:32 pm
Perhaps it's just a language barrier problem... but, if it's not, I agree with Serqiy... why would you need to count the number of columns present in a table?
September 17, 2007 at 6:45 pm
In our case, the term "clone" would be more appropriate. Not sure how it works, but it just takes a couple of minutes everynight on a tera-byte database. Has something...
September 17, 2007 at 6:34 pm
How does that produce the dynamic sizing the OP asked for? That code works great on the input but does nothing for formatting the output in the text window.
September 17, 2007 at 5:43 pm
| There's too many tables being updated, so a trigger is out. |
Write a sproc to generate the trigger code...
September 17, 2007 at 5:35 pm
It would be good if you posted one of the offending lines of code (sans password)... there's lot's of options in BCP...
September 17, 2007 at 5:30 pm
Good golly, folks... open Query Analyzer and press {f4}....
September 17, 2007 at 5:27 pm
This probably doesn't help, but the right way to do it would be to deny all users the ability to create procs and to follow a code promotion process.
September 17, 2007 at 5:23 pm
Thanks for taking the time for the explanation, Rog...
But... being able to pass tables to stored procedures, with the understanding that you will have multiple tables with the same...
September 17, 2007 at 7:19 am
Let us know what you finally come up with so that others may learn, as well.
September 16, 2007 at 7:55 am
http://www.firstsql.com/tutor.htm
When you get done being a newbie, then practice answering question on this forum as Serqiy suggested. You also may want to take a peek at...
Remember...
September 16, 2007 at 7:53 am
Viewing 15 posts - 54,991 through 55,005 (of 59,067 total)