So what are the results? What did you see when you compared the SET options for the two clients?

John

CELKO (9/4/2014)

Attribute splitting. You take a whole entity, and break it into multiple tables. Personnel gets split n sex_code to become {Male_Personnel, Female_Personnel }. The parts are constantly being re-assembled...

Something like this might work. It's probably not the most efficient. It's not tested because of the lack of DDL and sample data. You need a numbers...

What is the exact command that is being passed to SQL Server? What happens if you run the exact same command from SSMS?

John

Full table DDL, please - we need to be able to see constraints, indexes and so on.

Also, what syntax are you using to call the stored procedure and what application...

Transaction logging still occurs in Simple mode. If the transaction you are running is larger than your transaction log, you'll get that error. Other things can cause or...

Well, if that had been what he actually did,...

What I don't understand is why you'd want to insert the same company into your table more than once - unless this is a child table with a foreign key...

Yes! That certainly looks right. Obviously you'll want to test it and make sure it gives correct results in all circumstances, including multiple inserts.

Well done - you've listened...

That's good, but it's still going to fail if you insert more than one row at a time. Better to join PAT_ACCOUNT_MANAGER to the Inserted table to do the...

Gail, this isn't a catch-all query. According your article, a catch-all query is one "where the user may enter any one (or more) of a number of optional parameters"....

That could well be it. Here are two things you can try:

(1) Use this site[/url] to check that the syntax of your connection string is correct

(2) Create another variable,...

It'll still work. You can join the Inserted table to the other tables to get that data.

John

Two things with that. You're setting the value of @PAMID, but not using it downstream. That means you're doing unnecessary reads against PAT_ACCOUNT_MANAGER. Second, your trigger will...

Don't use a T-SQL cursor to do this. Use a ForEach loop container in SSIS. You can use the results from your table to set the value of...