Now why today would be any different for me .

Also I must point out that I don't like the convert option as it...

She's addicted to this site... so she won't resist long.

Order By

CASE When @SortOrder = 'My_ID' Then My_ID_Int ELSE NULL END,

CASE When @SortOrder = 'My_Date' Then My_Date ELSE NULL END,

CASE When @SortOrder = 'myString' Then My_String ELSE...

Is it possible that they are missing in the models db too?

Maybe it's only new code that is exposing that. I've seen cases where paralellism was blocking itself... can't explain why though.

Seems logical!!!

Now you're pushing it Sushila.. I never said he was my hero.

If all the selects are done with SPS, you can create a new sp that logs the selects, and call that sp in each sp of the db.

I think bigger problems here is an understatement... how the hell do you expect the users to navigate through that?????

The easy way would be a mapping of some kind... probabely possible but I just got no clue to where to even start looking. The dynamic sql client side...

Do you have hyperthreading processors or multiple cpus on the server?

Check if the server can access that file (ntfs permissions) and that the file path is correct. The server must be logged as a domain login to have access...

Create trigger tr_emp_Audit_UD on dbo.emp

for update, delete

as

set nocount on

Insert into dbo.emp_history (emp_number, emp_name, join_date, sal)

select emp_number, emp_name, join_date, sal from deleted

go

you might want to add a modification data on the...

What does this return?

Select @@ServerName

This is just a guess here but it might be what you need :

Declare @ofsav1 as int

Declare @ofsav2 as int

Select @ofsav1 = sum(afbc)- sum(afoc), @ofsav2 = sum(ofbc)- sum(ofoc)

from...