It's bitmapped. Meaning the 512 is the bit (#9) that determines if the database is offline. So you OR it with 512 to check the status of the bitmap.

http://www.sqlservercentral.com/articles/Miscellaneous/2748/

Start | Programs | SQL Server | Profiler (I think that's the path on a 2000 server).

Connect to your SQL Server, start a new trace, choose the defaults. It will...

A few things.

1. If there is a guest user in the database, then the login will get mapped to there, can access the database, but they have the rights of...

What's the stored procedure doing? It's what it says, the proc is trying to reference those objects and they either don't exist or the user can't see them.

What's the stored procedure doing? It's what it says, the proc is trying to reference those objects and they either don't exist or the user can't see them.

smithsjt has it right in that if you have the junction table, you have a many to many.

For a one to many customer to salesperson, you really have CustomerID in...

It marks all committed records, which were backed up, as free, which is the same as truncate. It does not change the file size from the OS side. Internally the...

To move logins, get sp_help_revlogin from Microsoft, which will script out the logins with the same password.

I'm not sure what you mean about the upgrade. Did you mean update?

The update changes the field specified only. If there is a username field in the web table, it's...

The link has been corrected in the article.

I'd go with those. sqlSentry has a performance monitor that looked outstanding when I saw it at TechEd.

RESTART

Note:

Supported only by RESTORE.

Specifies that SQL Server should restart a restore operation that has been interrupted. RESTART restarts...

I wouldn't go to a NAS. Asking for issues. Any network hiccup and your backup fails. And it will fail the day you need to restore. Disk is cheap. Get...

I thought it was about 30-35 multiple choice and 12 sims, but I could be wrong. It's been well over a year for me.

You need to be familiar with SSMS,...

Use EM, right click the database and select Generate Scripts.