If you are installing from CD then -->This happens because in CD format, the tools are on the second disk. (DVD installs do not have this problem) Follow one suggestion...

I assume you restarted the sql 2000 after changing its authentication mode. Also, you started afresh once its restarted

MJ

In case you have any other 2005 instance installed on this machine then try creating one login there and see if it accepts the password you supply for it. Make...

Have you logged in with admin privileges on this box?

If the machine is not a domain controller then you must be able to do the following changes:

3. Go to...

Or

Make sure you follow restrictions mentioned at http://msdn.microsoft.com/en-us/library/ms161959(SQL.90).aspx

MJ

From googling:

Several simple solution steps:

1*. Go to Administrative Tools / Domain Security Policy :: Security Settings | Account Policies | Password Policy

2*. Ensure "Minimum password length" and "Password must meet...

Another job rebuilds the indexes on the tables nightly.

DBCC DBREINDEX creates new indexes before dropping the old ones. This is done as one atomic transaction, so a lot of...

Excerpt from books online:

A recommended process for implementing differential database backups is:

Create regular database backups.

Create a differential database backup periodically between database backups, such as every four hours or...

Set target size to used space+Some breathing space. Yes, you can shring log file after that. Don't forget to do reindexing/defrag after shrink.

MJ

Normally you shouldn't shrink.

http://www.karaszi.com/SQLServer/info_dont_shrink.asp

If you have decided then decide the target size based on how much space you want to leave in mdf file after shrink operation is done....

Try bringing in database online and run DBCC CHECKDB. If it allows you to recover the database by not making use of any data loss option then its okie to...

Follow the above advice if you tried every...

Rakhi,

I ran codeblock1 thirteen times and got what I expected under codeblock2 output(i.e. 13) but when I did a small modification in the query under codeblock1(I just pressed ENTER) then...

I don't think RTM will go with X64-bit editions. Check-->http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx

MJ

Actually, SQL Server 2005 handles permissions differently than SQL 2000 when detaching dbs. Under SQL 2005, the file owner *changes* when the db is detached. This was not...