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...

I think the large table will be locked while the new column is added. Try it for yourself on a test server, and see what locks are acquired. ...

Happy to help. You can make it a bit neater by putting the CASE logic near the top:

...

SET @carage =CASE

-- don't need to cast as int because that's the...

Kalpana

If you specify your service account in SQL Server Configuration Manager (instead of in the Services applet), the correct permissions will be assigned. I don't know how they suddenly...

Comparing any value to NULL will return False. Please will you show us your query?

John

Edit - I think I see what you're trying to do. Will this work?

WHERE...