Since the Key and Certificate reside in the other database you need to change context to that database. I believe you can do it using Exec sp_executesql something like...

Can you provide the DDL for the table?

Is the Company Name in the same table?

You could do something like this:

IF OBJECT_ID('tempdb..#company', 'U') IS NOT NULL

BEGIN;

...

If you are on a domain the most secure method is to use Windows Authentication only when you install SQL Server. If you have to have mixed authentication, you...

I'd suggest changing the query to get the trace file name from:

select convert(varchar(1000),path) as path from sys.traces where id = 1

To

select convert(varchar(1000),path) as path from sys.traces where is_default =...

Lynn Pettis (5/4/2015)

---

Jack Corbett (5/4/2015)

---

And for back to back posts to the thread. I really can't stand it when an OP says something like:

Please help me fix...

Jeff Moden (5/4/2015)

---

There's also no excuse for people breaking out their "I've got 20 years of experience" rings. which looks like might have been the start of it all. ...

And for back to back posts to the thread. I really can't stand it when an OP says something like:

Please help me fix this poorly performing query, but without...

FYI, Erland Sommarskog has a new set of articles on Error Handling in T-SQL that y'all might be interested in. It starts here, http://www.sommarskog.se/error_handling/Part1.html.

There really isn't a way to fix this problem without a code change. The issue is that ALL the data is being brought across the pipe to filter down...

I'd put together a trace to verify that this is the issue. I don't see any way that can be the ONLY statement in the batch because it can't...

According to this BOL article, you need ALTER TABLE on the table the trigger, and according to this BOL article, db_ddladmin does not have ALTER TABLE.

I tend to create specific...

What is the security context the linked server is using? Unless that user has pretty elevated permissions it can't access the statistics in order to find the best execution...

I'm not sure how this query can be a blocker with the NOLOCK hint. When I run a query using the NOLOCK hint the only lock taken is a...

Wow Lynn that's one of the best one I've seen in a long time. Give me the code so I can pass my final. You never know, the...

And here I am thinking this was a MASH reference, http://mash.wikia.com/wiki/Walter_%22Radar%22_O%E2%80%99Reilly😀