If you were to issue an UPDATE lv_order SET ord_statusID = 1 WHERE ord_id = (some valid ID), your trigger will correctly update the ord_ExpShipDate column for only the one...

We are also in the process of standardizing our processes.  We currently do not have all of our database objects in a source/version control software, but we are moving in...

I think that has alot to do with the developer's comfort/talent level with SQL.  Our programmers have varying degrees of skill with SQL so some need more support than others. ...

When you executed the BACKUP DATABASE script, did you send the backup file to the exact same location as the maintenance plan would have?

I think you have 2 seperate issues here.  One is that you need a way to look at archived data on a seperate server.  Second, you need to save off backups...

There is no need to perform a compute or count of any kind if you are looking for parent rows without children. You need an outer join. This...

OK, so you need to archive off all tables in your database on a regular scheduled basis to a different server where the data will then be available until the...

I'm not quite clear on what you are trying to do here, so let me tell you what it sounds like you are asking for. It sounds to me...

This would not be possible with BACKUP. You would need to create a data extract script that could conditionally pull data from your tables.

The parser is trying to cast the first portion of you @sql to int implicitly. Instead, you need to explicitly cast @id to varchar.

DECLARE @id int

SET @id=2

DECLARE @sql varchar(400)

SELECT...

The I/O problem looks like it came during the CREATE DATABASE portion of the restore. I would suggest creating your database first. You should be able to size...

My bad, I did not see that this was a 2005 post.  You will need to use the Cleanup History task like David has suggested.

Well, I would say that it still holds true.  If your Total and Target memory are the same, SQL Server would benefit from additional memory.  If you are not experiencing...

Could you post some sample data from table1 and table2 as well as an example of the results you are expecting?  Is there a reason you chose a RIGHT OUTER...

I just finished putting together a T-SQL standards document for our developers to use.  The following sites have some good info to consider:

http://www.sql-server-performance.com/vk_sql_best_practices.asp

http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLServerDatabases.aspx

http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsqlpro04/html/sp04l9.asp

I agree with you with...