muthyala_51 (11/9/2012)

---

Don't you think as million of rows are getting inserted and deleted daily can cause high fragmentation which causes the database size to grow. When rebuilt the fragmented space...

Anyone want to take a stab at this? 😉

So now that we're all on board again 🙂 The OP is asking "why" they are seeing this growth and reclaiming of space...?

"We rebuilt all the indexes on this...

OH GOD I am sorry for that misleading statement (clearly not enough coffee this morning when I wrote that). No, NCI's are not affected by the rebuild of a...

How many rows are in this heavily used table? 4% fragmentation really shouldn't be a big deal unless you've got millions of rows in the table and are adding/removing...

Yes it is supposed to be []

INSERT INTO [NAS2-RPS].CORELIBRARY_ARCHIVE.dbo.MessengerLog (SequenceNumber, MessengerPrimaryKey, MessengerTableName, MessengerOperationType)

SELECT SequenceNumber, MessengerPrimaryKey, MessengerTableName, MessengerOperationType

FROM CORELIBRARY_STAGING.dbo.MessengerLog

So why is it possible that I can compile a procedure on Server A with a 4-part naming with no issues

But on Server B, I get that error?

@opc.three - tried that. Again I can execute it but the code won't compile. Executes successfully, gives the above error when hitting the parse or compile buttons.

@matt-2. ...

Make sure that your proxy account has access to the location that you are attempting to delete the files. When you use xp_ functions, it uses the proxy account...

I think you should add in the query_plan field from the dm_exec_query_plan DMV so you have a clickable link that will open up the actual execution plan for each top...

Whoooooops! :w00t: When I test it with a temp table I used a bit...

How many steps are in your job?

No sweat, let me know and good luck!

The easiest way i can think of is to use the RAISERROR - Try something like this:

DECLARE @Result bit

SET @Result = (

SELECT DISTINCT

fileexists

FROM fileNotify

WHERE fileexists = 'false'

)

IF (@Result =...

@Lowell +1

(makes sense considering it used to work, but recently stopped)