Funny you mention that.  When I was typing my response, I initially started with 'Outside of removing your hard disks and shipping them ....' but then I figured...nah.  I guess...

Has there been any software/stored proc/trigger changes made?  If so, search your trace for these new items and see how they are impacting your server.  If not, continue on below.....

You...

Use the ExecuteSQL task to execute the stored procedure.  Use a rowset output parameter to store the result set in a global variable.  Upon success of the ExecuteSQL task, run...

No backup = No recovery.   Sorry.

What kind of spacing issues are you referring to?  You should be able to execute a DTS package by using master..xp_cmdshell 'DTSRUN /~Z0x39210848502ADD5...etc'.  If you need to be able to...

"How can I tackle this programmatically without manually adjusting the sproc every quarter???"

I would create your stored procedure so that it accepts the existing plan_version and new plan_version as a...

Go into the DTS designer and select Package>>Save As...  When the 'Save DTS Package' window appears, click on the 'Location' drop down list and select 'Visual Basic File'.  This will...

This should work for you but you will definately need to run this through and look at the execution plan. 

UPDATE Ins

SET ToSynch = 0

FROM tbl_NSP_Inspection Ins

    INNER JOIN (

               ...

Your assumption is correct.  When looking at using file groups to spread your I/O out, you need to look at the physical disks.  Spreading I/O over multiple physical disks allows...

Koln,

You say that AccountNo is your Primary Key?  Do you have a Primary Key constraint created on that column or are you attempting to enforce uniqueness through your application/front-end? ...

With that few number of duplicates, I would recommend the following apprach (in pseudo code):

1. Create @table or #table temporary storage table to mimic the Contact2 table schema.

2. INSERT into...

Thanks Remi.

Yes, you are correct.  The ID2 column must not have any gaps for this one to work and ID2 must be numeric.  Thanks for pointing that out.  I guess...

Here's another way if you have a static numbers table.  If you don't, this may be a good time to create one!

DECLARE @table TABLE (ID1 int,ID2 int)

INSERT INTO @table

SELECT 85678,...

James is correct, there are many different approaches to doing this.  How large is your table?  How many dupilcates to exect to DELETE?  Is there a Primary Key or unique...

This is a duplicate post.  Please continue thread here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=336989&post=true