Thank you very much for posting the solution It will help me (and others) in case we com accross long running queries scenarios

have you tried ?:

ping infotrail-ink88.infotrails.org

>> But it seems to be ignoring it because if I set QueryTimeout to 10 -- which you'd expect to cause the query to timeout after 10 seconds -- it...

>> If i change them all to the same type then do i use double quotes?  <<

YES use  '' (two single)  not "

ex:

EXEC sp_addextendedproperty

'MS_Description', 'Employee''s...

I believe the entry on the registry is supposed to be GREATER that 60

at least that's what I got from MS or you could try it anyways.

Do you have...

>> I do not want to use: If UserRole = Manager... << why ?

Other than that you can call sp_helprotect like:

EXEC sp_helprotect NULL, NULL, 'UserName'

this seems a bit...

That seems to be one of the ADO "gotcha"s. Make sure that in the select statement in the stored procedure the TEXT columns are the LAST columns 

Like:

select col1,col2,........, coltext1,coltext2,coltext3

from ...

You could use a trigger but rolling back transactions on atrigger can cause problems down the line you should rather do it up front!

Are you allowing direct access to...

Can you explain a bit more what are you trying to accomplish? Char(10) is the equivalent of line-feed and if you know it why would you "generate it" ????

>> Have those who are against the idea ever belonged to a union? <<

Lori, I have and I can't put into words how much I suffered !!! Believe me it all...

OK here you go:

Do you mind to try:

@CY char=[Forms]![frmAcYear]![AcYear]

Note: NO SPACE between "char" and "=" nor between "=" and Form Field

Tony,

I was just joking with sushila! You are free to choose which ever script you like best ..... for whatever reason

Good for you!

You can but watch out for the temp tables "gotcha"

if you procedures create temp tables those are going to be created using...