Search results for query: *

How do I test to see if an object has been set to Nothing?

I am currently writing a VB program that uses DTS to import data into a SQL Server 7 database. The import stuff is all fine & dandy, but i need to konw where at in the execution it is so i can update a progress bar. I know there is an OnProgress event for the dts.package object, but it...

i don't want another column, i have a column that was in another database that i loaded into this one. the column that i am trying to modify was an identity column, for some reason i couldn't load the other table into the new one as long as there was an indentity column. I had to drop the...

i am just trying to change the column from a normal int field to an int field with an identity.

does anyone know how to alter a column that is already populated to be an identity column? ALTER TABLE tblName Alter COLUMN [ID] [int] IDENTITY(1,1) NOT NULL this gives this error: Server: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'IDENTITY'.

I am trying to use the BULK INSERT command and keep getting this error: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error. The statement has been terminated. The exact command i am using is: BULK...

Thanks Venky! I appreciate your help very much, I think this will work :) Rob

Hi, I have written a method that gets a 'result set' from a SQL query and saves it as a .txt file in a specific directory on the server. When a visitor to the site clicks the button which files off the servlet, it 'generates' the file and 'dates' it up to the second. My question is...is it...