Hi,

One more thing to watch out. In the monitoringserver.sql, add in the use tempdb in the beginning of the script.

use tempdb -- add in this

go ...

I finally figure it out.

Somehow, the DTS Transform task won’t auto...

I still getting error invalid object name 'tempdb.dbo.DayDBStat' at the same...

I mean at source tab in the Transform Data Task for DB Stats monitoring with the TSQL:

select * from tempdb.dbo.DayDBStat

I thought you can't query temp table as source in Transform Data task as stated here

When using temporary tables in the Transform Data task, the Data Driven Query task, or...

Background:

I have a PROD server having database replication using a third party product from EMC called Replistor (i think is was a product by Legato previously). It is replicating the...

Greg Charles (10/17/2007)

---

Garrick,

1) If a connection in the package uses Windows Authentication, the connection will be made with the security credentials of the Windows account that runs SQL Server Agent,...

sp_lock showed no lock held by the non-stop process spid. But the backup process just won't go away even with kill command issued.

somehow, i guess it has to do with...

It is backing up 50 databases in that instance. sp_who2 show disk and cpu column figure is static. will check the sp_lock.

The backup job log specified under reporting tab in...

The db i mentioned is 90GB. The biggest table is 60GB and clustered index rebuild on this table alone take 4+ hours.

dbcc dbreindex in SQL2000 need a DB to be...

The fillfactor remain the same for each DBCC DBREINDEX run. We didn’t explicitly specify the fill factor in DBCC DBREINDEX command as it will get the same value every run...

Hi,

I did a index rebuild (DBCC DBREINDEX) last week. The last index rebuild was done a month ago. I realised that the time taken to halfed for a particular index....

Hi,

Thanks for the detailed insight.

First, I wish the WITH STAT for index rebuild will be there in next release of SQL Server, SQL2008/9? I guess SQL2005 still inherit the something...

Hi,

Maybe I didn't put the question clear enough. I will explain here again:

I need to create a wrapping stored procedure around profiler system SPs such as sp_trace_setfilter and etc. I am...

Jonrneyman,

Thanks your for reply.

Yes. sp_helpsrvrolemember will list all the members (logins and NT groups) of sysadmin role.

But, for my case i have different NT domian groups for different group of people...