Re: delete sql server registration in tsql

(J.Evans.1970@xxxxxxxxx) writes:
Is there any way in tsql to delete a sql server registration? (I know
how to do this from Enterprise Manager).

There are undocumented extended stored procedures to manipulate the
registry. However, starting with SQL 2000 SP4, they were changed to
permit changes only within the tree of the SQL Server instance, if
memory serves.

In any case, I would say that it does not really make sense. Enterprise
Manager is a client, and SQL Server is a server. A server sends data to
its clients on requests. It does not send requests to the clients.

If you want manipulate the registry on remote machines, Windows offers
more direct ways to do this, and that is far better than sneaking around
through SQL Server.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: RMS
    ... Attunity to view an manipulate the data real time from either Windows ... Ok Attunity would certainly let you do that but, as far as I know, so will your existing Easysoft ODBC drivers. ... If you've already got a link to SQL Server why not just manipulate the data directly over the ODBC connection instead of importing it first? ...
    (comp.os.vms)
  • Re: MSDE 2000 help please
    ... Let us know when you run out of ideas trying to point ColdFusion at that ... information available about SQL Server and MSDE in the knowledge base ... Now I cant find the database in my hard drive. ... > register that db so I can manipulate it in my web pages.The documentation ...
    (microsoft.public.sqlserver.server)
  • Re: Processing large files with TextFieldParser
    ... to parse the csv line by line and add to the database. ... Another direction to conquer this, as you are storing in SQL Server, is ... you have to manipulate the CSV flat file into multiple tables, ... incremented the IDENTITY values and seeded the flat files. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: delete sql server registration in tsql
    ... sneaky and manipulate registry on other machines. ... servers where I work - each one is the SQL server for a restaurant. ... from the Enterprise Manager so I don't have to see them. ... There are undocumented extended stored procedures to manipulate the ...
    (comp.databases.ms-sqlserver)
  • Re: How will you use SQL server for unstructured information analy
    ... so is there any software we can use to transform unstructured information ... > represent and manipulate many kinds of data but to use an RDBMS effectively ... > metadata in relational terms. ... > As for what advantage SQL Server would give you - that really depends on ...
    (microsoft.public.sqlserver.server)