Just a quick addition: Another user is able to expand Legacy and see the list of DTS packages but when she tries to open the DTS package, this error...
Hi Experts, One of our users are having problem opening DTS packages. In his machine, SQL 2000 Enterprise Manager and SQL 2005 Management Studio....
Thanks a lot, Satya! That article helps a lot.
So that means, If I have like 50 application users from different databases within the same SQL instance, I would need to grant all of them an...
we have specific users to grant.
Hi Satya, It's kind of odd because out of our 4 SQL Server 2005 instances, only one instance seems to have public execute permission as denied on...
Hi Amit, Thanks, for the reply. We have other SQL2k5 servers, so I tried to replicate the scenario in there and surprisingly, I didn't get the same...
Hi All,I am very new to SQL 2005 and we have just recently upgraded on of our servers from 2000 to 2005. As we are doing application testing, we are...
Thank you for the response. It did work! I hope others will find this useful too. More power to this forum!
Hi, We are still on process of assessing our move from SQL 2000 to SQL 2005. In response, I have set up a test server where SQL 2000 was installed...
Separate names with a comma.