Just a reminder:

The WHERE clause is the FIRST evaluated in a SELECT statement therefore that condition will return true and wont be evaluated every time 

OK this is what I need you to Post:

1. Open the Data Sources (ODBC) applet on the Control Panel!

2. Go to the DRIVERS Tab and check the version of your...

Not sure exactly what you mean?

RESTRICTED_USED is a Property of a Database. When the DB is set as RESTRICTED_USER, only sysadmin,dbcreator and db_owner have access to it!

hth

Can you be a bit more specific :

1. What do you mean by Controller?

2. What is your DRIVER version ?

3. What is your ODBC DRIVER MANAGER version ?

One more thing: Isn't it possible to filter also on the DATE in the query?

btw: Very nice script!

Wrap the union in a select then execute the where from the wrapper:

Select * From

(

Your UNION

) dt

where origin = 'x'

Watch and wait, so to speak? <-- YES

That's the price for "A.C.I.D."

Not sure what spid 10 is but deinitely if you "restarted" the service is the service who is going to run a recovery process on the user DB not a...

Ben Why do you need a VARIABLE?

If you are just saving that column on an audit table or some other table for that matter you simply:

insert into DESTINATION_TABLE ( img)

select...

that is another way but may preclude the use of indexes

John,

If the columns that are being compared with <> can contain null values you will need to account for that also like:

where

       col1 <> col2

       or

       (col1 is...

I for one tried once when consulting for a client that owned it before Quest bought it and with fairly small to medium queries it performed "acceptably". The issue is...

Ah!! Missed the CASCADE

PW you are correct! 

apparently the primary key was not good enough (which is what was used in the...

I have never tried this but here is a thought

You can run dbcc inputbuffer (@@SPID) to read the buffer contents. Not sure if that will help you though. Keep in...

Just to clarify a bit David's Answer:

/E means use Windows Integrated authentication

/e means specify error log file path

you are already using sql authentication

Cheers