InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 02:12:27 GMT20http://www.sqlservercentral.com/Forums/Topic457263-106-1.aspxIt could be done in VBScript or Perl. Here's an old Perl script. I can't find old VBScript:[code="vb"]#Perl Script based on #http://www.sqlservercentral.com/scripts/contributions/1467.aspuse strict;use Getopt::Std;use Win32::OLE;use Win32::OLE::Const("Microsoft SQLDMO");my (%args, $args, $serverfile, $groupname, $servername, $ServerGroup, $cnt);my $err = 0;my $SQLServer = new Win32::OLE 'SQLDMO.SQLServer';my $Application = $SQLServer-&gt;{Application};getopts('f:', \%args);$serverfile = $args{f};$cnt = 0;open SERVERFILE, $serverfile or die "Cannot open file: $serverfile";while (&lt;SERVERFILE&gt;){ print "Processing $_"; s/#.*//; # remove comments, ignore blank lines if (!$_) {next;} tr/\t / /s; $cnt++; ($groupname, $servername) = split; $ServerGroup = new Win32::OLE 'SQLDMO.ServerGroup'; $ServerGroup = CreateGroup($groupname); RegisterServer($ServerGroup, $servername); $ServerGroup = undef; $servername = undef;}close SERVERFILE;exit $err;sub CreateGroup{ my $ServerGroup = new Win32::OLE 'SQLDMO.ServerGroup'; $ServerGroup-&gt;{Name} = $groupname; $Application-&gt;ServerGroups-&gt;Add($ServerGroup); $ServerGroup = undef; $ServerGroup = $Application-&gt;ServerGroups-&gt;Item($groupname); return $ServerGroup;}sub RegisterServer{ my $RegisteredServer = new Win32::OLE 'SQLDMO.RegisteredServer'; $RegisteredServer-&gt;{Name} = $servername; $RegisteredServer-&gt;{UseTrustedConnection} = 1; $RegisteredServer-&gt;{PersistFlags} = 1; $ServerGroup-&gt;RegisteredServers-&gt;Add($RegisteredServer); $RegisteredServer = undef;}[/code]Wed, 28 Sep 2011 09:47:34 GMTcmille19http://www.sqlservercentral.com/Forums/Topic457263-106-1.aspxDoes anyone know if its possible to do this without ps as I'm not allowed to run any ps scripts in my environment.Wed, 28 Sep 2011 05:56:08 GMTAndrew LAckenbyhttp://www.sqlservercentral.com/Forums/Topic457263-106-1.aspxI noticed the same thing, I'll follow up with the site owners, as it appears be a problem with their script editor. I'm able to reproduce an issue where multiple "?" characters appear when copying the code. It doesn't seem to matter whether I manually create the code with their editor or copy it from notepad. Perhaps it doesn't like some of the special characters (#, %, ?) used in Powershell.Fri, 25 Apr 2008 06:48:11 GMTcmille19http://www.sqlservercentral.com/Forums/Topic457263-106-1.aspxIt seems that the article had some unprintable characters that PS didn't like. I put the code into an editor I have that shows control codes and found them. Removed them and it all works like a charm! :) ThanksFri, 25 Apr 2008 05:55:41 GMTMG-148046http://www.sqlservercentral.com/Forums/Topic457263-106-1.aspxPlease post the contents of your sqlem.ps1 fileThu, 24 Apr 2008 20:07:16 GMTcmille19http://www.sqlservercentral.com/Forums/Topic457263-106-1.aspxDoesn't work for me and I set execution to unrestricted. see attachmentThu, 24 Apr 2008 12:51:11 GMTMG-148046http://www.sqlservercentral.com/Forums/Topic457263-106-1.aspxYou once you've sourced the filePS&gt; . ./sqlem.ps1You should be able to simply run the functions the Powershell script defines:Export-RegisteredServers c:\servers.txtorImport-RegisteredServers c:\servers.txtThu, 24 Apr 2008 12:40:49 GMTcmille19http://www.sqlservercentral.com/Forums/Topic457263-106-1.aspxI'm a newbie with PS. I get as far as sourcing the script but have no idea of what to do next.Thu, 24 Apr 2008 11:05:44 GMTMG-148046http://www.sqlservercentral.com/Forums/Topic457263-106-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/powershell/62275/">Import/Export SQL Server 2000 Enterprise Manager Registered Servers</A>[/B]Tue, 19 Feb 2008 02:30:54 GMTcmille19