Ed Wagner (2/23/2015)

GAH! My bad, I forgot to select the last line while pasting. Thanks for spotting, Ed.

I would change your table definitions this way:

CREATE TABLE Agents (

agent_id integer PRIMARY KEY

,product_id integer

,agent_name varchar(50)

);

CREATE TABLE...

Here are some links for you:

https://ssisunit.codeplex.com/

https://www.nuget.org/packages/SSISTester/2.1.0-b168

Hope this helps

Very nice. Thanks for sharing.

Duplicate post. Replies here please: http://www.sqlservercentral.com/Forums/FindPost1661983.aspx

I'm sorry, but I don't understand what is your problem. Can you explain it in other words? Do you get an error in SSRS? Reports don't work?

Two possibilities here:

1) The instance is GEBPC\GEBPC and it listens on port 1433. When you connect to GEBPC, you connect to the instance GEBPC\GEBPC. Or, as Perry says, a SQL...

You probably have some code paths that allow connections to be closed before reverting to the original login.

Not reliable IMHO.

This post should be the answer you're looking for: http://dba.stackexchange.com/questions/19870/how-to-identify-which-query-is-filling-up-the-tempdb-transaction-log

I suppose it's not the CASE statement per se that is taking time, but the context it is used on. Is it in a SELECT list or is it a...

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Does sqlcmd work?

Use any ETL tool that fits your needs (BCP, SSIS, whatever) and SQL Server authentication.

There's no "fix" in this case. That's how impersonation works.

I ended up using SQL Server Authentication. Would it work for you?

No, it doesn't sound like a good idea. Everything you do...