It means some one killed your session or connection drop check connectivity or just re-open session or re-connect nothing to worry much.

It depends on what kind of data you have or getting in for that column.

See here

EXEC uspPrintError

GO

I know before this thing but I answered it wrong bcoz

EXEC uspPrintError

GO

what this doing over there.

Have you tries with run-->ssms

Thanks, The issue is that because the space is allocated it will not be move to the end of the file for truncation and since I delted the table, I...

Check options what you had in your backup/restore tool carefully.

I thought you did with the script you mentioned the session.

the space is not released untill you close session that is the reason and you made backup with out closing the session I guess.

Go back and check all the options carefully may be you missed to check some of them.

try to install with network mode.

Shrink it with option release unused space.

try Run--> ssms and windows authentication.

Follow these steps:

1. Check if the same query is causing locks then tune it with (nolock) hints in queries.

2. try to schedule it in different time and see.

3. Check Isolation...

When did you did backup?

after shrink or before shrink.

There will be no issues till you run in older compatibility mode

ex: Running in higher version box with no change of compatibility mode

like 2008 box but db compt...

You are welcome from SSC

Regards,

Pavan Srirangam