|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Debugging SP in 2005Hi everyone,
I installed SQL 2005 and I am testing it now. I can't seem to find an easy way of debugging procedures any more. In SQL 200 query analyzer, one can right-click and there is Debug option there. Where did it go now? Please point me in the right direction. Thanks Farmer What is the Beta version you are using?. As 2K5 is still in beta lot of 2000
features are still missing. Hope it will be in teh final relase. -- Show quoteThanks Ravi "Farmer" wrote: > Hi everyone, > I installed SQL 2005 and I am testing it now. I can't seem to find an easy > way of debugging procedures any more. In SQL 200 query analyzer, one can > right-click and there is Debug option there. Where did it go now? > Please point me in the right direction. > > Thanks > Farmer > > > I use June CTP, 9.00.1187.00
I found an article on it http://www.sqljunkies.com/WebLog/nielsb/archive/2004/08/04/3758.aspx but I can't seem to see those "Allow SQL/CLR Debugging" and "Step Into ...", options he mentions there. Thanks Show quote "Ravi" <ravishank***@hotmail.com> wrote in message news:8761A3CA-C122-476F-B29B-57D629C5FF35@microsoft.com... > What is the Beta version you are using?. As 2K5 is still in beta lot of > 2000 > features are still missing. Hope it will be in teh final relase. > > -- > Thanks > Ravi > > > "Farmer" wrote: > >> Hi everyone, >> I installed SQL 2005 and I am testing it now. I can't seem to find an >> easy >> way of debugging procedures any more. In SQL 200 query analyzer, one can >> right-click and there is Debug option there. Where did it go now? >> Please point me in the right direction. >> >> Thanks >> Farmer >> >> >> Debugging used to be an option at installation. Is it just not installed in
my case, maybe? Where would I verify that now? The preveous SQL 2000 instllation was way simplier. This one has many choices that I am not that familiar with yet. Show quote "Farmer" <some***@somewhere.com> wrote in message news:e5Fkr6ZfFHA.272@TK2MSFTNGP15.phx.gbl... >I use June CTP, 9.00.1187.00 > > I found an article on it > http://www.sqljunkies.com/WebLog/nielsb/archive/2004/08/04/3758.aspx but I > can't seem to see those "Allow SQL/CLR Debugging" and "Step Into ...", > options he mentions there. > > Thanks > > > "Ravi" <ravishank***@hotmail.com> wrote in message > news:8761A3CA-C122-476F-B29B-57D629C5FF35@microsoft.com... >> What is the Beta version you are using?. As 2K5 is still in beta lot of >> 2000 >> features are still missing. Hope it will be in teh final relase. >> >> -- >> Thanks >> Ravi >> >> >> "Farmer" wrote: >> >>> Hi everyone, >>> I installed SQL 2005 and I am testing it now. I can't seem to find an >>> easy >>> way of debugging procedures any more. In SQL 200 query analyzer, one can >>> right-click and there is Debug option there. Where did it go now? >>> Please point me in the right direction. >>> >>> Thanks >>> Farmer >>> >>> >>> > > Refer the topic "Debugging CLR Database Objects " in SQL 2005 BOL
-- Show quoteThanks Ravi "Farmer" wrote: > Debugging used to be an option at installation. Is it just not installed in > my case, maybe? > Where would I verify that now? > The preveous SQL 2000 instllation was way simplier. This one has many > choices that I am not that familiar with yet. > > "Farmer" <some***@somewhere.com> wrote in message > news:e5Fkr6ZfFHA.272@TK2MSFTNGP15.phx.gbl... > >I use June CTP, 9.00.1187.00 > > > > I found an article on it > > http://www.sqljunkies.com/WebLog/nielsb/archive/2004/08/04/3758.aspx but I > > can't seem to see those "Allow SQL/CLR Debugging" and "Step Into ...", > > options he mentions there. > > > > Thanks > > > > > > "Ravi" <ravishank***@hotmail.com> wrote in message > > news:8761A3CA-C122-476F-B29B-57D629C5FF35@microsoft.com... > >> What is the Beta version you are using?. As 2K5 is still in beta lot of > >> 2000 > >> features are still missing. Hope it will be in teh final relase. > >> > >> -- > >> Thanks > >> Ravi > >> > >> > >> "Farmer" wrote: > >> > >>> Hi everyone, > >>> I installed SQL 2005 and I am testing it now. I can't seem to find an > >>> easy > >>> way of debugging procedures any more. In SQL 200 query analyzer, one can > >>> right-click and there is Debug option there. Where did it go now? > >>> Please point me in the right direction. > >>> > >>> Thanks > >>> Farmer > >>> > >>> > >>> > > > > > > > Thank you.
I am much clearer now why not. However, this sucks if MS were to leave it this way. Now when I go to a SQL Server I can't debug anything unless I have VS2005 installed? How about being at customer site, managing SQL 2005? I am DBA and I never needed VS (I have it though) as I always would write TSQL procedures in query analyzer. Most often I don't need debugger at all as I manage to create tight TSQL procedures that do what I need in 1-2-3 more complex SQL statements (this newsgroup is awesome for leaning TSQL tricks). I guess this is a new era coming; I need now to bloat my computer with a full VS2005. Show quote "Ravi" <ravishank***@hotmail.com> wrote in message news:985480EE-98F9-4731-9C77-3FB24A7F1396@microsoft.com... > Refer the topic "Debugging CLR Database Objects " in SQL 2005 BOL > -- > Thanks > Ravi > > > "Farmer" wrote: > >> Debugging used to be an option at installation. Is it just not installed >> in >> my case, maybe? >> Where would I verify that now? >> The preveous SQL 2000 instllation was way simplier. This one has many >> choices that I am not that familiar with yet. >> >> "Farmer" <some***@somewhere.com> wrote in message >> news:e5Fkr6ZfFHA.272@TK2MSFTNGP15.phx.gbl... >> >I use June CTP, 9.00.1187.00 >> > >> > I found an article on it >> > http://www.sqljunkies.com/WebLog/nielsb/archive/2004/08/04/3758.aspx >> > but I >> > can't seem to see those "Allow SQL/CLR Debugging" and "Step Into ...", >> > options he mentions there. >> > >> > Thanks >> > >> > >> > "Ravi" <ravishank***@hotmail.com> wrote in message >> > news:8761A3CA-C122-476F-B29B-57D629C5FF35@microsoft.com... >> >> What is the Beta version you are using?. As 2K5 is still in beta lot >> >> of >> >> 2000 >> >> features are still missing. Hope it will be in teh final relase. >> >> >> >> -- >> >> Thanks >> >> Ravi >> >> >> >> >> >> "Farmer" wrote: >> >> >> >>> Hi everyone, >> >>> I installed SQL 2005 and I am testing it now. I can't seem to find an >> >>> easy >> >>> way of debugging procedures any more. In SQL 200 query analyzer, one >> >>> can >> >>> right-click and there is Debug option there. Where did it go now? >> >>> Please point me in the right direction. >> >>> >> >>> Thanks >> >>> Farmer >> >>> >> >>> >> >>> >> > >> > >> >> >> Same here. I am also a DBA and I don't have anything other than SQl server
client tools. Now we need more and more tools. But if you notice 1 thing in June CTP t he " SQL Server Business Intelligence Development Studio" is not separate IDE like Beta 2 and Beta 3. It is VS2005 Beta. So when the full relase comes you need VS20005 to create DTS(BTW it is SSIS Packages packages :-)) etc., -- Show quoteThanks Ravi "Farmer" wrote: > Thank you. > I am much clearer now why not. > > However, this sucks if MS were to leave it this way. > Now when I go to a SQL Server I can't debug anything unless I have VS2005 > installed? How about being at customer site, managing SQL 2005? > I am DBA and I never needed VS (I have it though) as I always would write > TSQL procedures in query analyzer. Most often I don't need debugger at all > as I manage to create tight TSQL procedures that do what I need in 1-2-3 > more complex SQL statements (this newsgroup is awesome for leaning TSQL > tricks). > I guess this is a new era coming; I need now to bloat my computer with a > full VS2005. > > > "Ravi" <ravishank***@hotmail.com> wrote in message > news:985480EE-98F9-4731-9C77-3FB24A7F1396@microsoft.com... > > Refer the topic "Debugging CLR Database Objects " in SQL 2005 BOL > > -- > > Thanks > > Ravi > > > > > > "Farmer" wrote: > > > >> Debugging used to be an option at installation. Is it just not installed > >> in > >> my case, maybe? > >> Where would I verify that now? > >> The preveous SQL 2000 instllation was way simplier. This one has many > >> choices that I am not that familiar with yet. > >> > >> "Farmer" <some***@somewhere.com> wrote in message > >> news:e5Fkr6ZfFHA.272@TK2MSFTNGP15.phx.gbl... > >> >I use June CTP, 9.00.1187.00 > >> > > >> > I found an article on it > >> > http://www.sqljunkies.com/WebLog/nielsb/archive/2004/08/04/3758.aspx > >> > but I > >> > can't seem to see those "Allow SQL/CLR Debugging" and "Step Into ...", > >> > options he mentions there. > >> > > >> > Thanks > >> > > >> > > >> > "Ravi" <ravishank***@hotmail.com> wrote in message > >> > news:8761A3CA-C122-476F-B29B-57D629C5FF35@microsoft.com... > >> >> What is the Beta version you are using?. As 2K5 is still in beta lot > >> >> of > >> >> 2000 > >> >> features are still missing. Hope it will be in teh final relase. > >> >> > >> >> -- > >> >> Thanks > >> >> Ravi > >> >> > >> >> > >> >> "Farmer" wrote: > >> >> > >> >>> Hi everyone, > >> >>> I installed SQL 2005 and I am testing it now. I can't seem to find an > >> >>> easy > >> >>> way of debugging procedures any more. In SQL 200 query analyzer, one > >> >>> can > >> >>> right-click and there is Debug option there. Where did it go now? > >> >>> Please point me in the right direction. > >> >>> > >> >>> Thanks > >> >>> Farmer > >> >>> > >> >>> > >> >>> > >> > > >> > > >> > >> > >> > > > > So when the full But you don't need to buy VS. The VS IDE is shipped with SQL Server (just like in June CTP). At > relase comes you need VS20005 to create DTS(BTW it is SSIS Packages packages > :-)) etc., least this is how I understand it. and perhaps debugging will be available from there? (I don't know, just thinking out loud.) -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Ravi" <ravishank***@hotmail.com> wrote in message news:B58FDEC2-A9E0-487F-84BC-14A7A130DD3B@microsoft.com... > Same here. I am also a DBA and I don't have anything other than SQl server > client tools. Now we need more and more tools. But if you notice 1 thing in > June CTP t he " SQL Server Business Intelligence Development Studio" is not > separate IDE like Beta 2 and Beta 3. It is VS2005 Beta. So when the full > relase comes you need VS20005 to create DTS(BTW it is SSIS Packages packages > :-)) etc., > > -- > Thanks > Ravi > > > "Farmer" wrote: > >> Thank you. >> I am much clearer now why not. >> >> However, this sucks if MS were to leave it this way. >> Now when I go to a SQL Server I can't debug anything unless I have VS2005 >> installed? How about being at customer site, managing SQL 2005? >> I am DBA and I never needed VS (I have it though) as I always would write >> TSQL procedures in query analyzer. Most often I don't need debugger at all >> as I manage to create tight TSQL procedures that do what I need in 1-2-3 >> more complex SQL statements (this newsgroup is awesome for leaning TSQL >> tricks). >> I guess this is a new era coming; I need now to bloat my computer with a >> full VS2005. >> >> >> "Ravi" <ravishank***@hotmail.com> wrote in message >> news:985480EE-98F9-4731-9C77-3FB24A7F1396@microsoft.com... >> > Refer the topic "Debugging CLR Database Objects " in SQL 2005 BOL >> > -- >> > Thanks >> > Ravi >> > >> > >> > "Farmer" wrote: >> > >> >> Debugging used to be an option at installation. Is it just not installed >> >> in >> >> my case, maybe? >> >> Where would I verify that now? >> >> The preveous SQL 2000 instllation was way simplier. This one has many >> >> choices that I am not that familiar with yet. >> >> >> >> "Farmer" <some***@somewhere.com> wrote in message >> >> news:e5Fkr6ZfFHA.272@TK2MSFTNGP15.phx.gbl... >> >> >I use June CTP, 9.00.1187.00 >> >> > >> >> > I found an article on it >> >> > http://www.sqljunkies.com/WebLog/nielsb/archive/2004/08/04/3758.aspx >> >> > but I >> >> > can't seem to see those "Allow SQL/CLR Debugging" and "Step Into ...", >> >> > options he mentions there. >> >> > >> >> > Thanks >> >> > >> >> > >> >> > "Ravi" <ravishank***@hotmail.com> wrote in message >> >> > news:8761A3CA-C122-476F-B29B-57D629C5FF35@microsoft.com... >> >> >> What is the Beta version you are using?. As 2K5 is still in beta lot >> >> >> of >> >> >> 2000 >> >> >> features are still missing. Hope it will be in teh final relase. >> >> >> >> >> >> -- >> >> >> Thanks >> >> >> Ravi >> >> >> >> >> >> >> >> >> "Farmer" wrote: >> >> >> >> >> >>> Hi everyone, >> >> >>> I installed SQL 2005 and I am testing it now. I can't seem to find an >> >> >>> easy >> >> >>> way of debugging procedures any more. In SQL 200 query analyzer, one >> >> >>> can >> >> >>> right-click and there is Debug option there. Where did it go now? >> >> >>> Please point me in the right direction. >> >> >>> >> >> >>> Thanks >> >> >>> Farmer >> >> >>> >> >> >>> >> >> >>> >> >> > >> >> > >> >> >> >> >> >> >> >> >>  |
|||||||||||||||||||||||
Other interesting topics