Grant,

Thanks for the advice, I am still working it out. Why wouldn't you set it as high as a OLTP? Sorry if that was too open-ended.

DK

nivek-224024,

Thanks for the quick reply! It was extremely helpful.

DK

I tried to go through the same progression on the server.

Create Role.

Grant Execute to User Defined Data Type, save Role.

Open Role, open Securables.

Same error, ‘Value does not fall within...

Thanks for the reply Lowell,

The version is 9.00.4035.00 on my machine and the version on the server that I am working on is 9.00.4053, which I believe are both SP3....

thanks for the reply Wildcat,

Sorry I should have clarified the build up to the question better. But your last statement may cut to the heart of the issue. If it...

Thanks to all, for the input. I am working towards splitting the publication out into smaller parts, and looking for more throughput on the network.

Thanks again,

DK

David,

Thanks for the response, and I apologize for the piecemeal nature of my forum posts, as I have been tasked with improving the current process but was not involved in...

Jeff, what would you suggest for a small company?

Paul, looks like a 1Gbps card on the Publisher, and 100Mbps card on the Subscriber, and it is a pull subscription.

Thanks to...

It is going from a raid 5 to a raid 5, from box to box. From 32bit (publisher) to 64bit (subscriber).

Thanks again,

DK

Disclaimer preface: I am just starting at a new company so details are unraveling as I dig, but here is the situation as it stands now:

Thanks for the responses, yes...

Wow, thanks for the feedback Elliott and David.

I am not sure about the pre-sizing, how would I go about doing that, or could you suggest a good article?

Found this link:

I just learned the publisher is on a 32bit server and the distributor and subscriber are on a 64bit server. The 32bit server is AWE enabled and using a little...

Thanks for the reply David, that was helpful. I am lining up a test to implement some physical changes.

Thanks,

DK

CozyRoc, all,

I apologize for the delay, and thanks for the help, I ended up using variables and building the connections strings in the package using expressions.

Thanks again,

DK

EncryptSensitiveWithUserKey