Viewing 15 posts - 51,946 through 51,960 (of 59,072 total)
Yes... but it it will be out of scope in the proc that has the exec statement... heh... please don't ask why 😉
March 10, 2008 at 6:07 am
So far as the cost of a DBA goes, I think the reason why Oracle DBA's get paid more is because of perception. I think many managers are under...
March 10, 2008 at 6:04 am
Leo Peysakhovich (3/9/2008)
noeld (3/19/2007)
When your data warehouse reaches 200 to 500GB you will get into a TOTALLY different...
March 10, 2008 at 5:53 am
Yep... Antonio writes good stuff. Still, I'd like to know why you need this type of "sort", please.
March 10, 2008 at 5:46 am
Ok... once you learn how to use a Cursor, THEN avoid them as if they were Leprosy 😉 There is very very little you actually need a cursor for...
March 10, 2008 at 5:45 am
Sorry... I know squat about DTS... not sure if activex will help here or not.
March 10, 2008 at 5:36 am
Can't be done... it's all or nothing.
March 10, 2008 at 5:33 am
It appears that all the variable declarations and presets are missing from the code... could you include those, Johan?
March 10, 2008 at 5:25 am
And, Andras' method will allow an index to be used if there is one. The conversions to VarBinary will not.
March 10, 2008 at 5:11 am
kgunnarsson (3/10/2008)
That is for each line in...
March 10, 2008 at 5:10 am
Oh yeah... the tabs are being correctly stored... they never show up correctly in a grid mode... if you want to verify they are there, look at the data in...
March 10, 2008 at 4:52 am
Since you're going from SQL Server TO SQL Server, you can solve the tab problem by using the "Native" format for both the export and the import. It's also...
March 10, 2008 at 4:49 am
Yeah... ever hear of the "DataBase Owner" role?
March 10, 2008 at 4:45 am
It's gonna be a mess if you have, say, 1000 employees... you said you have to do this "for some reason"... what is the reason?
March 10, 2008 at 4:44 am
What are you using to do the export with? DTS?
March 10, 2008 at 4:41 am
Viewing 15 posts - 51,946 through 51,960 (of 59,072 total)