david,

as far as i know, no queries are logged?? unless you're using SQL Trace/Profiler.

don't take my reply as gospel! let's see what others have to say on this...

sho

does the login you're using for the linked server connection have permissions on the new database?

sho

you could do the following

select distinct emp_name from emp

and use the results to create a new table

eg

create table new_emp(emp_name varchar(100))

insert into

new_emp

select distinct

emp_name

from

...

hi, like satishbt said, you need to provide more info... but try this.

in Enterprise Manager, expand the node for the database that does work and then expand the Users node.

Check...

perhaps a better way would be to execute the following code in QA...

select

*

from

syscomments

where

text like '%create trigger%'

and...

hi again,

i've had a few emails from people and i've changed the sql syntax in my prev post so it should work.

also, here's a stored procedure and some ASP to...

not sure if it'lll work but give this a go...

Management->SQL Server Agent (right click on this)->Job System, untick the "only users with sysadmin..." tick box.

i could be well off the...

hi again all,

i've figured it out, here's a response to my question...

IN THE DTS DESIGNER

a) Create a server/database connection

b) Create a SQL Task thing in DTS designer

c) Enter the following...

quote:

---

timoteo,

As with Andy's suggestion, I'll be putting together an article on cross-database ownership chains in the very near future. I cover one...

Hi Haidong,

You answered my question with...

"that is normal, because some columns are not applicable to certain events".

After I posted my question I found 2 very useul articles...

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=23016

hi, we've implemented this on our sql server and it's working a treat, however, I've become greedy and also want to get the objectid of the object that is being...