shahgols,

Did you find out what was the prooblem? I am having similar error. Wonder if it's the same reason. Thanks.

Msg 17906, Sev 18: Access denied [SQLSTATE 42000]

Thanks.

Checked Support service, it's using same profile as the one in startup account. I tried to TEST from there and test was successful also. Don't know what else could be...

Do I really need that? I don't even have this service account as DB user for Db that I am selecing from. It was always like that and never had...

run this.

sp_dboption 'DB_name', 'single user', 'False'

you will get confirmaion that DB is now in multi user mode.

Thanks all of you whoever responded. I think I will go with query which is working fine now.

Thanks, Klaas-jan

I got it working but now my only question is when I use this query it sends me result of master database and if I don't give master.dbo then...

OK, Thanks for response. Here is where I am. I decided to use Greg's query and then send me email query results. I am trying to put together a script...

I think Trigger won't work becuse I am looking for Object creation not for DML commands. and I am not sure if that works with Trigger. But I think Greg's...

Actually I made the same assumption but numeric field in both tables had different length. And that was the reason size was different.

Thanks both of you.

Run this procedure with following parameter

sp_dboption 'DB name', 'single user', 'true'

and database will be in single user mode. When returning to multi user mode Use 'False' as parameter.

IT's SQL 7.0 std. edition on windows NT 4.0. With Outlook 2000.

I will look into MS Q&A to see what checklist is that.

Thanks.

Hiren

May be that's the problem. I haven't tried to solve it but that makes sense.

Thanks.

Hiren

In EM server registeration is done using user SA.

Thanks.

Check SQL server agent propoerties. Under JOb system Tab, There is an option for 'Only users with Sysadmin Privileges can execute CmdExec and Active Scripting job steps'- see if this...