opc.three (6/30/2011)

---

It looks like you asked the same...

I think his problem runs far deeper than that.. If he changes more than one row there is no way to tell which one will be logged. and...

sturner (6/30/2011)

---

Is this a 32 bit COM object trying to be run on a 64 bit server? For that matter, have you you compiled your .net assembly for 64 bit...

A little paranoia goes a long way, my point being don't assume everything will go well when you make a change, think about changes and their positive and negative consequences....

I would absolutely waive off on linked servers. What is the second server used for? Maybe log-shipping?

CEWII

The variable in the sproc is not as important, the variable in the PACKAGE is important, you have to have a place to PUT the value, the SET command will...

Have you tried a ROLLBACK in the trigger? From the docs it looks like you could. Also drops can be handled the same way, but you might also...

So assuming the variable is a package variable with the name OrderId.

ALTER procedure [dbo].[ZipCountOrderID]

@OrderID_In int

as

declare @OrderID int

select @orderid = @orderid_in

declare @cmd varchar(255)

SELECT @cmd = 'dtexec /sql zipcodeexport /SET "\Package.Variables[User::OrderId].Properties[Value]";' +...

So basically we are to a login failed?

That is usually a bad password. No here is the big question, how is the server configured for login auditing, you can...

You would have to have a variable in the package that can use the value and then you can modify the the command that executes the package to set the...

Wow, that is quite a set of questions.

And an entire design job.

First using sa at ALL is a bad idea. I recommend switching to using windows logins for your...

Sorry I couldn't help more but there are a fair number of restrictions tied to using SQLCLR..

CEWII

I'm thinking this is not possible:

http://social.msdn.microsoft.com/forums/en-US/sqlnetfx/thread/eaa2a257-e994-452b-855e-7d6841b15d42/%5B/url%5D

And you can look at this:

http://www.sqlservercentral.com/Forums/Topic208912-246-1.aspx

CEWII

How many subplans are in our maintenance plan? Do you have explicit databases selected in each of the subplans? How about the setting that says basically ignore it...

Is the output sorted when you tell it that it is? I've seen people set that flag when it wasn't really sorted. Also what is the datatype of...