What part of SQL Server 2000/2005 is this T-SQL statement getting data from?
SELECT
SERVERPROPERTY('LicenseType'))
AS LicenseType, CONVERT(char(100),
SERVERPROPERTY('NumLicenses'))
AS NumLicenses, CONVERT(char(100)
When I run this, I get a lot of Disabled too, what can I enable to get the license type from the server?
I would like to be able to get some of the information that is provided through SERVERPROPERTY for a linked server. Is that possible?
For instance I would like to get SERVERPROPERTY('ServerName') to work for a query through a linked server. When I include this in such a query, I get the servername of the local server, not the remote server. I would like to get the servername (or whatever property) of the remote server.
Thanks in advance for your help,
Bob
I manage a hosted environment - several actually. Meaning my company is the host. We provide some of our customers with a dedicated instance of SQL Server that they can use in read-only mode. Unfortunately, I have some very inquisitive customers who probably should be hosting their own SQL. They like to poke into the inner workings of our environment in ways that make me uncomfortable. What I originally found was that they were reading our server registry. I've disabled that. The next thing that bothers me is the amount of information available to them through SERVERPROPERTY. They don't need to know things like physical node of a cluster their instance is on, or the last time we updated SQL, or our licensing choices.
Is there any way to prevent a user from using the SERVERPROPERTY function? I've done a lot of digging and can't seem to find a way to do it.