Database context should be changed to 'master' before executing the sp_ms_marksystemobject procedure:

USE master

GO

EXEC sys.sp_ms_marksystemobject 'sp_one'

GO

USE test2

GO

michael.kaufmann (8/23/2011)

---

I may be wrong, but as far as I know, you cannot...

Nice question.

There is a typo in the answers - "Page Free Spage" should be read as "Page Free Space".

Not true. See the 'CREATE TABLE' topics...

Try this one:

SELECT i.*

FROM sys.indexes i

WHERE i.object_id = OBJECT_ID('the_name_of_your_view')

ORDER BY i.name

tilew-948340 (3/30/2011)

---

A unique clustered index is...

Good question with wrong answer. Actually, nonclustered, unique clustered, and unique nonclustered indexes can be created on indexed views. Another matter that a unique clustered index must be the first...

I wonder how many records in one's database containing year 1752 😀

I had read the answers several times before I...

No rows were inserted into table2? B not C is the correct answer? Terrible, terrible explanation 🙂

Christian Buettner-167247 (12/16/2010)

---

This error is raised all the time, and also when you switch the table to which you add this extra column. To me this is a strong indication...

The bad news is that, according to BOL, "this view is applicable only to the tempdb database".

Very interesting technique.

But inserting extra data and then deleting them is not the best solution, because delete operations are expensive. It's better to add a condition in order to insert...

Good question.

But this is not an explanation at all:

I suggest the following explanation.

The SELECT query...

It came...

Comments are...