just check if the bulk insert works as a single TSQL statement. I hope that hsould. if so the problem is

EXEC SP_EXECUTESQL @SQLString

change as

EXEC SP_EXECUTESQL(@SQLString)

Sachin,

i too was meaning this. I wanted to know what was the value before change and after change and if that is possible with profiler. I know that passing the...

CDO works better and i too use script like this and have faced no problems better to use the script above.

Vivien

Have you fixed this problem. If so let mw know how.

declare @servername  varchar(100)

declare @dbname   varchar(100)

declare @dbownername varchar(100)

declare @crtdate  varchar(100)

declare @totexts        int

declare @usedexts  int

declare @filename  varchar(200)

declare @datsumtot  numeric(10,2)

declare @datsumused  numeric(10,2)

declare @perused  numeric(10,2)

declare @logsize        numeric(10,2)

declare @logused        numeric(10,2)

declare @collation  sql_variant

declare @model   sql_variant

declare @fullbackup  varchar(30)

declare @diffbackup  varchar(30)

declare @logbackup  varchar(30)

declare @filebackup  varchar(30)

declare @numusers       int

declare @rcnt         int

SET NOCOUNT ON

create...

Do you mean to say that tempdb is continously growing in size? You can schedule a shrinkdatabase or shrinkfile job against tempdb to clear the unused space.

You can use the wizard to say which is your source adn the destination and choose oracle ODBC as your destination to move data there.

Just do an select on sys.all_objects to confirm if the object exist then if exist get the object id from that and check what is the schema for that object...

The script name is instmsdb will be available in

<<DRIVE>>\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install

You have only your msdb corrupt then no need to rebuild instead check there will be scripts in the default folder for msdb, model and tempdb just execute the script...

How many records where there in the temp table that you created. Was the drive having enough space.

You can use the import/export wizard available with SSIS to migrate data from ORACLE to SQL Server. You need to create a ODBC pointing to the ORACLE database and use...

I hope you will bnot be able to capture the values. Anyways let us see what other users have on thier opinion to best of my knowledge we can trace...

The is a kb article that MS has given to script logins from 200 to 2005. It has a procedure that scripts the logins and using that script the can...

That's no problem Brain i just wanted to know if you have any other opinion on the same.