I have created an INSERT trigger on production database which only copies the Inserted data into a stagging table for further processing. further more the stagging table does not contain any constraints, key or indexes. But the data is failing to insert into production table from application, where as if i run the query frrom profiler directly everything works fine...
Is there is any issues with cross database inserts from triggers??