InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 09:53:28 GMT20http://www.sqlservercentral.com/Forums/Topic978497-1631-1.aspxchetanr.jain - have tested on sql 2005 through 2008. can you be more specific on the error?SQL_Quest-825434 - no reason, i'm sure temp tables will do equally well.Wed, 01 Sep 2010 08:24:45 GMTr5d4http://www.sqlservercentral.com/Forums/Topic978497-1631-1.aspxIs there any reason of using Variables and not using Temp tables ?Wed, 01 Sep 2010 07:21:04 GMTSQLQuest29http://www.sqlservercentral.com/Forums/Topic978497-1631-1.aspxThank you. This will be useful.Wed, 01 Sep 2010 07:12:33 GMTRML51http://www.sqlservercentral.com/Forums/Topic978497-1631-1.aspxthis helped me a lot and xp_logininfo helped me even more on multiple servers(SQL 2k8)Wed, 01 Sep 2010 04:12:16 GMTBudaClihttp://www.sqlservercentral.com/Forums/Topic978497-1631-1.aspxtried to Executed the script but got the below error :Msg 102, Level 15, State 1, Line 13Incorrect syntax near 'int'.---- Does i am missing something..Wed, 01 Sep 2010 01:25:10 GMTchetanr.jainhttp://www.sqlservercentral.com/Forums/Topic978497-1631-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Security/71069/">Windows Group Membership Checker</A>[/B]Tue, 31 Aug 2010 23:41:37 GMTr5d4