hmmm... interesting problem..

I like and have used may times option 4). the package can ve secured and you can run it any time via DTSRUN, or, batch it up...

Yep.

Hi there, I had this problem yonks ago when going a bit of VB work.

Its something to do with when EOF gets initialised and its value...

try this:

a) Remove...

Nice piece of code. Thanks for the post.

Hi there

No it wasnt actually, and this is why it supprised me. It was a single massive query over 14 tables.

Cheers

Chris.

Andy

Hey there Andy, check this out from profiler...my table "aaaaa" didnt have identity enabled, then enabled it and got this:

CREATE TABLE dbo.Tmp_aaaaa

(

aaa int NOT NULL IDENTITY (1, 1),

bbb char(10)...

Hi all

Thanks for the replies. I had a closer look at the code. Basically the ADODB connection property (adoconnection.commandtimeout) default for query timeouts was returning 30secs, the report...

Hi guys

Hmmm.. yeh, knew this one and wasnt what I was after . Basically I wanted to permanently remove IDENTITY from a column via an ALTER DATABASE statement. ...

Hi all

I am the same in that no one geting dbowner (dbo) access. Even in dev, i try and run a very strict shop with NO application schema changes...

"STILL allows the user to alter the name of the columns in a table, but they can alter the data types and other physical structures of the table. Altering the...

Well Well.. more testing done.

Basically the

exec sp_droprolemember 'db_ddladmin', 'trs'

STILL allows the user to alter the name of the columns in a table, but they can alter the data types...

Hi all

use mydb

go

exec sp_droprolemember 'db_ddladmin', 'myuser'

go

Does the trick.

Cheers

Chris

Chris - excellent!

Most appreciated...

Cheers

Chris

Hi

Yep, this is a problem alright. Check the EXECUTE function to run your dynamic SQL, there is a return value that you can check which may help you. ...

Andy

Fair call.

Cheers

Chris