...but as far as I can tell, there are no changes to contained databases in SQL 2014, at least not in CTP1.

Jeff Moden (2013-07-14)

---

Although it's not technically a backup of a single table, you could move the clustered index (which is really the table itself with a B-Tree in the rafters)...

So I tried to repro the problem my filling up the table you posted with 10 million rows, which then exported to file in native format. Then I used BCP...

You mention spooling, that should not really happen - but I know that it can happen under some circumstances anyway. Some of these issue were addressed in SQL 2008, but...

EXEC ('DROP USER thatuser') AT YourServer

david.griswold (7/11/2013)

---

But, in trying to create a linked server to a handful of these, I haven't been able to find any combo of provider, provider string, driver, etc, that will...

newbieuser (7/10/2013)

---

We installed sql server 2012 on a windows 2012 server last week. We are unable to connect to the 2012 database from SQL 2008/2005 Management studio's. Is there a...

Sean Lange (7/12/2013)

---

No, SSMS 2005 SP3 can connect to SQL 2008 as...

c4ntaloop (7/11/2013)

---

So that makes me think in what real scenario do we want to use contained database? We know that it can have contained users and solve collation issue, which...

Here is a query that generates the ALTER INDEX commands for you. Making this into a cursor is left as an exercise to the reader.

Note: I don't have multi-filegroup database...

There is no such thing as "database refresh" or "database rebuild" per se. Of course, as gaddamshiva says, the terms can carry a meaning locally, but may not be easily...

This is a non-trivial problem, and a T-SQL only solution is impossible. If you are on SQL 2012, you should have a look at Data Quality Services. If you are...

There was such a feature in SQL Server 6.x. It was removed, because it was really a bad feature which permitted users to screw up their databases big time -...

sp_unbindefault should not work, nor does it when I test.

ALTER TABLE DROP CONSTRAINT works, but you should check sys.default_constraints, and not sys.foreign keys.

That option is for some reason only available when you design a view. The idea is that when you design a query, you put the result back to the query...