Don't get caught in absolutes. Put the logic where...

Not that I'm aware of. There are example queries around here on SSC if you look for them.

If you do a backup & restore, it's a page-by-page copy. If the restore is successful, there's nothing to check. Everything moved.

However, yes, if you use any of the other...

Cannon's are legal...

The number of tools that will let you move things is huge. SSIS will work. So will using the import/export in SSMS. Can you just start with a backup &...

The other key word you need is DENY. In addition to GRANT permissions, you can also DENY permissions.

Sounds like the user might belong to a group that has more access...

I'd probably lean heavily towards using tasks defined through whatever tools we're tracking bugs and other work in. Especially since those tools usually can be correlated to source control. Since...

It's for the Task List. The short cuts act as markers there. Got the answer from Twitter.

Great question. Not a clue. I just tried it out. It puts a weird looking arrow in there. Several clicks in and around it yielded nothing. Hmm...

Happy you found the answer to the issue.

Well, your network persons assurances aside, that looks like a network error.

However, capture the query metrics and the wait statistics. Don't guess. Don't hover at the edges, looking at system...

First, set up Extended Events to capture the overall performance of the queries on the system. You can use rpc_completed and sql_batch_completed events to capture that information. Personally, in your...

Nope.

System databases and system objects are managed by the system. That's it.

Spring Surprise or Lamb's Bladder Cup?

Nothing you do is going to show that. A newly restored database has no performance metrics stored with it of any kind.

In order to diagnose this kind of behavior, you...