I would strongly recommend using a source control system for your SQL as well. For most projects the first pull of code takes some work to get it all...

Silverfox, that was exactly my first thought as well, and now an even sillier question, is SQL Agent running?

Is the schedule set correctly, date, time, etc?

CEWII

DECLARE @COUNTER INT

SET @COUNTER = 1

DECLARE @MAT_START INT

DECLARE @MAT_END INT

WHILE @COUNTER < (SELECT MAX(RMAT_ID) FROM ROLLING_MAT)

BEGIN

SET @MAT_START = (SELECT MAT_START FROM ROLLING_MAT WHERE RMAT_ID...

The short answer is no, at least not what it appears you are looking for.

But I have a larger question, based on your question you treat the server as the...

I don't see how this would be different that a report with 2 date parameters and the report query uses a between of those dates.

Am I missing the...

That connection string is nothing but text, it isn't any form of a command. You are connected to SQL, you have to use something like OPENROWSET to use that.

I'm...

I got the impression that it recreated it. One thing I've been thinking about it your server master key, you might be able to regen it and get them...

I tend to agree with the connectivity portion of this while I disagree with the name resolution part.

Once a connection is open the name is never re-resolved for that connection....

That tracks with what I had read before so I agree. IT is also a fairly clear methodology..

CEWII

That is ringing some bells. If I remember correctly the proxy setup can be seen under the sql agent set, I'm guessing that although you HAVE set the account...

What is the error when you attempt to call xp_cmdshell as the SQL user?

CEWII

No, your memory is WOEFULLY inadequate. double your memory and cou count and we can talk.. I can see you having problems with processor, memory, and probably disk...

I don't understand the underlying methodology that you are proposing. Why stage it in the A db just to move it into B. Couldn't you use some kind...

Did you place GO between the definitions?

CEWII

In SQL 2005 you can create a column that is a varbinary(max). your app can then write the entire image into that column. The limit is 2GB per...