Hi

Well your design is certainly a bit different from the usual way of doing things, but i reckon its a good design.

Do keep in mind the type of queries that...

Hi

it seems SQL thinks its better to have a table lock rather than row locks.

do u have any index on the table. check out setting index locks in BOL.

what are the schema changes u made.

Hi

If its a job thats dropping and recreating the procs disable it.

Otherwise change the code that does this

and if for any reason u cant change the code use a...

Well... it may be possible.

If u can correctly identify the row in the original table which corresponds to the row&column in the privot table.

Hi

First why would you want row level locks. A table lock will reduce lock contention and have better performance.

If you dont specify the TABLOCK hint it should be using...

Iam with alzdba there. Use the correct datatype.U will hv to use the first query to get the correct results.

Had there being a datetime column you would'nt have these issues...

Hi

dont know about the image field. but the datatypes are the data types of the destination tables. So if thats not the data types you want then modify the destination...

Hi Gail

I meant my answer was not fully correct. Any way i had taken this topic in my browser before you had answered, but updated my answer after you...

Hope somebody can come up with better anser.

in sysprocess there is a column blocked which shows the processid of the blocking process.

What about using profiler for this.

there is no way to do a backup/restore of selected tables.

I think your approach of restoring it as another db and importing the data is correct.

did u face any problems...

problems probably got to do someting with xml u r inserting rather than the trigger. I did not get this error. This i what i did .

Created a new...

detach db ---> copy db files to new location ---> attach.

one question: what do u do when the db files are large?

between '2008/01/01 12:00:00:000 AM' and '2008/01/01 11:59:59:997 PM' if u want all records between the 2 dates.

sys.objects or information_schema.tables