Viewing 15 posts - 55,171 through 55,185 (of 59,067 total)
If that is what you must do, then the TEXT datatype is certainly one way to go.
To see if the Standard Edition will create a table with multiple text columns,...
September 5, 2007 at 6:56 pm
Sure, Karthik... let's answer question #2 first...
'dtProperties' is a special table used by things like the "Visual Database Design Tools". It even has to be modified if you want to...
September 5, 2007 at 5:26 pm
Josef,
Need a couple of things from you...
September 5, 2007 at 4:49 pm
Since I don't use DTS or SSIS for this type of stuff... what happens to the data that caused the error? Can the error handler be made to save the...
September 5, 2007 at 7:52 am
Heh... thanks Lowell ![]()
September 5, 2007 at 7:50 am
Aye... nicely done, Lowell... and, I think you'll really like this, as well ![]()
Just in case someone can't use xp_CmdShell, there's a little known...
September 5, 2007 at 7:30 am
That's kinda why I use BCP for this type of stuff... you can program BCP to survive just about any error and squirrel the "bad" rows in a separate file...
September 5, 2007 at 6:55 am
Hust for a point of reference... we set TempDB to be 9 gig on bootup.
September 5, 2007 at 6:50 am
You are correct... things are going to get a little complex because you need a query to build a dynamic query from Master.dbo.SysServers.
September 5, 2007 at 6:33 am
For more reasons than I can count, you will likely regret the day that you used Text or NText if there's any chance of ever needing to edit the column.
Creating...
September 5, 2007 at 6:25 am
Ganapathi,
It's good that the code works... but do you know WHY it works? ![]()
September 5, 2007 at 6:20 am
The only thing I can see that might be doing this is your 11PM DB Maintenance job... check it and see if you are "regorganizing" the data... there's at least...
September 5, 2007 at 6:04 am
You bet... thanks for the feedback...
September 4, 2007 at 10:19 pm
Viewing 15 posts - 55,171 through 55,185 (of 59,067 total)