What are the permissions given to the users?

What line is the error on??

To find out, you can comment out some part of the code untill you get no error, that will tell you where the error is.

The sp works in automatic mode, it grants access to the db executor role to the sps (that role must exists on the server, or you can change that to...

can you post the actual table definitions and soe sampla data along with the expected results and exceptions (if any).

It's almost over... only 6 hours left .

check out sp_settriggerorder.

You can set up the first and last for each type (insert, update, delete). But you can't set up the order for the triggers in between the...

I haven't found the actual code to find the info from the column, but this will work just as well :

Select ident_seed('TableName') as Seed, IDENT_INCR('TableName') as Increment, IDENT_CURRENT('TableName') as...

It doesn't work when you have your old Nick.

This is a good start.

http://www.sqlservercentral.com/columnists/bknight/dbaroles.asp

http://www.sqlservercentral.com/columnists/sjones/whatsadbaanoverview.asp

http://www.sqlservercentral.com/columnists/sjones/thevalueofadba.asp

http://www.sqlservercentral.com/columnists/jyao/howtobeagooddbastrategyandtactics.asp

Now you'll be able to chat on SSC .

How are you inserting the data?

Can you send the table definition and the code to insert in?

please do not cross-post, we monitor all boards.

Finish the discussion here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=212048

please do not cross-post, we monitor all boards.

Finish the discussion here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=212048

maybe he should have written :

SELECT name FROM sysdatabases WHERE sid 0x01

AND name NOT IN ('keepdb1','keepdb2','keepdb3')

it would have been less confusing.

Wow, can't wait for yukon . Thanx for the info.