InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 17:57:25 GMT20http://www.sqlservercentral.com/Forums/Topic549965-471-1.aspxDROP LOGIN [domainName\userName] is good for both SQL and Windows users, and deletes also related users, for me this simple syntax more usable than your SP.Sun, 03 Jun 2012 10:48:58 GMTgleb.zalthttp://www.sqlservercentral.com/Forums/Topic549965-471-1.aspxThanks for sharing your knowledge. I haven't tried it but it looks like the code won't actually work if the user owns something like a schema, etc.Tue, 21 Feb 2012 19:40:03 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic549965-471-1.aspxThis script generates the script to drop users only for the users who don't own a schema.It would have been better if it can generate like that too. I'll try to edit this script.. and post hereThu, 11 Aug 2011 14:58:58 GMT@SQLFRNDZhttp://www.sqlservercentral.com/Forums/Topic549965-471-1.aspxNice script. I had to add SID matching for my purposes. It's possible that the name in sysusers is different from the login that it points to in syslogins.Fri, 29 Jul 2011 14:51:14 GMTTim Lehnerhttp://www.sqlservercentral.com/Forums/Topic549965-471-1.aspxNo worries. FYI: I just edited my original post as the sp_dropuser is okay. It is just the sp_droplogin that needs to be enclosed. Looks like [ ] works as good as ' '.Fri, 29 Apr 2011 13:26:01 GMTryan.hobbshttp://www.sqlservercentral.com/Forums/Topic549965-471-1.aspxHello Ryan,Thanks for the update. Guess I didn't think of this when I wrote the script as I have not seen anyone using the "." in the login name.Thanks,Rudy[quote][b]ryan.hobbs (4/29/2011)[/b][hr]Rudy,First thanks for posting the sp. The code it generates uses sp_dropuser and that does not work for usernames that contain periods. One of the applications we use creates usernames in the following format: vdb_First.Last[code="xml"]EXEC sp_droplogin vdb_First.Last[/code]results in:[code="xml"]Msg 102, Level 15, State 1, Line 1Incorrect syntax near '.'.[/code]Looks like you need to enclose your output with single quotes:[code="xml"]PRINT 'EXEC sp_dropuser ''['+ @DatabaseUser +']''' [/code]and[code="xml"]PRINT 'EXEC sp_droplogin '''+ @SpecificName +'''' [/code][/quote]Fri, 29 Apr 2011 13:04:48 GMTRudy Panigashttp://www.sqlservercentral.com/Forums/Topic549965-471-1.aspxRudy,First thanks for posting the sp. The code it generates uses sp_dropuser and that does not work for usernames that contain periods. One of the applications we use creates usernames in the following format: vdb_First.Last[code="xml"]EXEC sp_droplogin vdb_First.Last[/code]results in:[code="xml"]Msg 102, Level 15, State 1, Line 1Incorrect syntax near '.'.[/code]Looks like you need to enclose your output like you did with the sp_dropuser:[code="xml"]PRINT 'EXEC sp_droplogin ['+ @SpecificName +']' [/code]Fri, 29 Apr 2011 12:50:19 GMTryan.hobbshttp://www.sqlservercentral.com/Forums/Topic549965-471-1.aspxHello. Please let me know what you think about this code, changes, etc.Thanks,RudyTue, 12 Aug 2008 09:29:50 GMTRudy Panigashttp://www.sqlservercentral.com/Forums/Topic549965-471-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Security/63991/">Remove SQL Logins from All Databases and SQL Server</A>[/B]Sun, 10 Aug 2008 20:50:38 GMTRudy Panigas