SQL Express Manager
-
All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions
Nice link! Previous versions of SQL Server provided stand-alone tools for debugging stored procedures. With SQL Server 2005, however, stored procedures, triggers, and User-Defined Functions (UDFs) are debugged through Visual Studio Team System or Professional editions. Argh. The behemoth gets bigger. What's wrong with stand-alone tools? Marc
-
Is there a way to step through the sql code I wrote? I couldn't find anything. I sure do miss pl/sql and oracle right now...
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001 -
Doesn't TOAD have a sql server version?
What is TOAD?
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001 -
What is TOAD?
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001 -
Nice link! Previous versions of SQL Server provided stand-alone tools for debugging stored procedures. With SQL Server 2005, however, stored procedures, triggers, and User-Defined Functions (UDFs) are debugged through Visual Studio Team System or Professional editions. Argh. The behemoth gets bigger. What's wrong with stand-alone tools? Marc
Marc Clifton wrote:
What's wrong with stand-alone tools?
You mean you actually want me to Alt-Tab? How 1990s. Ctrl-Tabing is the way of the future.
Dad always thought laughter was the best medicine, which I guess is why several of us died of tuberculosis. I can picture in my mind a world without war, a world without hate. And I can picture us attacking that world, because they'd never expect it.
-
Excellent (not!) That's one tool I won't be buying today. I went to their web site, clicked the first link for Toad for SQL Server v3.1 and, after some delay, it told me it couldn't do that because the applet "blaah blaah" didn't exist. It offered a link to take me back to the previous "screen"; I clicked that and it said "An error happened during restoring the context for requested location". It's probably not even entirely their fault - I expect their online store provider is at least partly to blame - but it's a showstopper for someone who might just have been interested in the product!
Phil
The opinions expressed in this post are not necessarily those of the author, especially if you find them impolite, inaccurate or inflammatory.
-
Excellent (not!) That's one tool I won't be buying today. I went to their web site, clicked the first link for Toad for SQL Server v3.1 and, after some delay, it told me it couldn't do that because the applet "blaah blaah" didn't exist. It offered a link to take me back to the previous "screen"; I clicked that and it said "An error happened during restoring the context for requested location". It's probably not even entirely their fault - I expect their online store provider is at least partly to blame - but it's a showstopper for someone who might just have been interested in the product!
Phil
The opinions expressed in this post are not necessarily those of the author, especially if you find them impolite, inaccurate or inflammatory.
Pity: used it for quite some time (with Oracle and MySql) and it really is an excellent tool. Think there might even still be a free version for Oracle knocking around somewhere.
-
Is there a way to step through the sql code I wrote? I couldn't find anything. I sure do miss pl/sql and oracle right now...
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001I pen and paper my sql code. I find it results in extremely fast db code. Personally, if it is too complex to pen and paper it may not need to reside on a database anyway.
Need a C# Consultant? I'm available.
Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway -
digital man wrote:
Also thought that anyone who has used Oracle would know of TOAD.
And even those of us that do not use it know how to do a basic search. :rolleyes:
"Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for, in order to get to the job you need to pay for the clothes and the car and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
-
Pity: used it for quite some time (with Oracle and MySql) and it really is an excellent tool. Think there might even still be a free version for Oracle knocking around somewhere.
