Viewing 15 posts - 31 through 45 (of 49 total)
it can all be done in a TSQL query
this query might not be correct, look up the reserved tablenames in the master database
select max(s.name), count(c.columns) from sysobjects s inner...
April 6, 2009 at 9:54 am
ray_brp (4/6/2009)
thanx for that idea, do i have to change any of my codes to do that?
u will just have to change your connection string to Provider=SQLCLNT10...... bla bla
and in...
April 6, 2009 at 9:32 am
why would an insert be rolled back? its just a basic insert
April 6, 2009 at 9:29 am
rajiniforu (4/6/2009)
Also there could be a posibility that few records must be deleted at the source table at some point of time. Later when this table gets exported to any...
April 6, 2009 at 9:28 am
it just seems stupid to me that i have to write some vb or c# script to loop every record and insert one record at a time. i would...
April 6, 2009 at 9:25 am
Vladan (4/6/2009)
xgcmcbain (4/5/2009)
April 6, 2009 at 9:22 am
yes it was a copy and past error
April 5, 2009 at 6:08 pm
Andy Hogg (4/4/2009)
April 5, 2009 at 4:31 pm
I have also had these wacky problems, you need to uninstall .net 3.5 and then 2.0 , then reinstall it.
April 5, 2009 at 4:11 pm
of course. depends on what your using to connect to SQL server with though. Im assuming its ado.
http://www.connectionstrings.com
is your friend.
in your vb IDE, you should chose...
April 5, 2009 at 4:09 pm
im sorry guys, i found out im an idiot on my own. In the sql management tool, there is a play button (which is debug) and an execute button,...
March 20, 2009 at 9:05 am
Bruce W Cassidy (3/17/2009)
March 17, 2009 at 10:35 pm
im trying to do it client side, but its a binding situation and in this case makes more sense on the original sql statment
March 17, 2009 at 10:32 pm
Richard Fryar (3/11/2009)
The DBCC commands mentioned above will clear the cache but won't release memory back to the OS.
didnt think so thanks
[You don't say whether you are using 32 or...
March 11, 2009 at 6:12 pm
Yes you can, but if you don't it can have affect on server. How much memory do you have in the server? Ideally Windows Servers should ave...
March 11, 2009 at 4:11 pm
Viewing 15 posts - 31 through 45 (of 49 total)