Paul, Please try to do it from scrach and make sure you test your SMTP/DB mail option in MSDB DB as well.

After creation of the DBtry to refresh the DB...

I do Aggree with Deepak, use sp_revlogin SP to transfer logins from one server to other. before Detach and reattach the server.

I am not sure about " identity Password". I am prety much sure that if you wanted to change your password in SQL server login use this SP...

sp_password [ [...

sp_recompile looks for an object in the current database only.

The queries used by stored procedures and triggers are optimized only when they are compiled. As indexes or other changes that...

Yes you need to run DBCC commands try to delete all orphened user which is no longer with your organization.

Microsoft provided script for transfering logins from 2000 to 2000...

Grinja, if you want to migrate replicated DB from2000 to 2005 that is very simple. Stop all the agents cerate script of the Replication, Take Backup of the DB and...

Thanks Paul Randal, I got something new from you.

AndyP (6/4/2008)

---

Thanks Manoj,

I do have a cleanup task in my maintenance plan.

It is that task that is removing the files.

The real question is, what date does the cleanup task use...

Any Database backup file can be restore anywhere in the server. I mean in any server of SQL. but make sure that .bak file is correct. Sometimes it may be...

There is no option in SQL 2000 but in SQL 2005 you should be check in "Enforce Password policy" and "Enforce Password expiration"This will ask you to change the SA...

I agree with Cath and Terry. I do the same. Foe more clarification why you can not change the scheduled the Tlog job for every in 2 hours so.

It will...

Why everyone is giving the same answer? If answer is already posted Please DO NOT GIVE THE SAME ANSWERS.

dbhelp (6/2/2008)

---

I don't think that would help me. That appears to backup the local database to a remote server. I am looking for a way to specify that the database...

Agree with Deepak, and Take a Tlog will free your space and than Shrink the Log file.

You can use DBCC SHRINKFILE(Logfilename)

Check with Books Online of SQL 2000 and 2005 as well.