http://www.sqlservercentral.com/Forums/Topic697546-146-1.aspx
INSERT INTO msdb.dbo.sysdtspackages
SELECT *
FROM OPENDATASOURCE('SQLNCLI','Data Source=ServerName;Integrated Security=SSPI').msdb.dbo.sysdtspackages
--------------------------------------------------------------------------------
INSERT INTO msdb.dbo.sysdtspackages
SELECT *
FROM OPENDATASOURCE('SQLNCLI','Data Source=ServerName;Integrated Security=SSPI').msdb.dbo.sysdtspackages
--------------------------------------------------------------------------------
No comments:
Post a Comment