How to move the Sysssislog table in SQL Server 2008 R2?
How do you move the location of the Sysssislog table per the recommendation of the SQL Server 2008 R2 BPA, which points you to http://support.microsoft.com/kb/2027706? I really did try to find the answer on my own but no luck... Thanks, -Lance
July 8th, 2011 6:43pm

That table is pointed at using a Connection Manager. Simply change the server & database that that Connection Manager is pointing to.http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me
Free Windows Admin Tool Kit Click here and download it now
July 9th, 2011 4:04am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics