The only option that I changed was Compatibility Level to SQL Server 2005 (90).

Other thing that I noticed now is that, all the constraints and not being generated when trying...

So there are no prerequisites set by Microsoft. Let's say that you need to have passed 431 in order to get eligible to take either 443 or 444.

Can anyone...

Got the following error,

Server: Msg 547, Level 16, State 1, Line 1

ALTER TABLE statement conflicted with TABLE CHECK constraint 'datacheck'.

Post this one in SQL 2000 admin forum, you will get better responses.

Thanks Mike & Rudy. I ran DBCC UPDATEUSAGE as recommended by SQL Server. I want to know in detail what partition id and fragmentation id are and what are their...

What is NSMainDatabase ?

I found this on another discussion forum,

"If you do not have an instance of Notification Services deployed, then you do not have to worry about patching. The binary files of...

Thank you SQL Oracle. I have setup alerts in SQL server 2005, when databases are successfully backed up. So NS is being used on that server. But, how do I...

Thanks Mohammed, I figured out how to generate these scripts.

I am able to connect to SQLEXPRESS through Management Studio, but I can't see MSDE from a server that is running EM or MS.

How do I talk to this MSDE?

Depending on the database, I have the following tasks selected.

Reorganize Index

Rebuild Index

Back Up Database (Full)

...

Something I noticed that is very useful (at least for me) is the way to get...

Is there a way to sign up with Microsoft to get alerts when there is a patch for SQL Server products?

As I visit this site often, I am glad that...

We have a MP that does rebuilding index, check database integrity, full backup, transaction log backup etc., But they are all scheduled to run as a group. Is there a...

Actually I have decided not to change the logical file names since the logical names are not relevant to the application.

I apologize, I meant the second set of result set.

We have two identical databases to serve testing and development purposes. I thought it's better to differentiate between those two not...