Everybody inherits rights via the guest account. Guest has been explicitly assigned access to the msdb database and made a member of the Public role which is why they have...

Nothing jumps out at me. Try watching your flow and put a MsgBox in a script between each step so you can look at what step the file is deleted.

I have not seen a good review yet that wasn't biased based on featureset statements and never one that used any tools to compare performance.

The only thing I do suggest...

Again he stated if there is "no row" he wants a 0. Appologize but this will not work.

Here is the response I was sent.

I did shut it down.  It was becoming dated and it was costing me money.  I didn't even think it was being...

Do those columns also contain text other than numeric or is the originating table definition something other than numeric. If either is the case it will define the column as...

Your best bet is to put the SP in each DB and tell them to reference and execute by running this way

dbname.dbo.SPName

The other way is dynamic SQL and you end...

I guess it really depends on the context of how you intend to use it in order to best answer your question.

Got to thinking even more about how NOLOCK reacts to things in the system. How big is your Transaction Log currently and when was the last time you did a...

Even so the log would never have become this type of issue and I would feel safe to assume if Full or Bul Recovery. If they are in simple then...

yes the database will go offline, and I wouldn't do it that way because if you attach it will upgrade to SQL 2000 on the new server and you may...

Please, let us know what your results is.

It depends on the facotrs of what you need to move. If just the data and is large most common is take a backup and restore to the new server....

Actually you are pivoting on Sequence Number with the output being consolidated into each Item Number.

OK, what you are looking for is simply like this.

SELECT

 ItemNumber as Record_Number,

 NullIf(Max((CASE WHEN sequenceNumber = 1 THEN Field1 else '' END)),'') AS Field11,

 NullIf(Max((CASE WHEN sequenceNumber = 1 THEN Field2 else...