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