We're a small shop (1 dedicated SA, 1 dedicated DBA) but I have local admin rights to all boxes hosting SQL Server. It's helpful when we have to manage disk...

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

To identify the specific task and error message about why the job failed, you need to check the Database Maintenance Plan History. The Database Maintenance Plan History is where you...

Can you post the error message from Job History?

Try...

Since I don't have access to manage domain accounts in our environment, my preference is to use SQL Server Authentication in packages that go against other servers. That way if...

What type of security are you using within the DTS package?

If it's Windows Authentication, then the package is using the account that starts the SQL Agent from the scheduled job.

If running freeproccache gives you a performance boost, you might be experiencing stale query plans. How's your fragmentation?

Hi Ed, unfortunately there were no hardware upgrades just the OS.

There have been no substantial code changes and we've run a thorough reindex/update statistics twice since the upgrade. We've also...

Not nearly as elegant but might serve your purpose.

drop proc test

go

drop table test_table

go

create table dbo.test_table (Serial_No int)

go

insert into dbo.test_table values (1)

insert into dbo.test_table values (3)

insert into dbo.test_table values (5)

insert into...

Do you want to report back the "null" record(s) or just that a null exists somewhere in the table?

There's always a work around!

drop table #tmp

go

Create table #tmp

(

eno varchar(1),

ename varchar(25)

)

go

insert into #tmp

select '1','Karthik'

union

select '2','Keyan'

union

select '3','Mani'

Declare @Column varchar(5)

, @sql varchar(500)

select @Column = 'ename'

set @sql = 'select * from...

You could deny rights on this table to the user/role.

DENY SELECT ON [tblname] TO Public

While KILL works isn't it easier to alter the db to SINGLE_USER WITH ROLLBACK IMMEDIATE than having to potentially hunt down and kill multiple processes?

[Quote]Setting Database Options (http://msdn.microsoft.com/en-us/library/aa933082(SQL.80).aspx)

SINGLE_USER | RESTRICTED_USER...

When you run the DTS manually, are you using a different account than the one that starts the SQL Agent?

The account that starts the SQL Agent is what the job...

I've seen this before using a DTS package that imports data from Excel into a table. It's usually because of...