Default File path in 2005

Hi
How do I get default file path using TSQL/SP in 2005?
In MSSQL2000, I used sp_MSget_setup_paths undocumented sp to get this
information.
Please help
Dishan
attached but using xp's , spent a while searching for a more politically
correct alternative that came up blank
cheers,
Andy.
<dishan@.gmail.com> wrote in message
news:1133505385.263594.149210@.g44g2000cwa.googlegr oups.com...
> Hi
> How do I get default file path using TSQL/SP in 2005?
> In MSSQL2000, I used sp_MSget_setup_paths undocumented sp to get this
> information.
> Please help
> Dishan
>
begin 666 GetSQLPaths.txt
M+2T@.<F5P;&%C96UE;G0@.9F]R('-P7TU39V5T7W-E='5P7W!A=&AS#0H-"F1E
M8VQA<F4@.0$1E9F%U;'1&:6QE(&YV87)C:&%R*#4Q,BD-"F5X96,@.;6%S=&5R
M+F1B;RYX<%]I;G-T86YC95]R96=R96%D($XG2$M%65],3T-!3%]-04-(24Y%
M)RP@.3B=3;V9T=V%R95Q-:6-R;W-O9G1<35-344Q397)V97)<4V5T=7 G+"!.
M)U-13$1A=&%2;V]T)RP@.0$1E9F%U;'1&:6QE($]55%!55 T*4T5,14-4($!$
M969A=6QT1FEL90T*#0ID96-L87)E($!344Q0871H(&YV87)C:&%R*#4Q,BD-
M"F5X96,@.;6%S=&5R+F1B;RYX<%]I;G-T86YC95]R96=R96%D($XG2$M%65],
M3T-!3%]-04-(24Y%)RP@.3B=3;V9T=V%R95Q-:6-R;W-O9G1<35-344Q397)V
M97)<4V5T=7 G+"!.)U-13%!A=&@.G+"! 4U%,4&%T:"!/5510550-"E-%3$5#
,5"! 4U%,4&%T: T*
`
end
sql

Default File path in 2005

Hi
How do I get default file path using TSQL/SP in 2005'
In MSSQL2000, I used sp_MSget_setup_paths undocumented sp to get this
information.
Please help
Dishanattached but using xp's , spent a while searching for a more politically
correct alternative that came up blank
cheers,
Andy.
<dishan@.gmail.com> wrote in message
news:1133505385.263594.149210@.g44g2000cwa.googlegroups.com...
> Hi
> How do I get default file path using TSQL/SP in 2005'
> In MSSQL2000, I used sp_MSget_setup_paths undocumented sp to get this
> information.
> Please help
> Dishan
>
begin 666 GetSQLPaths.txt
M+2T@.<F5P;&%C96UE;G0@.9F]R('-P7TU39V5T7W-E='5P7W!A=&AS#0H-"F1E
M8VQA<F4@.0$1E9F%U;'1&:6QE(&YV87)C:&%R*#4Q,BD-"F5X96,@.;6%S=&5R
M+F1B;RYX<%]I;G-T86YC95]R96=R96%D($XG2$M%65],3T-!3%]-04-(24Y%
M)RP@.3B=3;V9T=V%R95Q-:6-R;W-O9G1<35-344Q397)V97)<4V5T=7 G+"!.
M)U-13$1A=&%2;V]T)RP@.0$1E9F%U;'1&:6QE($]55%!55 T*4T5,14-4($!$
M969A=6QT1FEL90T*#0ID96-L87)E($!344Q0871H(&YV87)C:&%R*#4Q,BD-
M"F5X96,@.;6%S=&5R+F1B;RYX<%]I;G-T86YC95]R96=R96%D($XG2$M%65],
M3T-!3%]-04-(24Y%)RP@.3B=3;V9T=V%R95Q-:6-R;W-O9G1<35-344Q397)V
M97)<4V5T=7 G+"!.)U-13%!A=&@.G+"! 4U%,4&%T:"!/5510550-"E-%3$5#
,5"! 4U%,4&%T: T*
`
end

Debugging TSQL Stored Procedures

Running SQL Server Express is there a way to debug TSQL stored procedures?I also have Visual Studio .NET 2003, can I use it to debug the TSQL stored procedures?

Thanks in advance,

Mark

No you need VS 2005 to debug SQL 2005.|||T-SQL Stored Procedure in 2005 can only be done with VSS 2005? Aargh

... I agree, this is a step backawards. Looking at my machien, I see

our company base install has included VSS, but it seems only for

Integration Services, Analysis Services and Reporting Services.

What do I need to do to get it to include the SQL 'component' into VSS?|||

I think you mis-read Euan's post, he said you need VS 2005, as in Visual Studio. Only one "S"; different that VSS for Visual Source Safe. Different thing altogether.

Mike

|||

I know ... you under-estimate the power of the typo and the rushing poster :-)

I was rushing the post, and didn't check what I was typing too clearly - a bad habit! I do know (and have used) Visual Source Safe ... and do have VS 2005 installed.

Now I just need to understand what I need to do to get it to open the SQL solution I have created - when I try to open projects, the extensions listed cover Integration Services, etc. etc. but not SQL project.

Thanks for trying to help me back onto the path - and again, sorry for the mistaken acronyms...

|||If you only have the BI Projects then you just have the BI version of VS, you need the Pro SKU or higher for SQL Projects.|||

Euan Garden wrote:

If you only have the BI Projects then you

just have the BI version of VS, you need the Pro SKU or higher for SQL

Projects.

Thanks Euan. Going to arrange that now.

Debug tsql

I tried to debug a procedure from query analyzer, but i could not able to step in or step out.
only few actions i could able to perform on the code,like execution,set break points.
step in and step out is not enabled.Is there any option to enable it..There is no "debug" of stored procs or in query analyzer. You will need to cut it down, exectue it line by line and use print statements, etc to see what is going on.

Are you getting an error?

If you post the stored proc here, someone might help you.|||

>>There is no "debug" of stored procs or in query analyzer

Are you sure?
Hit F8 this will open up the Object Browser, navigate to the proc, right click on the proc and select debug

Denis the SQL Menace
http://sqlservercode.blogspot.com/

|||I do not have a debug option on mine. Maybe you have the .NET development installed that gives you that?

Also, I might be wrong, but I think he said in one of the prior questions, he was using SQL 2000.|||

I am talking about query analyzer (SQL 2000)

Here I took a screen shot of it

http://tinypic.com/view/?pic=44hvq7a

Right click on the procedure and the last thing in the menu should be debug

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||Ohhhh. You are correct. I had never tried that method.

That does give a simple debugger version that might do what he wants.|||Even if you were wrong about the existance of the debugger, I far prefer your original technique :)|||what is the solution for my problem..