capnhector (11/7/2012)

---

if your just looking for a report of backups you can query msdb.dbo.backupset which contains allot of information

select top 10 b.database_name, b.backup_start_date, b.backup_finish_date

from msdb.dbo.backupset b

with a join...

Thanks for the script

Is the job enabled? Does the job use any linked servers? Please post the results of view history of this job.

Per your example the order does not matter. What is the size of the index and the table? What is the number of reads over writes for that index? Before...

Cool...Thanks so much lowell...I was working on it parallely and came up with almost a same script..please find mine below:..Thanks a bunch again

DECLARE @TableName VARCHAR(255)

DECLARE @PKColumnName VARCHAR(255)

DECLARE @sql...

Thanks for your help Lowell. I have too many tables and I want to put it in a cursor. But I am stuck at the inner join condition. Here is...

Sapen (9/26/2012)

---

I verified my local policy settings and found out that "Enable computer and user accounts to be trusted for delegation" has none added to this policy. I just...

I verified my local policy settings and found out that "Enable computer and user accounts to be trusted for delegation" has none added to this policy. I just added...

Experts I need your valuable inputs. Thanks Again.

go to control panel--> windows updates-->check if you have enabled it

Ensure that you have no automatic updates scheduled on your servers.

The Linked server is between sql servers.

I will also be adding few maintenance jobs on this database that will actually purge data from this database on a daily basis and we are using Entity framework scripts...

Thanks For the reply Gail. I will test it before I move it to production.

Thanks for the reply Gail. . Due to non existent data in our test environments, we dont have a valid environment to use this SP. Hence I will have to...