No not while running, the reason is due to rollback possiblity it must have all the data to perform the task.

quote:

---

The Error 53 message is generally returned when name resolution fails for a particular computer name. Error 53 can also occur when...

You cannot use this syntax within a function.

I don't think you can get a table variable to work here either as it requires you define the table structure.

Saw this in another post on DBForums site.

First in QA run

sp_helptext xp_MSADEnabled

you should get

xpstar.dll

back, if not then what do you get back. If so then it could be...

Unfortunately unless you set the default database to the one for the SP and not need to go back then this is your option as it is a limitation with...

Try DBCC UPDATEUSAGE (DB Name)

**** Method 2 updated, try this.

/* insert method */

Declare @Const int, @Cat int

Select @Const = 4

Select @Cat = 2

Insert into

TX_CONST_CUST

(use column list here of only columsn to actually insert,...

You are rigth about the task of deleting using HD space. In fact for every delete there is a row delete marked in the Transaction Log with the data removed...

Profiler and traces are your option for these.

You can only delete which will propagate to the subscriber. Otherwise you will need to drop the publication and rebuild it.

Trying to give you a good solid solution may be simple or complex in what we feel may work best for you. However how many months are kept in the...

Can you post your SP header

CREATE PROCEDURE SPNAME

PARAMS

AS

so I can compare better.

I have tried and cannot duplicate the error. Also, when you don't do the Parameters Refresh it shoudl call...

I think a printed copy would be excellent however I do see issues. First how do you copyright material such as this or do you have an open copyright listed...

When involving child SPs you have to be carefull your logic doesn't have any loopholes in it. I found one once where I was doing IF..BEGIN...END over and over, however...

When the message popsup under debug you should get a button to debug and it point to the line that is an issue? However, did you remember to set the...