Deleting the User in SQL Server 2000

• pratapgajjala

  Valued Member

  Points: 60

  More actions

  August 30, 2011 at 9:11 pm

  #243117

  Hi

  I am using the Sql Server 2000(Production). I have requirement like i have to delete a some of users. if i delete user, is there any effect on the DTS packages, stored procedures,and Views created by him,? If any effect, what it would be? Can other user open the packages and stored Procedures and modify them even after deleting the user ?

  Thanks in advance...

  Pratap

• muthukkumaran Kaliyamoorthy

  SSCoach

  Points: 19026

  More actions

  August 31, 2011 at 12:06 am

  #1375305

  What will you do if the user login used in connection string?

  Don't delete instead disable it. Write query and check it out where are the logins are used it.

  Muthukkumaran Kaliyamoorthy
  https://www.sqlserverblogforum.com/

• muthukkumaran Kaliyamoorthy

  SSCoach

  Points: 19026

  More actions

  August 31, 2011 at 1:58 am

  #1375336

  In future post your SQL 2000 questions to sql 2000 forum link.

  Muthukkumaran Kaliyamoorthy
  https://www.sqlserverblogforum.com/