Does anyone know why, when I install SQL Server 2005 Developer (September
CTP) and select Default Instance during setup that I see the following in the
SQL Server 2005 Services area of SQL Server Configuration Manager.
SQL Server Agent (MSSQLSERVER)
SQL Server (MSSQLSERVER)
SQL Server Analysis Server (MSSQLSERVER)
SQL Server Reporting Services (MSSQLSERVER)
The physical box name is DEVDW but it seems the default instance is named
MSSQLServer which I definitely did not specifiy...I'm very confused.That is the service name, and it hasn't changes since version 6.0.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:01D3B95C-611D-4EC3-BF67-C5D8D5C46A75@.microsoft.com...
> Does anyone know why, when I install SQL Server 2005 Developer (September
> CTP) and select Default Instance during setup that I see the following in the
> SQL Server 2005 Services area of SQL Server Configuration Manager.
> SQL Server Agent (MSSQLSERVER)
> SQL Server (MSSQLSERVER)
> SQL Server Analysis Server (MSSQLSERVER)
> SQL Server Reporting Services (MSSQLSERVER)
> The physical box name is DEVDW but it seems the default instance is named
> MSSQLServer which I definitely did not specifiy...I'm very confused.
>|||So you're saying that SQL Server Agent, SQL Server Analysis Services and SQL
Server Reporting Services are all running under the MSSQLServer Service...I
don't think so. This is the "name" of the instance and I'm not sure why.
"Scott" wrote:
> Does anyone know why, when I install SQL Server 2005 Developer (September
> CTP) and select Default Instance during setup that I see the following in the
> SQL Server 2005 Services area of SQL Server Configuration Manager.
> SQL Server Agent (MSSQLSERVER)
> SQL Server (MSSQLSERVER)
> SQL Server Analysis Server (MSSQLSERVER)
> SQL Server Reporting Services (MSSQLSERVER)
> The physical box name is DEVDW but it seems the default instance is named
> MSSQLServer which I definitely did not specifiy...I'm very confused.
>|||"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:4403E7F6-9F4C-4B51-B0D0-9B950725D36E@.microsoft.com...
> So you're saying that SQL Server Agent, SQL Server Analysis Services and
> SQL
> Server Reporting Services are all running under the MSSQLServer
> Service...I
> don't think so. This is the "name" of the instance and I'm not sure why.
>
This is the "name" of the default instance. If you installed a named
instance of SQL Server you would see the instance name instead. It's really
just there so you can identify all the services related to that instance.
David
Showing posts with label ctp. Show all posts
Showing posts with label ctp. Show all posts
Thursday, March 29, 2012
Friday, February 24, 2012
Debugging stored procedure inside SSMSE !!!
Hi for all
i just get the news that the Dec. CTP of SQL Server 2005 & tools is released !
but my dream is to see debugging stored procedure support inside the SSMSE as debugging applications inside Visual Studio 2005
Many many many thanks to Microsoft 
and for the great efforts on the cool products
Mohamed
hi Mohamed,
personally I'd like to see the debugging interface in SSMS(E) too, but I do think Microsoft will stick with Visual Studio for this...
but we can throw the coin and hope St. Claus will hear us for next Xmas 
regards
|||thanks for your reply
But I think and agree with you that this is th e Microsoft vision to its family of product
But really really , I as a starting developer , I see that Microsoft works hard to make us - developers - Work Smart
thanks
Sunday, February 19, 2012
Debugging in SQL2005
Hi,
How can you debug a stored procedure in SQL2005? I cannot find anything in
BOL (Sept CTP).
Thanks
Chris Wood
Chris,
Please see:
http://www.aspfaq.com/sql2005/show.asp?id=1
HTH
Jerry
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:%23UZcW$L1FHA.1040@.TK2MSFTNGP14.phx.gbl...
> Hi,
> How can you debug a stored procedure in SQL2005? I cannot find anything in
> BOL (Sept CTP).
> Thanks
> Chris Wood
>
|||Chris,
If you have installed only SQL Server 2005 you will find limited
information in BOL if you search on "debugging stored procedures".
If you have Visual Studio 2005 also installed on the machine the same
search in the document explorer which combines MSDN and BOL for search
will give you more information that is relevant.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
<anonymous@.discussions.microsoft.com> wrote:
>Hi,
>How can you debug a stored procedure in SQL2005? I cannot find anything in
>BOL (Sept CTP).
>Thanks
>Chris Wood
|||We do not have VS2005 on the server.
Thanks
Chris
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
news:hmpcl1psevgsvjtl5p5401fnmr0a98rqgk@.4ax.com...
> Chris,
> If you have installed only SQL Server 2005 you will find limited
> information in BOL if you search on "debugging stored procedures".
> If you have Visual Studio 2005 also installed on the machine the same
> search in the document explorer which combines MSDN and BOL for search
> will give you more information that is relevant.
> Andrew Watt
> MVP - InfoPath
> On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
> <anonymous@.discussions.microsoft.com> wrote:
>
|||MSDN subscribers can, I believe, download the VS2005 Release Candidate
which includes the additional documentation I mentioned.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 09:44:05 -0600, "Chris Wood"
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>We do not have VS2005 on the server.
>Thanks
>Chris
>"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
>news:hmpcl1psevgsvjtl5p5401fnmr0a98rqgk@.4ax.com.. .
How can you debug a stored procedure in SQL2005? I cannot find anything in
BOL (Sept CTP).
Thanks
Chris Wood
Chris,
Please see:
http://www.aspfaq.com/sql2005/show.asp?id=1
HTH
Jerry
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:%23UZcW$L1FHA.1040@.TK2MSFTNGP14.phx.gbl...
> Hi,
> How can you debug a stored procedure in SQL2005? I cannot find anything in
> BOL (Sept CTP).
> Thanks
> Chris Wood
>
|||Chris,
If you have installed only SQL Server 2005 you will find limited
information in BOL if you search on "debugging stored procedures".
If you have Visual Studio 2005 also installed on the machine the same
search in the document explorer which combines MSDN and BOL for search
will give you more information that is relevant.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
<anonymous@.discussions.microsoft.com> wrote:
>Hi,
>How can you debug a stored procedure in SQL2005? I cannot find anything in
>BOL (Sept CTP).
>Thanks
>Chris Wood
|||We do not have VS2005 on the server.
Thanks
Chris
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
news:hmpcl1psevgsvjtl5p5401fnmr0a98rqgk@.4ax.com...
> Chris,
> If you have installed only SQL Server 2005 you will find limited
> information in BOL if you search on "debugging stored procedures".
> If you have Visual Studio 2005 also installed on the machine the same
> search in the document explorer which combines MSDN and BOL for search
> will give you more information that is relevant.
> Andrew Watt
> MVP - InfoPath
> On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
> <anonymous@.discussions.microsoft.com> wrote:
>
|||MSDN subscribers can, I believe, download the VS2005 Release Candidate
which includes the additional documentation I mentioned.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 09:44:05 -0600, "Chris Wood"
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>We do not have VS2005 on the server.
>Thanks
>Chris
>"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
>news:hmpcl1psevgsvjtl5p5401fnmr0a98rqgk@.4ax.com.. .
Debugging in SQL2005
Hi,
How can you debug a stored procedure in SQL2005? I cannot find anything in
BOL (Sept CTP).
Thanks
Chris Wood
Chris,
Please see:
http://www.aspfaq.com/sql2005/show.asp?id=1
HTH
Jerry
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:%23UZcW$L1FHA.1040@.TK2MSFTNGP14.phx.gbl...
> Hi,
> How can you debug a stored procedure in SQL2005? I cannot find anything in
> BOL (Sept CTP).
> Thanks
> Chris Wood
>
|||Chris,
If you have installed only SQL Server 2005 you will find limited
information in BOL if you search on "debugging stored procedures".
If you have Visual Studio 2005 also installed on the machine the same
search in the document explorer which combines MSDN and BOL for search
will give you more information that is relevant.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
<anonymous@.discussions.microsoft.com> wrote:
>Hi,
>How can you debug a stored procedure in SQL2005? I cannot find anything in
>BOL (Sept CTP).
>Thanks
>Chris Wood
|||We do not have VS2005 on the server.
Thanks
Chris
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
news:hmpcl1psevgsvjtl5p5401fnmr0a98rqgk@.4ax.com...
> Chris,
> If you have installed only SQL Server 2005 you will find limited
> information in BOL if you search on "debugging stored procedures".
> If you have Visual Studio 2005 also installed on the machine the same
> search in the document explorer which combines MSDN and BOL for search
> will give you more information that is relevant.
> Andrew Watt
> MVP - InfoPath
> On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
> <anonymous@.discussions.microsoft.com> wrote:
>
|||MSDN subscribers can, I believe, download the VS2005 Release Candidate
which includes the additional documentation I mentioned.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 09:44:05 -0600, "Chris Wood"
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>We do not have VS2005 on the server.
>Thanks
>Chris
>"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
>news:hmpcl1psevgsvjtl5p5401fnmr0a98rqgk@.4ax.com.. .
How can you debug a stored procedure in SQL2005? I cannot find anything in
BOL (Sept CTP).
Thanks
Chris Wood
Chris,
Please see:
http://www.aspfaq.com/sql2005/show.asp?id=1
HTH
Jerry
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:%23UZcW$L1FHA.1040@.TK2MSFTNGP14.phx.gbl...
> Hi,
> How can you debug a stored procedure in SQL2005? I cannot find anything in
> BOL (Sept CTP).
> Thanks
> Chris Wood
>
|||Chris,
If you have installed only SQL Server 2005 you will find limited
information in BOL if you search on "debugging stored procedures".
If you have Visual Studio 2005 also installed on the machine the same
search in the document explorer which combines MSDN and BOL for search
will give you more information that is relevant.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
<anonymous@.discussions.microsoft.com> wrote:
>Hi,
>How can you debug a stored procedure in SQL2005? I cannot find anything in
>BOL (Sept CTP).
>Thanks
>Chris Wood
|||We do not have VS2005 on the server.
Thanks
Chris
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
news:hmpcl1psevgsvjtl5p5401fnmr0a98rqgk@.4ax.com...
> Chris,
> If you have installed only SQL Server 2005 you will find limited
> information in BOL if you search on "debugging stored procedures".
> If you have Visual Studio 2005 also installed on the machine the same
> search in the document explorer which combines MSDN and BOL for search
> will give you more information that is relevant.
> Andrew Watt
> MVP - InfoPath
> On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
> <anonymous@.discussions.microsoft.com> wrote:
>
|||MSDN subscribers can, I believe, download the VS2005 Release Candidate
which includes the additional documentation I mentioned.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 09:44:05 -0600, "Chris Wood"
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>We do not have VS2005 on the server.
>Thanks
>Chris
>"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
>news:hmpcl1psevgsvjtl5p5401fnmr0a98rqgk@.4ax.com.. .
Debugging in SQL2005
Hi,
How can you debug a stored procedure in SQL2005? I cannot find anything in
BOL (Sept CTP).
Thanks
Chris WoodChris,
Please see:
http://www.aspfaq.com/sql2005/show.asp?id=1
HTH
Jerry
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:%23UZcW$L1FHA.1040@.TK2MSFTNGP14.phx.gbl...
> Hi,
> How can you debug a stored procedure in SQL2005? I cannot find anything in
> BOL (Sept CTP).
> Thanks
> Chris Wood
>|||Chris,
If you have installed only SQL Server 2005 you will find limited
information in BOL if you search on "debugging stored procedures".
If you have Visual Studio 2005 also installed on the machine the same
search in the document explorer which combines MSDN and BOL for search
will give you more information that is relevant.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
<anonymous@.discussions.microsoft.com> wrote:
>Hi,
>How can you debug a stored procedure in SQL2005? I cannot find anything in
>BOL (Sept CTP).
>Thanks
>Chris Wood|||We do not have VS2005 on the server.
Thanks
Chris
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
news:hmpcl1psevgsvjtl5p5401fnmr0a98rqgk@.4ax.com...
> Chris,
> If you have installed only SQL Server 2005 you will find limited
> information in BOL if you search on "debugging stored procedures".
> If you have Visual Studio 2005 also installed on the machine the same
> search in the document explorer which combines MSDN and BOL for search
> will give you more information that is relevant.
> Andrew Watt
> MVP - InfoPath
> On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
> <anonymous@.discussions.microsoft.com> wrote:
>>Hi,
>>How can you debug a stored procedure in SQL2005? I cannot find anything in
>>BOL (Sept CTP).
>>Thanks
>>Chris Wood
>|||MSDN subscribers can, I believe, download the VS2005 Release Candidate
which includes the additional documentation I mentioned.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 09:44:05 -0600, "Chris Wood"
<anonymous@.discussions.microsoft.com> wrote:
>We do not have VS2005 on the server.
>Thanks
>Chris
>"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
>news:hmpcl1psevgsvjtl5p5401fnmr0a98rqgk@.4ax.com...
>> Chris,
>> If you have installed only SQL Server 2005 you will find limited
>> information in BOL if you search on "debugging stored procedures".
>> If you have Visual Studio 2005 also installed on the machine the same
>> search in the document explorer which combines MSDN and BOL for search
>> will give you more information that is relevant.
>> Andrew Watt
>> MVP - InfoPath
>> On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
>> <anonymous@.discussions.microsoft.com> wrote:
>>Hi,
>>How can you debug a stored procedure in SQL2005? I cannot find anything in
>>BOL (Sept CTP).
>>Thanks
>>Chris Wood
How can you debug a stored procedure in SQL2005? I cannot find anything in
BOL (Sept CTP).
Thanks
Chris WoodChris,
Please see:
http://www.aspfaq.com/sql2005/show.asp?id=1
HTH
Jerry
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:%23UZcW$L1FHA.1040@.TK2MSFTNGP14.phx.gbl...
> Hi,
> How can you debug a stored procedure in SQL2005? I cannot find anything in
> BOL (Sept CTP).
> Thanks
> Chris Wood
>|||Chris,
If you have installed only SQL Server 2005 you will find limited
information in BOL if you search on "debugging stored procedures".
If you have Visual Studio 2005 also installed on the machine the same
search in the document explorer which combines MSDN and BOL for search
will give you more information that is relevant.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
<anonymous@.discussions.microsoft.com> wrote:
>Hi,
>How can you debug a stored procedure in SQL2005? I cannot find anything in
>BOL (Sept CTP).
>Thanks
>Chris Wood|||We do not have VS2005 on the server.
Thanks
Chris
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
news:hmpcl1psevgsvjtl5p5401fnmr0a98rqgk@.4ax.com...
> Chris,
> If you have installed only SQL Server 2005 you will find limited
> information in BOL if you search on "debugging stored procedures".
> If you have Visual Studio 2005 also installed on the machine the same
> search in the document explorer which combines MSDN and BOL for search
> will give you more information that is relevant.
> Andrew Watt
> MVP - InfoPath
> On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
> <anonymous@.discussions.microsoft.com> wrote:
>>Hi,
>>How can you debug a stored procedure in SQL2005? I cannot find anything in
>>BOL (Sept CTP).
>>Thanks
>>Chris Wood
>|||MSDN subscribers can, I believe, download the VS2005 Release Candidate
which includes the additional documentation I mentioned.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 09:44:05 -0600, "Chris Wood"
<anonymous@.discussions.microsoft.com> wrote:
>We do not have VS2005 on the server.
>Thanks
>Chris
>"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
>news:hmpcl1psevgsvjtl5p5401fnmr0a98rqgk@.4ax.com...
>> Chris,
>> If you have installed only SQL Server 2005 you will find limited
>> information in BOL if you search on "debugging stored procedures".
>> If you have Visual Studio 2005 also installed on the machine the same
>> search in the document explorer which combines MSDN and BOL for search
>> will give you more information that is relevant.
>> Andrew Watt
>> MVP - InfoPath
>> On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
>> <anonymous@.discussions.microsoft.com> wrote:
>>Hi,
>>How can you debug a stored procedure in SQL2005? I cannot find anything in
>>BOL (Sept CTP).
>>Thanks
>>Chris Wood
Debugging in SQL2005
Hi,
How can you debug a stored procedure in SQL2005? I cannot find anything in
BOL (Sept CTP).
Thanks
Chris WoodChris,
Please see:
http://www.aspfaq.com/sql2005/show.asp?id=1
HTH
Jerry
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:%23UZcW$L1FHA.1040@.TK2MSFTNGP14.phx.gbl...
> Hi,
> How can you debug a stored procedure in SQL2005? I cannot find anything in
> BOL (Sept CTP).
> Thanks
> Chris Wood
>|||Chris,
If you have installed only SQL Server 2005 you will find limited
information in BOL if you search on "debugging stored procedures".
If you have Visual Studio 2005 also installed on the machine the same
search in the document explorer which combines MSDN and BOL for search
will give you more information that is relevant.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
<anonymous@.discussions.microsoft.com> wrote:
>Hi,
>How can you debug a stored procedure in SQL2005? I cannot find anything in
>BOL (Sept CTP).
>Thanks
>Chris Wood|||We do not have VS2005 on the server.
Thanks
Chris
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
news:hmpcl1psevgsvjtl5p5401fnmr0a98rqgk@.
4ax.com...
> Chris,
> If you have installed only SQL Server 2005 you will find limited
> information in BOL if you search on "debugging stored procedures".
> If you have Visual Studio 2005 also installed on the machine the same
> search in the document explorer which combines MSDN and BOL for search
> will give you more information that is relevant.
> Andrew Watt
> MVP - InfoPath
> On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
> <anonymous@.discussions.microsoft.com> wrote:
>
>|||MSDN subscribers can, I believe, download the VS2005 Release Candidate
which includes the additional documentation I mentioned.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 09:44:05 -0600, "Chris Wood"
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>We do not have VS2005 on the server.
>Thanks
>Chris
>"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
> news:hmpcl1psevgsvjtl5p5401fnmr0a98rqgk@.
4ax.com...
How can you debug a stored procedure in SQL2005? I cannot find anything in
BOL (Sept CTP).
Thanks
Chris WoodChris,
Please see:
http://www.aspfaq.com/sql2005/show.asp?id=1
HTH
Jerry
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:%23UZcW$L1FHA.1040@.TK2MSFTNGP14.phx.gbl...
> Hi,
> How can you debug a stored procedure in SQL2005? I cannot find anything in
> BOL (Sept CTP).
> Thanks
> Chris Wood
>|||Chris,
If you have installed only SQL Server 2005 you will find limited
information in BOL if you search on "debugging stored procedures".
If you have Visual Studio 2005 also installed on the machine the same
search in the document explorer which combines MSDN and BOL for search
will give you more information that is relevant.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
<anonymous@.discussions.microsoft.com> wrote:
>Hi,
>How can you debug a stored procedure in SQL2005? I cannot find anything in
>BOL (Sept CTP).
>Thanks
>Chris Wood|||We do not have VS2005 on the server.
Thanks
Chris
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
news:hmpcl1psevgsvjtl5p5401fnmr0a98rqgk@.
4ax.com...
> Chris,
> If you have installed only SQL Server 2005 you will find limited
> information in BOL if you search on "debugging stored procedures".
> If you have Visual Studio 2005 also installed on the machine the same
> search in the document explorer which combines MSDN and BOL for search
> will give you more information that is relevant.
> Andrew Watt
> MVP - InfoPath
> On Wed, 19 Oct 2005 09:14:43 -0600, "Chris Wood"
> <anonymous@.discussions.microsoft.com> wrote:
>
>|||MSDN subscribers can, I believe, download the VS2005 Release Candidate
which includes the additional documentation I mentioned.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 09:44:05 -0600, "Chris Wood"
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>We do not have VS2005 on the server.
>Thanks
>Chris
>"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
> news:hmpcl1psevgsvjtl5p5401fnmr0a98rqgk@.
4ax.com...
Debugging acting weird
Hi!
I have VS2005 RC1 and SQL Server 2005 September CTP installed on the same machine.
I'm writing some pretty simple C# stored procedures and I'd like to be able to debug them with with the VS2005 IDE. However, something's not working.
When I set a breakpoint and I run the code (F5), it turns white with a red border informing me that "the breakpoint will not currently be hit. No symbols have been loaded for this document". Obviously, those breakpoints are not hit and I cannot debug exceptions either.
I made sure the connection the project is linked to has "ApplicationDebugging" and "Allow SQL/CLR Debugging" turned on.
I'm probably missing a very simple step to get this working, but Google didn't help me this time. So that's why I come here begging for your help!
Thanks in advance!
Carl
I have VS2005 RC1 and SQL Server 2005 September CTP installed on the same machine.
I'm writing some pretty simple C# stored procedures and I'd like to be able to debug them with with the VS2005 IDE. However, something's not working.
When I set a breakpoint and I run the code (F5), it turns white with a red border informing me that "the breakpoint will not currently be hit. No symbols have been loaded for this document". Obviously, those breakpoints are not hit and I cannot debug exceptions either.
I made sure the connection the project is linked to has "ApplicationDebugging" and "Allow SQL/CLR Debugging" turned on.
I'm probably missing a very simple step to get this working, but Google didn't help me this time. So that's why I come here begging for your help!
Thanks in advance!
Carl
Hi Carl,
Have you executed the following TSQL code to enable SQLCLR on the server?
Create a new Stored Procedure in VS, then add the following:
exec sp_configure 'clr enabled',1
reconfigure
If this doesnt work, could you answer the following questions:
1, Are you the running as the machine admin?
2, Are you able to debug a regular TSQL Stored Procedure?
3, Could you send me the text from the output window.
Thanks
Richard Cook
VS SQL Debugger QA
Debugging acting weird
Hi!
I have VS2005 RC1 and SQL Server 2005 September CTP installed on the same machine.
I'm writing some pretty simple C# stored procedures and I'd like to be able to debug them with with the VS2005 IDE. However, something's not working.
When I set a breakpoint and I run the code (F5), it turns white with a red border informing me that "the breakpoint will not currently be hit. No symbols have been loaded for this document". Obviously, those breakpoints are not hit and I cannot debug exceptions either.
I made sure the connection the project is linked to has "ApplicationDebugging" and "Allow SQL/CLR Debugging" turned on.
I'm probably missing a very simple step to get this working, but Google didn't help me this time. So that's why I come here begging for your help!
Thanks in advance!
Carl
I have VS2005 RC1 and SQL Server 2005 September CTP installed on the same machine.
I'm writing some pretty simple C# stored procedures and I'd like to be able to debug them with with the VS2005 IDE. However, something's not working.
When I set a breakpoint and I run the code (F5), it turns white with a red border informing me that "the breakpoint will not currently be hit. No symbols have been loaded for this document". Obviously, those breakpoints are not hit and I cannot debug exceptions either.
I made sure the connection the project is linked to has "ApplicationDebugging" and "Allow SQL/CLR Debugging" turned on.
I'm probably missing a very simple step to get this working, but Google didn't help me this time. So that's why I come here begging for your help!
Thanks in advance!
Carl
Hi Carl,
Have you executed the following TSQL code to enable SQLCLR on the server?
Create a new Stored Procedure in VS, then add the following:
exec sp_configure 'clr enabled',1
reconfigure
If this doesnt work, could you answer the following questions:
1, Are you the running as the machine admin?
2, Are you able to debug a regular TSQL Stored Procedure?
3, Could you send me the text from the output window.
Thanks
Richard Cook
VS SQL Debugger QA
Subscribe to:
Posts (Atom)