Can please elobrate what exactly your requirement?

Pls try following steps:

1. In SSMS, click Tools->Customize

2. Select Commands tab,click Rearrange Commands

3. Select View in Menu Bar list

4. If Object Explorer is not there, click the Add... button, select...

Try with using shortcut key "F8" in SSMS.

If I am getting you correct then,To get functionality of trigger, you need first create trigger on perticuler table after that only trigger will evoke as per the defination. ...

As you canceled the restoration process in between which resulted database went inconsistency state so I will advice you rerun the...

You can find which spids are using the DB by below query

Select * from sys.sysprocesses where dbid =db_id('DBaname')

Your database might be in use while u bringing the database to offline. try to kill the spid which are using the db. or you can use below command to...

It seems that Full text service is not installed, You can do this by running the maintenence mode from Add/Remove Programs and add the FTS component by running the...

you can download the ready made template from here.. 🙂

http://intellabase.com/DeploymentManagement.docx

SQL Server 2005/2008 Setup Checklist

http://www.brentozar.com/archive/2008/03/sql-server-2005-setup-checklist-part-1-before-the-install/

Here is a query for this.

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

SQL Server Cluster Nodes:

SELECT * FROM sys.dm_os_cluster_nodes

SQL Server Cluster Shared Drives:

SELECT * FROM sys.dm_io_cluster_shared_drives

General Best Practices for backup retention.

http://www.mssqltips.com/sqlservertip/1401/sql-server-database-backup-retention-periods/

You may go with multiple DBMS to enhance your skillset like sybase or oracle with Sql server.

You have enable the "SQLCMD mode" of the Query Editor, which is "disabled" by default. To do so, go to the Query menu and click on the "SQLCMD mode" item...

Is this SQL Agent job created on remote server? if yes and you have access on that instance then you can simply see Agent jop properties.