The only time I have seen anything like this was in .NET 1.1 apps on PC's running McAfee. The McAfee Buffer OVerflow Protection was causing it. I thought...

The ANSI_PADDING SETTING is set at the connection level and by default SSMS and .NET connections set ANSI_PADDINGS to TRUE, so...

Depends on what you need it for. SQL 2005 has an xml datatype and you could create a temporary table or table variable to put your results in with...

What are the settings on the Security Tab of the linked server properties? Perhaps your login does not have rights on the AS400?

After a quick glance it looks like Carl's solution is very similar in idea to mine.

Sorry but the HTML is not visible. It's one of the nagging issues with the forum.

I'm not real proficient with HTML, but couldn't you do something like this on...

You can use Profiler to script a trace that you can apply to the server as a server-side trace. You can add SP:completed, TQL:BatchCompleted, TSQL:StatementCompleted events and filter on...

I think this code could/should put you an a better path:

[font="Courier New"]DECLARE @punches TABLE (id INT, in_date VARCHAR(10), in_time VARCHAR(5), out_time VARCHAR(5))

DECLARE @hours TABLE(hour_start DATETIME, hour_end DATETIME)

DECLARE @nums TABLE (n...

Could you stick a variable in the package that you read from a configuration file that sets where you are running the package and pick the location based on that...

What are the jobs doing?

You need to look at this article: http://www.sqlservercentral.com/articles/T-SQL/62159/

In SSRS the background color is either set or not set, so you can't partially fill a cell. You might be able to do something with a chart, which...

This is how I'd do it:

[font="Courier New"]CREATE PROCEDURE [dbo].[sp_CheckAndUpdateWinner]

    @Time smalldatetime,

    @Date smalldatetime,

    @ContestantKey INT,

    @randomWinningmomentKey INT output    

AS

DECLARE @TheKey INT

SELECT TOP 1

    @TheKey = RandomWinningMomentKey

FROM

    RandomWinningMoments WITH(updlock)

WHERE

    HasBeenWon = 0 AND

    Drawingdate = @Date...

I really want to help but I can't unless you answer these questions:

• What are the table structures? Is this even close:

users (userid, username, agencyname, sponsorname)

agencies(agencyname, sponsorname)

sponsors(sponsorname)