Thanks to everyone for taking a look at this. Here's the DDL for the table

CREATE TABLE [dbo].[JudicialServicesPersonnelTypes] (

[PersonnelType] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

[Description] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS...

John,

Thanks for responding. It's varchar(50), just like the output variable. I've tried changing both the column and the output variable to char(50), with no luck. I posted...

I have learned so much from the Users Who Need Help posts, I would hate to see it go away. And yes, it has gotten much longer, but isn't...

I thought you just turned 40, so why are you using 1024 x 768 resolution, instead of 800 x 600?:)

Seriously though, changing the resolution to the absolutely unreadable 1024 x...

Is it just my computer, or does the Where Did It Go? section (table?) get cut off on the right for others?

Mattie

I don't want to hijack Steve's question, but it's related to one I've always wondered about:  if you don't have enough time to do all the analysis, design, and testing...

Hi Erik,

Thanks so much for responding.   The answer to your question is yes:  While I cannot access any site using the DTS task, I can access at least one...

I love this site.  Carl, thanks so much for your help.

Mattie

You mean like

http://www.sqlservercentral.com/newsletter/?

Mattie

I was pleasantly surprised to find that this was the case in an application I wrote, but I'm curious why it's a questionable practice.  Is there another way to achieve...

I answered MSOLAP.  I don't mind getting these wrong, but it seems to me in the SQL Server 2005 Service Accounts article in the same newsletter, it indicates that for...

Good idea. I'm out camping for the next few days, but I'll take a look and see if I can get this working.

Mexico, baseball, and now camping?  Can't...

Sugesh,

Yup, we know what the fix needs to be for the future.  But back to my current problem, seeing as the job it's running against isn't an issue, should I kill...

Thank you Sugesh for your response.  Are you saying that instead of killing the SPID, I should just stop and restart the SQL Agent Service?

As for the problem with the...

Steve,

I don't know if this is the kind of example you're looking for, but it seems representative of the issue that's been occurring since the rules for including posts in...