OK, a trusted connection is usually a domain account.  In that case, you don't put the username and password in the connection string.  So, do you have a DBA or...

Take a look at the indexes on the table.  It is possible that SQL is scanning the entire table to find your small set of rows to delete and that is...

Frequently, web apps use a SQL account to connect.  Are you sure that you are using a valid SQL account and passoword?

Instead of increasing the timeout value, maybe you should look at how the query is written or break it down into smaller pieces.  Sometimes doing several smaller updates is much better...

If you are talking about sending the definitions of the table and stored procedure, there is an easy manual process.  By expanding Enterprise Manager until you get to the table...

Basically, a hash index uses a computed value instead of the real value.  There is a topic "CHECKSUM" in SQL Books Online that shows an example.  In this case, the...

Also, you said that you changed the account for the "services."  Make sure that you did change the account for SQL Agent.

In Enterprise Manager, expand "Managment".  Right click on "SQL Server Agent." On the "General" tab, select the email profile from the drop down list.  Then click "Test."  Then click "OK." ...

Occasionally, when setting up SQLMail for the first time, I just can't get it to work until the server is restarted.  So, if you are still having problems after trying...

Another thing you can do in addition to the resources mentioned by Jonathan is play with a query builder and then look at the code produced.  That is how I...

I'm not sure if your logic is correct, but I do see a couple of syntax errors, you are missing a ')' after the word 'INSERTED' in your first while...

You are correct that there are problems if you are using text columns, but you can pull some information from deleted.  If you are willing to have partial information from...

Brian's advice is accurate, but I don't think he is answering the right question.  You want to know if you need to specify the database name in the query. 

You...

You could use a group by clause to do this. 

select a,b,c from tableABC group by a,b,c

If you have some sample data and the results that you are trying to...

I thought I just replied to this, but now don't see the response.  I apoligize if it shows up twice.

You should not use the "Instead of" trigger in this case. ...