This Sp will give you details of every database use aaa

GO

create PROCEDURE [dbo].[sp_SDS]

@TargetDatabase sysname = NULL, -- NULL: all dbs

@Level...

sudhakara (4/16/2010)

---

I have disabled the job's(copy , Restore & alert) which is belongs to log shipping process at the secondary server.but i am seeing the restore job failed messages with...

Did you install it carefully (means got any error/warning during installation) ? i think you should get.

Is your login has required privledges ?

Are you using the same login to execute that job (i mean, any change in its database role) ?

Has this CD been used for sql installation earlier(in past) ?

Profiler's Videos

http://www.sqlservercentral.com/articles/Video/66676/

http://www.sqlservercentral.com/articles/Video/63814/

for Execution plan

http://www.sqlservercentral.com/articles/Performance+Tuning/displayingexecutionplans/1103/

http://www.sqlservercentral.com/articles/Performance+Tuning/understandingexecutionplans/739/

Try using single quotes. Also i think your row terminator is new line character followed by comma (,). I added comma in the row terminator. check that one also.

BULK...

ychen 55059 (4/13/2010)

---

I've just started to use CTE's to concatenate individual row values into 1 field and I'm liking the results. However, 1 of my CTE queries is taking...

i dont think this suggested index is required here as clustered index itself fullfil the requirement

and also we should not blindly trust tuning advisor.

check BOL for msdb.dbo.sp_send_dbmail

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

1. Study execution plan

2. Read IO statistics

3. Refer...

DML triggers only work for INSERT/UPDATE/DELETE operation on tables and DDL triggers work for schema changes on sql objects. So no help from triggers in your case

@Chandhini . if you post the syntax of your ALTER statement , we can try to give the cause of its failure

See this also http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/321bda9d-0971-47a1-b65e-ee01bdfb0fc1

http://www.bigresource.com/Tracker/Track-ms_sql-bfOhjw3U/

chanti2985 (4/9/2010)

---

We got the below error.

Error: 2010-03-24 07:01:25.99

Code: 0xC0012024

Source: ST_Enter JobID

Description: The task "ST_Enter JobID" cannot run on this...