I don't that there is something as single table backup. But you can always dump data into another table using SELECT INTO..

If you want to move data between instances you...

It is usually a term that is used for a database restore. But every environment is different. And every environment has its own set of terms and definitions.

You could use database snapshot. Database snap shot will give a snapshot of your database at the point in time you create the snapshot. You can access the snapshot while...

Hi,

In that case the indexes you are looking at should be very small indexes. Its better you look at the page count of those indexes. Below query will give the...

It is widley not know that Online Index Rebuild also does takes very short table level locks. A shared lock at the start of the operation(called Preparation Phase) and SCH-M...

There are lot of stuff u can do to improve this query. First thing I would recomend is Upadating the stats on most of the tables in the query.

I...

New Server Registration window does not even open. The error pops up even before that.

Yes, TCP/IP is enabled.

I am using SQL Server 2008 R2 and SSMS shipped with it.

I have recently upgraded the SP to SP2

Yeah the reason I put TRY/CATCH was so that I could catch those indexes that conatin LOB columns and cannot be done online and rebuild them manually during downtime.

I think...

Thank you very much for the advice.

Actualy We have both CDC as well as Auditing in place for the prod database. But this was a local environment. Where we have...

Yeah I did the same thing. But the problem here is the SID was showing 0x01 which is a dbo user. i.e.. a sysadmin mapped to dbo with have SID...

I am sorry for the repost. I will make point that I will not do it future. The reason I did that was since it was security question I wanted...

Yep Downloded it lng time ago. Thank you.