SQL Configuration
-
Is there a way to determine the SQL Server configuration from vb.net? I would like to be able to determine what the memory allocation is weather its an express or full version and what version it is. Any information on this would be great,
-
Is there a way to determine the SQL Server configuration from vb.net? I would like to be able to determine what the memory allocation is weather its an express or full version and what version it is. Any information on this would be great,
Check this out ... For SQL configuuration data. http://msdn.microsoft.com/en-us/library/ms188754.aspx[^] I belive you want to get the database version to indicate whether it is an express or full version of SQL. Good luck. :thumbsup:
-
Check this out ... For SQL configuuration data. http://msdn.microsoft.com/en-us/library/ms188754.aspx[^] I belive you want to get the database version to indicate whether it is an express or full version of SQL. Good luck. :thumbsup:
Thanks for the reply, I will need to read about that stuff before i can attempt it but its a good starting point thank you
-
Thanks for the reply, I will need to read about that stuff before i can attempt it but its a good starting point thank you
Log in as 'sa' and execute this command:
SELECT
(Physical_memory_in_bytes/1024.0)/1024.0 AS Physical_memory_in_Mb
FROM
sys.dm_os_sys_infoNo special privileges for this command:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Please remember to vote if you find this helpful.
-
Log in as 'sa' and execute this command:
SELECT
(Physical_memory_in_bytes/1024.0)/1024.0 AS Physical_memory_in_Mb
FROM
sys.dm_os_sys_infoNo special privileges for this command:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Please remember to vote if you find this helpful.
Thanks for your help, this has pointed me in the right direction once I develop the complete solution i will post.