We have ActiveX scripts through out all our DTS packages. I am not sure your solution would help in this instance?

In my script below replace P with U this will give you user objects and the P will give you stored procedures.

You can write a script to produce the a script to execute.

Try somehting along the lines of this:

select

   case

      when xtype = 'P' then 'Truncate ['

    end

+ o.name +...

I have applied the hot fix and it corrected my production issues, but I still see SPIDS Blocking themselves.

I never noticed this pre SP4. Should I still keep looking into...

Can you post the hot fixes? I am desperate.

Thanks -jG

I have encountered this same error today, but I do not have over 200 columns I only have 19. I do not know what the root cause can be, I...

Some questions on your article.

If you create a generic SQL ID for the developers, how do you know who changed what.

Now that they all have the same ID. It makes...

 One great Tool!!!

It is an ever changing world!

This last time that is exaclty how it happend to me. I changed my domain password, and they were gone. I would figure it would be part of the profile,...

I appreciate the code. I was looking for a way to do this for a large number of columns. I have over a hundred columns in the table and...

Lingrend,

So the insert is a transaction and the SP notices the open tran and aborts?

Is the work around to edit the sp itself and modify the trancount value?

-JG

Thanks Brian! -jG

-JG

It does perform the copy. And the file size is the same. Something is not being passed becaused I used the coiped bak file and it will not restore properly...

sdining,

One other thing you can do is on the configuration of the database. SQL Server can do mulitprocessing if the data is located accross mulitple filegroups.

If the computer has multiple...