I have imported the data into SQL Server 2000. The trigger didn't fire. Just a simple trigger to insert a data into the Audit table whener the data gets inserted...

Thank You very much Jeff!!!

It worked.

Also, would like to thanks to all who responded to this request.

You guys are great!!!

Hi,

Need an urgent help. Kindly direct me to the correct page if it was answered before.

I have the table data as follows:

P8 X1 3804.00

P1 X2 4.54

P8 X2 4.54

Need to get the output like this:

...

Hi,

Could you provide me the contact # / e-mail ID to reach you.

Thanks,

Thank You again Jeff.

I tried to monitor the temp db size using sp_spaceused. The 'Unallocated Space' value is static when the query is running. It is supposed to change when...

Jeff,

Thank you for your reply. The Taskpad refresh works for other user databases. But not in TempDB.

Even in TempDB, I could see the Transaction Log usage. The issue is the...

Thank You. It works.