But the problem here is if a new db is created, the query will have to be run again.

Connect to a windows client machine in the same network (any will do). Open a command prompt and try "telnet <IP> <port>" and hit enter. If it opens...

Make sure the Servername and instance name you are giving is correct... Also double check your username and Password are correct... and try giving it like Servername\instancename (If it is...

Thanks much. I gave the user db_reader permission on the second database and it worked like a charm !

Is there a script to find the object dependency ?

These screen shots might help.

Thank you all for your valuable replies. Yes GilaMonster. I will be using the sp_help_revlogin to transfer the logins. I will be running Upgrade advisor before the migration.

Another question...

Created non-clustered indexes on some columns as suggested by the execution plan and the result shows up quickly. Now there is no visible change even from the application.

Checked those. The Procedure being executed by both methods(Management Studio and application) is the same. There is no difference in any of settings you mentioned.

Passwords are encrypted in SQL Server.

Do you want to know the Maximum Capacity Specifications for SQL Server or do you want to check it on your server ? If its Maximum Capacity Specifications for SQL...

I totally agree with what Lowell said. SErvice packs do not alter the format of the backup files. So you can restore to any installation of 2005.

David,

Scripting out works well...

Try the following. Change the [Database_name] to your database. Also change the logical_file_name.

Use [Database_name]

GO

--Issue a checkpoint

Checkpoint;

GO

--Backup your log file

backup log [Database_name] to disk = 'C:\Backups\Backup_name.trn' with stats = 1

GO

--Shrink...

To start the default instance of SQL Server in single-user mode from a command prompt

From a command prompt, enter:

sqlservr.exe -c -m

Note:You must switch to the appropriate directory in the command...

If you want to use the command prompt and execute sql statements use SQLCMD

What query do I use in WMI event alert ? Or any documentation suggestions ??