April 21, 2011 at 3:30 pm
One of the unscheduled DTS packages in my SQL 2000 instance has a password lock on it and I don't know the password. IS there a way to unlock the package.
FYI,This package has not been scheduled .
Thx in advance.
April 26, 2011 at 4:49 am
I don't think there is a direct command to open it in that case. You might need to take help of some external tools like --> http://dts-documentation-generator-for-sql-server-2000.soft32.com/free-download
Although I haven't used it before.
Manu
May 5, 2011 at 11:07 am
Check out the following article:
http://sql-server-performance.com/Community/forums/t/19114.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 5, 2011 at 1:58 pm
thx guys for the replies,the password was not the SA or the password of the creator of the package . Luckily I was able to track down a doc which was left by the developer to open up the package.
May 5, 2011 at 2:16 pm
You may want to encourage implementation of Source Control in your shop if it does not already exist in a structure that makes it easier for someone to locate source code, documentation, etc.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply