No Problem ...

Niyala (12/18/2008)

---

Hi Mark,

I myself am a member of builtin\admin group. Well how does it affect my login if I created one (a separate one xyz) for myself first with admin...

Disabled accounts can always be re-enabled, however it's a little bit more involved to recreate the...

Don't forget that you should also remove the builtin\administrators security group! Otherwise windows admins who...

Hi Niyala,

Not sure about 2008 it could well be the same.

FYI - It's the same process for removing named instances from a server. If your not sure you should...

Hi Niyala,

Within add/remove programs if you choose 'Microsoft SQL Server 2005' and click remove you will be asked what you want to remove... Integration Services, Workstation Components etc etc. ...

GilaMonster (12/16/2008)

---

I'll see if I can get an explanation from someone for the pull back and when it'll be available...

Not sure never tried it... perhaps someone else can answer this for you?

You could always ping the hostname to get the ip address, once you've run Jack's script.

What do you mean?

Yes, it's simple but very effective and should be...

Mike

Have you seen the discussion for this post? It looks like a few people have experienced problems.

http://www.sqlservercentral.com/Forums/Topic402799-619-1.aspx

Might be worthwhile joining that discussion? As the original author of the...

See url below... although it's an application as opposed to actual raw tsql.

http://www.sqlservercentral.com/articles/Administering/dumpsqlpermissions/1314

The application will return the information you require in an excel spreadsheet, although be wary it can take...

I think Bodhilove meant 'CTP' ('Community Technology Preview' )... 🙂

Hi,

Very straight forward! Go to Add\Remove programs and select SQL 2005 Server you will then get the option to remove a solitary instance.

Mark