June 10, 2011 at 7:03 am
Does a user need specific rights to be able to execute a query that returns all SERVERPROPERTY values?
My challenge is this: I need to ensure for several applications - all SQL Server based - that I am able to connect to the supplied database under the supplied user + password on the supplied server. Therefore I would like to use a query over an always present table, view or whatever. For example: The view syscolumns will always be present in an SQL Server database. But ... querying this table could very well be limited by rights.
Would executing a SERVERPROPERTY query be a useful alternative?
June 10, 2011 at 8:13 am
This was removed by the editor as SPAM
June 10, 2011 at 9:33 am
Did you read my question??
Of course I tried that and that's exactly what I intend to do, among some 20+ other database info items like BuildClrVersion, Collation, CollationID, ComparisonStyle, etc. but that's all totally besides the question.
Let me rephrase it: Is there a user thinkable that isn't allowed to execute the SQL statment below?SELECT @@SERVERNAME
June 13, 2011 at 12:42 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply