Msg 121, Level 20, State 0, Line 0

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired

In...

If you want to restrict user can see only definition of the objects then remove all rights exclude public then give VIEW DEFINITION

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA...

Install DB2 client on the SQL server machine and create the DSN of this DB2 machine and create the ODBC Linked Server then check this,RPC and RPC out should...

You have already a gaint Server HP 980,send me these information as well

1-Total RAM in a Server ?

2-Total Physical Drives not partitions (According to my understanding FusionIO is work as...

I know very well,but SP2 of SQL Server 2008 released after SQL Server 2008 R2,I have mentioned just try it,I didnt said that is the solution ok,You cant access SQL...

yes i forget to mention you have to change the password in the login script because when you generate an script then this will have encrypted password,so change as you...

That solution for manual jobs execute automatically,It will check by the DBA which one is resource full and etc,I will not suggest you to change the career because I love...

Hardware requirement and analysis depend on the load of the Server,RAID Level 5 is best for databases and RAID Level 10 is costly but better than Level 5,Fiber channel Card...

1-User Databases backup

2-Jobs Backup as attachment shown

3-Linked Server script Backup if any same as job backup

4-Logins script backup same as job backup

5-Database Trigger script Backup if any Right click to...

SELECT @@VERSION

Cumulative Update # 6 is available for SQL Server 2008 R2

http://support.microsoft.com/kb/2489376

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

Just create a new login then give public role on msdb and give these 3 Roles to a newly added user

1-SQLAgentOperatorRole

2-SQLAgentReaderRole

3-SQLAgentUserRole

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP...

First thing is go to the agent and then right click on it first set the history maintain in the database as attachement shows

Second things is go to Job Activity...

SQL Server Management Studio,type ssms in the run then this studio will open,its client or management tool for SQL Server

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP...

is your application Server is another than SQL server,is there network medium betweek these servers

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My...

There are several indexes are showing Scanning it must be index seek

Index Seek is better than Index scan,work on it

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP |...