You once you've sourced the file

PS> . ./sqlem.ps1

You should be able to simply run the functions the Powershell script defines:

Export-RegisteredServers c:\servers.txt

or

Import-RegisteredServers c:\servers.txt

That is much simplier than the looping Xquery I used -- Thanks

Another way using xquery if you have multiple Name elements as noted in this blog entry

http://blogs.msdn.com/mrorke/archive/2005/07/21/441554.aspx

SELECT T.ref.value('.', 'varchar(256)') AS Employee

FROM

(

select...

Loner -- Andy's article stated

"Take any management training they do offer. Some of it will be useful, some won't, but it will help you to see what things are important...

As someone who made the leap from DBA to manager I can relate and agree with the advice given. I would add a few more points:

Enroll in an MBA or...

I remember looking at applicaiton roles in SQL 7.0 and the biggest issue I noticed was that application roles cannot do connection pooling. I haven't used them since and instead...

I use a 3rd party tool for both SQL 2000 and 2005 also, Idera SQL Compliance Manager

You're right it doesn't handle column permissions, the code is iterating through by object type and then for each object (table,view, stored procedure, function) executing the ListPermissions method. It looks...

I would say you are new to SMO also to fix your code:

1. You misspelled permission instead of permissions and need to use the Powershell $true builtin variable:

$ScriptOpts.Permissions =...

My experience upgrading from SQL 2005 Standard Edition to Enterprise Edition hasn't been easy. BOL includes instructions which basically details poping in the Enterprise DVD/CD and doing an upgrade unfortunately...

I've used ActiveCrypt for past 7 years without issue in SQL Server 2000. However like Netlib it requires increasing columns length and changing data types to stored the encrypted text....

I haven't seen this issue, however I've seen issues where theobject was renamed and the name does not match the object definition. This could be why you can't find the...

I haven't used SQL Diag but my understanding is that it is perfmon counter based and uses a SQL traces. When looking at these tools there a few very different approches...

I've used the product for the past 4 years and have generally been happy with it.

Things I like

Low overhead monitor with no traces. Uses a sampling methodology equivalent to running...

I haven't used this package, since a couple folks mentioned open source. This one is .NET/SQL Server based:

http://sourceforge.net/projects/healthmonitor/

I would also recommend MS Health and History Checker