SQL Server will not use an index on a (LIKE '%query')  filter so you might want to reconsider this type of query. 

Base don what I see so far, for your first time through you are going to execute your code in the IF's.  After executing you need to Set @last_acctno =...

YOU can also place Print or Select statements in your trigger(s) to  determine if or where the trigger(s) are firing and failing.

Alerts emailed to an Operator include the Server Name.  So I wouold use one account.

Not being a web developer I cannot be sure what the issue is.  One thing you can check in SQL Server is if the database Auto Close option is on. ...

Finance is being unrealistic.  If they expect IT to offer any support then at least on IT person has to have Admin access to the server and to the database. ...

First I would try to determine WHY the database is being marked as suspect.  Here are a couple of reasons we have had the problem at my office:

You have a...

I am a fan of using Identity columns as  primary key and then if appropriate using the "natural" key as unique clustered index.  Since the promary key is what should...

If you are using SQL 2K you may want to examine using a table returning or inline user-defined function.  You can almost look at these like a parameterized view.  It...

The correct way to call xp_sendmail using T-Sql is:

Exec master.dbo.xp_sendmail

The use keyword in T-Sql is to change the database context in which you are working.  YOu cannot do that...

Cross Database ownershp chaining works, but you have to remember that enabling that means it works all the time.  SO if you have tables you do not want to have...

I agree with the other posts.  Unless someone can tell me what hte Windows Application Application Log is I would have to say that the Windows APplication Event Log +...

While I have not implemented partitioned views in porduction I have done some experimenting with them.  I believe that if you are using an Identity field in your tables that...