I would recommend writing CLR stored procedure instead of extended stored procedure.

Yes. TDE can be turned on and...

You need to create TCP endpoints. TCP endpoints will have port...

This script is useful for DBAs.

Stop the SQL Server 2005 related services and keep them disabled for a month or so.

Also preserve the backup of all the system and user databases of 2005 version.

(In India) There are actors above 40 years age who play the role of a college students in the movies.

There are cricket players above 40 years age in the national...

You need to create a Credential firstly to create a Proxy (under SQL Server Agent).

Database snapshot always reside on the same server instance as the database.

Replication snapshot can be replicated to several different servers.

Try this (quote from BOL):

SQL Server Integration Services includes the three fixed database-level roles, db_ssisadmin, db_ssisltduser, and db_ssisoperator, for controlling access to packages. Roles can be implemented only on packages...

How did you test it?

No.

2³² x 2 = 2³³ = 8 Gb

This role exists in MSDB database.

Hope this tip helps you to fix the problem.

Check these:

dbo.sysmaintplan_plans

dbo.sysmaintplan_subplans

dbo.sysmaintplan_log

dbo.sysmaintplan_logdetail

Good explanation found in the BOL

This table is included in Microsoft SQL Server 2005 to preserve existing information for instances upgraded from a previous version of Microsoft SQL Server. SQL...

Is this instance restarted just before running this query?

Because when the instance is restarted, all the dmv values are reset.

Is database property AUTO_CLOSE = On?