Steve,

You are correct, xp_cmdshell runs under the context of the SQLServer service account.  The SQLServer service is set to run under my account, so this does not seem to be...

You may want to try querying the sysjobs table in the msdb database to see if there is an entry there that for some reason is not showing up in...

Thanks for the suggestion.  I ended up tracing through all the calls made by the replication process until I found the root error.  The root error pointed to a missing...

Thanks.  I figured that would be the way but I was hoping there would be a faster, simpler way.  Apparently, so did my predecessor

SQL Server does not have a good builtin encryption process.  There are a number of third party extended procedures available.  I am currently involved in a project to encrypt data...

Thanks David.  Actually, a little more research turned up the answer.  The missing index was for text data (indexid=255)

and I did forget to paste the collation bit! 

update T1

set acctno = t2.accountno

from t2 join t1 on t1.custno = t2.custno

where (t2.office is null or t2.office='') and t1.office is null

A quick google search turned up this solution:

select Ltrim (

        Replace (

        Replace (

        Replace (

        Replace (

        Replace (

        Replace (

        Replace (

        Replace (

        Replace (

        Replace (

        Replace (

       ...

Of course, the real trick is to replace the cursor solution with a set based solution.....not just trading one loop for another!

Thanks, all good suggestions.....Unfortunately, for various application architecture reasons I'm stuck with the procedure running on one machine, inserting data into a database on a linked server.  Luckly, re-querying the...

The state info is not defined by SQLServer.  It is used to return state information to the application.  I assume that its use in standard messages would only have value...

JT,

Thanks for the kudos.  

The process for measuring the timing was quite simple.  I created a script that stored the current date/time in a variable, then executed the stored procedure,...

although I got the question right, I must disagree with the explanation given.  According to the explanation, the isnull function returns the null date of 1/1/1900 and then adds two...

You were close to the answer:

If you run on the first of every month:

select * from table where datapart(m,datecolumn) = datepart(m,getdate() - 1)

will work.  However, it will ONLY work on...