[font="Verdana"]Checkout the link below

Database Mail[/font]

[font="Verdana"]Check the link below

http://sqlserver-qa.net/blogs/perftune/archive/2007/10/01/2284.aspx[/font]

[font="Verdana"]The best way is to capture all the errors for that database is to run a profiler trace in background and store it in a table. You need to use...

[font="Verdana"]Download MSXML 6 from Microsoft , install it reboot the machine. Once this done try installing SQL 2005 Dev Edition.[/font]

[font="Verdana"]Full & differential backups of log shipped database in primary server won't break log shipping in SQL Server 2005.

If you take a tlog backup of log shipped database in primary...

[font="Verdana"]Santhosh,

Checkout the links below too

Backup Maintainence Plan with Cleanup task

Backup Script with Retention[/font]

[font="Verdana"]Have you dragged and dropped registered server window to end of the screen??

Have you clicked on toggle button of registered windows?

CTRL+ALT+R is the shortcut to display registered server window in...

[font="Verdana"]I hope you can have both the client tools in the same machine. Why you want SQL 7 client tools, with management studio itself you will be able to connect...

[font="Verdana"]You can try the below query, but this will also display the first largest value too.

SELECT top 2 col1 FROM tablename ORDER BY col1 DESC [/font]

[font="Verdana"]You wont be able to degrade the version of database (i.e SQL 2005 to SQL2000) either by detach\attach or backup\restore method.

But you can script the entire database and execute the...

[font="Verdana"]Ok, Try the below steps.

*) Before detaching the db you need to script default db for all the logins, because if the user db is default db for logins then...

[font="Verdana"]Checkout the links below

Moving system databases -- SQL Server 2000

Moving System Databases - SQL Server 2005[/font]

[font="Verdana"]Checkout the below link to fix orphan users

How to fix orphaned SQL Server users

Why do you need to move system db's?? Are you migrating your server??

If you are need only...

[font="Verdana"]You can try the below applications.

SiteScope

HP Systems Insight Manager[/font]

[font="Verdana"]Checkout the link below

SQL Server Migration for Access [/font]