Suspect means that the database may be transactionally or structurally inconsistent. This is the result of either a rollback failing (typically because it encounters a corrupt page) or the restart-recovery...

It had better be a very good reason. Messing with the system tables, especially on SQL 2005 where they are not documented and not straightforward, is a quick way to...

You can't. That message is added when someone does a direct update to the system tables (which requires more than just sp_configure 'allow updates',1). It's there as a warning that...

Why? What's wrong with the standard code? What is it not doing that it should?

Did you bother to read the links that bitbucket provided? If not, please do so. If you still have questions after reading them, come back and ask.

Even if such a thing is possible, by doing so you will completely lose all support from Microsoft. If you hack a system like that and then call customer support...

Yes and yes

A temp table is dropped when the connection that created it is closed or when the procedure that it was created in ends.

You can't create a temp table in a...

That's complete garbage. It's AWE that's not required on 64 bit operating systems with 64 bit SQL.

If you look at the annotations (Click the 'annotations link, top-right of the page),...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic886960-150-1.aspx

Just too easy to have something else in SSMS grab the only connection. Specially if there's 3rd party add-ins in SSMS (which I have). SQLCMD I know there's only one...

I prefer to have SSMS set to open an empty environment. No object explorer connections, no query window connections.

Lynn Pettis (3/20/2010)

---

Yes, READ UNCOMMITTED can be the right choice for many applications, the problem comes when it is selected and it isn't appropriate and people start complaining about inaccurate...

Possibly because Object Explorer took the only allowed connection. It's one of the reasons I prefer to use SQLCMD...

Master cannot be set into single user mode. Why are you trying?

rebuildm is a SQL 2000 command for rebuilding the master database. In SQL 2005 the setup command is used...