You were running in serialisable isolation?

Did you check the session_id in the trace? Was it from the session you were testing with?

Not something I've tried recently, bu why not

INSERT INTO...

EXECUTE msdb.dbo.sp_help AT <linked server>

lallu_jaya (8/5/2014)

---

1. Is there any other way I could encrypt master database if not through TDE?

As master database is so imporatant, it has paths to all the files, logins,linked servers...

Try recreating the NC index with Partition as the third key column.

Was the table you were querying in master? If not, why are you checking the catalog views in master?

No, it's not a composite ID. It's either the partition id, allocation...

You miss some corruptions. Physical only is designed as a limited set of checks for frequent checks of busy servers. Since you're offloading the checks to another server, there's no...

Delete data?

Why are you using physical only?

What's 73-461? The beta exam?

marcocrocevia (8/5/2014)

---

I tried with lock acquired event and enabled all columns but I'm not able to see the indexes where the locks are acquired, do you know where I can...

What's the definition of the table?

That's the easy part, and the last part. You need to get all the stuff around storing their last few selections done and working first.

Why? What reason do they have for such a strange requirement?

I don't, and I'm way too busy to write the whole thing, unless you want to wait until October.

Have a go at it, I've given you the main elements. If...

First thing you'll need a table that stores the user's last selection. Each user should have one row per drop down you want to do this to. When they select...