I left the office last night being half way done writing a script to create a database with some data in it for you all to look at. I came...

I work at a 911 center. Our data is sensitive and proprietary. I also have a contract with our software vendor to not disclose any information about their software. With...

Well I apologize as I am not very good at explaining this. We have a computer aided dispatch system with a sql database that stores information about 911 calls. Such...

I looked at the sysjobsteps table and there are 5 records. Two of those are for tlog backups for the two log shipped databases. One is the Log shipping alert....

I am not familiar with Netbackup. I assume if it's installed on the server it would have a service. I looked at the services and I don't see anything that...

Case worked. Here's the code.

select shift = case

when datepart (hh,calltime) >= 7 and datepart (hh,calltime) < 15 then 'First'

when datepart (hh,calltime) >= 15 and datepart (hh,calltime) < 23 then...

I went ahead and performed the modifications per the KB and it worked. We are now on SP1.

Thanks,

Bill

Yes this does sound similar to the problem. I downloaded the KB and read through it. I want to confirm the names mapping to the groups.

FTSGroup = MSFTEUser

AGTGroup =...

Yep,

Time: 04/06/2011 08:55:18.574

KB Number: KB921896

Machine: SAFETY129

OS Version: Microsoft Windows Server 2003 family, Standard Edition Service Pack 2 (Build 3790)

Package Language: 1033 (ENU)

Package Platform: x86

Package SP Level: 2

Package Version: 3042

Command-line parameters...

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790:...

I should have proof read that last post before I sent it. EACKKKKKKK

I beleive I have the Execute SQL task configured properly (I don't get any errors when I run it separately) but I am not sure about the for eack loop...