The 4GB limit is only for Express, Web, and Workgroup editions. Standard and Enterprise editions are only limited by the operating system maximum.

You might try using the URL in the server name when connecting via SSMS.

http://<SERVERNAME>/reportserver

If I remember correctly this had to be done to work around an issue with...

DBCC DBREINDEX and DBCC INDEXDEFRAG cannot be used on system tables.

http://msdn.microsoft.com/en-us/library/aa258828(SQL.80).aspx

http://msdn.microsoft.com/en-us/library/aa258286(SQL.80).aspx

NO_LOG and TRUNCATE_ONLY options have been removed in 2008. You can switch the recovery model from FULL to SIMPLE to achieve the same thing.

http://msdn.microsoft.com/en-us/library/ms186865(v=SQL.100).aspx

The BACKUP LOG WITH NO_LOG and WITH...

Put the package name in quotation marks.

dtutil /SQL "Import BTXMASr8 Table" /DELETE

If the database fills the primary data files to the max file size you have set for them, the following error message will be written in the SQL log and...

Use SQLCMD in a job step on the local server using the operating system type for the step.

SQLCMD -E -S REMOTESERVER -Q "msdb..sp_start_job 'RemoteJob'"

Something like sp_helplogins?

http://msdn.microsoft.com/en-us/library/ms190304.aspx

See DBCC SHRINKFILE

http://technet.microsoft.com/en-us/library/ms189493.aspx

Shrinking data files will cause index fragmentation and you will need to rebuild your indexes after the shrink.

You could restore the backup to the same system with a different name or to a different system. Either will work. Then use the Import and Export wizard to copy...

You cannot restore a single table from a native SQL 2008 R2 backup. However, you can restore the entire database with a different name and then export the table and...

Right click the db, Tasks, Generate Scripts.

You can script the stored procedures from here with many options.

I agree. We just finished a migration...

You need to use the cluster network name which can move from one node in the cluster to another. If you have Server1 and Server2 clustered there would be a...

From BOL:

Permissions

--------------------------------------------------------------------------------

Requires VIEW SERVER STATE permission on the server to see all executing sessions on the instance of SQL Server. Otherwise, the user sees only the current session.

http://msdn.microsoft.com/en-us/library/ms174313.aspx