You can script from the action you do in the GUI. I didn't see this anywhere else (like any of the property functions), but this will do the job...

One call on my break, not too bad. I celebrate Christmas and it was awesome. I didn't know this question was about political correctness and what we(we =...

If I follow your instructions correctly would this be close to what you would need:

select

Bill_Date,

[Status],

COALESCE(DATE1,DATE2, DATE3,DATE4,DATE5, '1/1/07') AS 'THIS DATE'

from Test

where [Status] in ('active','zero bal')

Awesome....thanks Ray

I evaluated several products and was impressed with "surprise" IBM.

This is a link to the SQL Server monitoring tool:

http://www-306.ibm.com/software/tivoli/products/monitor-db/microsoft-sql.html

The company did not go...

The E: drive is local....but the following has happened

We set up an FTP share on another server before any security changes are made.  The process works against that server.  Security...

Thank you for the explanation

No port is specified just the database name, instance name(it is a named instance not a default instance), and username/password.  I will look for some articles on the server figuring...

I agree with Kramer on looking at OLAP and OLTP.  Are the queries needing to lock the table or could you put (nolock) on some of the statements.  I wonder...

Is it a problem that just happened this morning?

Is the application still working or does anybody get timeout errors?

Have you made any updates to the application?  Have you used SQL Profiler to see what SQL statements are being executed?  You could look in Profiler and how long statements are...

Check out this Microsoft article on different ways this error can occur.  Hope it will shed some light on your issue.

http://support.microsoft.com/default.aspx?scid=kb;en-us;317375&Product=sql2k