I mentioned ADO just to make sure everyone understood the context. Let me
rephrase the question, then : How can I log inner working details on an
erratic SP behavior using SQL Server tools ?
I'd suggest you post your question to microsoft.public.sqlserver.programming
as ADO is not exclusively a SQL Server abstraction layer.
Re: How can I get the Management Studio ... According to this Q & A, I'll need another SQL Server license because I'll be using a SQL Server Tool on it? ... "any device that has SQL Server tools or technologies installed must have a valid license" ... It would basically mean we can buy one per processor SQL Server and install SSMS on all the machines in the world? ... (microsoft.public.sqlserver.tools)
Re: How can I get the Management Studio ... a SQL Server server; however, a SQL Server Tool is going to be used on it. ... According to this Q & A, I'll need another SQL Server license because I'll be using a SQL Server Tool on it? ... "any device that has SQL Server tools or technologies installed must have a valid license" ... It would basically mean we can buy one per processor SQL Server and install SSMS on all the machines in the world? ... (microsoft.public.sqlserver.tools)
Re: How can I get the Management Studio ... I'd say that the key word here is "separate".... There's no "SQL Server tools" license you can buy. ... (microsoft.public.sqlserver.tools)
Re: How can I get the Management Studio ... I know there is no such a license SQL Server Tools license =) ... As it says "any device that has SQL Server tools or technologies installed must have a valid license" in the Q & A, I end up with a question mark: "I have a SQL Server server which has SQL Server database engine and tools installed on it and have a license for that particular SQL Server server, however I want to use the SQL Server tool SSMS on another server in my environment, according to that Q & A, I'm using a SQL Server tool on another device other than that licensed SQL Server server and as it says 'you need a valid license for SQL Server tools' do I need any other SQL Server license for the other unlicensed server which I'd like to install only SSMS?"... ... Of course, on a desktop you can install those tools, which include Management Studio, without installing the SQL Server engine. ... (microsoft.public.sqlserver.tools)
Re: How can I get the Management Studio ... I just want to share something weird with you guys on SQL Server Tools' licensing. ... Q. Do I need a separate license to run the SQL Server tools and analysis services? ... Of course, on a desktop you can install those tools, which include Management Studio, without installing the SQL Server engine. ... (microsoft.public.sqlserver.tools)
