Viewing 15 posts - 5,356 through 5,370 (of 6,216 total)
I think you've stretched the limits of what you can do with ADO. Can't blame it for not knowing what table to update in that situation! In some cases a...
December 3, 2001 at 5:12 am
I agree, is not the fastest.
SMC,
Dont know why I didnt ask earlier, if your hardware has 12 counters, why not change the table to have 12 columns? It's at...
December 3, 2001 at 5:05 am
DMO tends to be more verbose than TSQL, but I thought I'd see how it turned out anyway. Took me just over 10 mins to throw this together.
Dim oServer As...
December 2, 2001 at 5:48 pm
Nope, doesnt matter, other than Im curious as to how it was done, more about the table creation than the data.
Andy
December 2, 2001 at 12:10 pm
I found this key:
HKLM\Microsoft\MSSQLServer\MSSQLServer\DefaultCollationName
On my system is set to "SQL_Latin1_General_CP1_CI_AS". I tried changing it and creating a new db, got the same original collation. Stopped and started the service, same...
December 2, 2001 at 9:04 am
Not really. If you're overall system is memory constrained, then adding more memory might help, but I would not try that as the first fix. What speed is your network...
December 1, 2001 at 6:15 am
Sure, but did he copy/paste the line 399 times? Use a cursor, cross join, dmo, ?
Andy
December 1, 2001 at 5:12 am
I think we're mostly VB guys. You might try posting in one of the MS VC++ groups to see if they can help. Only idea I can offer is that...
November 30, 2001 at 6:07 pm
Thanks for the follow up Willem - please visit anytime you have questions, we'll try to help!
Andy
November 30, 2001 at 6:06 pm
Did you not elect to send over an initial snapshot? There is a place in the wizard that asks if the data and stuff is already there. The proc you...
November 30, 2001 at 6:04 pm
You're welcome! Please visit anytime you have a question.
Andy
November 30, 2001 at 6:02 pm
You'll have to "alias" him as dbo, not just give him dbo level access. You're right about exec, but it's really doing 'exec hislogin.objectname'. To do this, you need to...
November 30, 2001 at 6:01 pm
Almost. We need the script for it. Right click the table and find the option to generate a script. Save that to disk, open it, copy and paste the test...
November 30, 2001 at 5:49 pm
I havent tested, but I can see where it might be slower, especially compared to smaller tables. 400 cols x 4 bytes per col for ints, 1600 bytes (more or...
November 30, 2001 at 5:48 pm
Not familiar with CF - but maybe a couple ideas. One would be to write a quick vb app just to test the connection and execution - rule out any...
November 30, 2001 at 5:44 pm
Viewing 15 posts - 5,356 through 5,370 (of 6,216 total)