Hi Brian,

Can you please suggest or help,

I have sql user he needs to create SSIS packages on production server, I created a SQL login for him and gave DBcreator...

Hi -

Can you suggest (or) do you know what permissions should i need to give to my user - he needs to creat a SSIS package.

Thanks!

Thanks a lot!!!

Thanks for your response, the error message I posted was from the the LOG folder.

Thanks & regards!!

Hey Jeff, Thanks for the help.

Do you have SQL Script to find out when data was last updated/modified in the table?

Thanks.

Jeff, Thanks! Yes it's listing all the names.

Regards.

Yes. I need the table names and associated PK & FK names.

Thanks!

Hi Pradeep, thanks for you response....yea I want to move a bunch of packages from server A to server B, if it were a couple I would copy/move using save as...

Thanks a lot !!!

sp_helparticle @publication = 'publication'  is good enough

Regards!

Thanks for your response, I gave FF 10%, assuming the maintenance plan uses 10% as FF, and yes this table is write intensive, is there a way I can reduce...

This answers my question, thanks everyone -

much appreciated!!!

Thanks Steve for your repsonse, I'm referring to Transactional replication. I know the publisher and subscriber will be in synch, but I just wanted to know if the databases in...

Thanks David -

Damian, thanks a lot for your quick response -

Regards!!!

Hi Shahi kant,

thank you for your quick response, since the structure of the tables is big I sent it thru private message. Please let me know if you didn't receive...