All I can offer is course experience I had back in school.  Seems to be a nice alternative, I had a free GUI at the time. Sorry but I don't...

Where do you log the error when the connection fails?

If every recordset is somehow presented on the forms, then the operations should be able to resume... but I can see a lot of times where that scenario could fail...

The Ninja still learns everyday on this site.  That's why I became so good and that's also why I'll be 10 times much better in 2-3 years.

As for transactions I only have a...

Without doing all the work for you :

Distinctrow = Distinct

CLONG = CONVERT(DECIMAL(18,4), Columns)

NZ = ISNULL(Column, ValueIfNull)

So what were you testing?

I find it very usefull when an actual link is posted.  That way the date becomes much less of an issue when trying to find the said thread.  Thanx in...

Can't agree more with you on this one.  Be here done that, twice this week alone .

All objects refferencing that table will be recompiled.

Can we see the script to see if we can change it there?

This would force a file change :

ALTER DATABASE [Ideal_Audit] MODIFY FILE (NAME = [Ideal_Log], SIZE = 1300MB)

Afraid not...

You can search syscomments to find all cursors and then update 'em all :

SELECT OBJECT_NAME(id) AS ObjName FROM dbo.SysComments WHERE Text like '%CURSOR%' ORDER BY ObjName

Thanx again... seems to be luck of the current load that dictates the results and not the function itself.

I agree that it is more secure that way...  but if the virus can reach is PC, what's stopping it from reaching the other servers?

Also I can't say I'd be...

Ya I saw that too.  The mystery around the plane could be explained with pocket of gas going out of the water.  Pockets that when big enough could sink a...