Check out: SELECT value_in_use FROM sys.configurations
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.
Hi,
I have a sql server 2005 and I wish to find out the following
configurations
from within a program:
a. is the clr enabled feature is on
b. is the remote connection options support named pipes
I would like to know if there is a query/table/registry key which I can
check
Thanks
Re: Connection Problems ...>Program Manager... >> Repository to SQL Server 2000. ... >> confers no rights.... (microsoft.public.sqlserver.olap)
Re: xcopy deployment to sql server DTS package in restricted envir ... Try using Run As with the DTS package.... William Vaughn... This posting is provided "AS IS" with no warranties, and confers no rights.... Hitchhiker's Guide to Visual Studio and SQL Server... (microsoft.public.dotnet.framework.adonet)
Re: Which Method to Create a Database Do I Use? ... when I was working on the team) to get rights management tools integrated... Hitchhiker's Guide to Visual Studio and SQL Server... actually be able to connect to the database.... (microsoft.public.dotnet.framework.adonet)
Re: xcopy deployment to sql server DTS package in restricted envir ... We created an account specific for this application with full rights (as far ... also wondering if I have to digitally sign the .exe or something. ... Hitchhiker's Guide to Visual Studio and SQL Server... When you say I need to grant rights to the group to which I belong, ... (microsoft.public.dotnet.framework.adonet)
Re: Which Method to Create a Database Do I Use? ... To be fair, VS is a "generic" tool designed to front a variety of backend databases, but each of the serious engines have rights management needs as well. ... But the more I think about how connecting to a database is setup and the trouble it's been, the more it just pisses me off. ... Hitchhiker's Guide to Visual Studio and SQL Server... (microsoft.public.dotnet.framework.adonet)
