Or get someone else to look the queries over the queries. Helps when more than one pair of eyes look at it. You really need to avoid the timeout change...

If all you did was change the install or register those DLL's, then yes and that was the answer. If they don't, then keep looking or reimage that machine. Otherwise...

Also be sure that your cursor is really needed to accomplish the job. I have in the past used cursor too often and recently reevaluated and got rid of 95%...

Technically since they created the system and we license it, they own the actually db.

Short and simple:

DECLARE @date AS DATETIME

DECLARE @int AS INT

SET @date = '1/2/2002' /* Change to the day you wish to start at. */

SET @int = 0

WHILE @int < 20 /*...

Or this if it varies like my network then.

ORDER BY CAST(RIGHT(IPAddress,(3 - CHARINDEX('.',RIGHT(IPAddress, 3)))) AS tinyint)

That's usefull, I'll give that to my bud who gets stuck with all the account resposibilities.

Again you could parse the date, something like this:

SUBSTRING(CONVERT(CHAR(10),dateFld),4,2) + '/' + LEFT(CONVERT(CHAR(10),dateFld),2) + '/' + RIGHT(CONVERT(CHAR(10),dateFld),4)

This should do it.

No the SQL Server setting. If you right click on the SQL Server in question in Enterprise Manager one of the tabs will have a language setting at the top...

Ok so last thing, you say that if there is no value for Pax, admin, or crew then there is no row. Then do you have a table with all...

Yeah that seems true everyday, but they also say "practice makes perfect" and I am telling you some of the idiots must practice regularly.

For changes to inhouse items I use scripts or make the changes directly (usually when it is a handfull of simple things). The worst thing I ever had to do...

Go with the FROM inserted version, as the data does not exist in the table at the point the trigger fires. If you want to catch when they insert %end...

I don't know what the licensing issues are with DTS and may require a lincense for Enterprise Manager. But looking at the files dependencies I did not see anything that...

And you do have to have the ()'s around your variable.