[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Wendy Elizabeth

6/29/2007 12:52:00 AM

I have a question about setting up visual studio.net 2005 professional
version to debug with a sql server 2000 database. The visual studio.net 2005
is on my workstation and the sql server 2000 databases are on two separate
window server boxes.
My goal is to debug some t-sql commands. To do this, I have setup a
project as a database project. The insturctions on the microsoft website url
says that I need to
attach to a process and the process that I need to attach to is
'sqlserver.exe'. However, I can not find this process to connect so. Thus, I
can not attach to it if it is not in the drop down list.
Thus can you tell me what my next step would be?

Thanks!
2 Answers

Damir

7/2/2007 8:32:00 AM

0

Hallo Wendy

I'm not sure I understood the Question the right way, but there is a
Checkbox called
"Show processes from all User", so select this checkbox and you will find
the SqlServer.exe

SqlServer.exe is a service and is running under System account.

Damir

"Wendy Elizabeth" <WendyElizabeth@discussions.microsoft.com> wrote in
message news:C6CDABF7-38FE-4063-A883-263FD362A2DF@microsoft.com...
> I have a question about setting up visual studio.net 2005 professional
> version to debug with a sql server 2000 database. The visual studio.net
> 2005
> is on my workstation and the sql server 2000 databases are on two separate
> window server boxes.
> My goal is to debug some t-sql commands. To do this, I have setup a
> project as a database project. The insturctions on the microsoft website
> url
> says that I need to
> attach to a process and the process that I need to attach to is
> 'sqlserver.exe'. However, I can not find this process to connect so. Thus,
> I
> can not attach to it if it is not in the drop down list.
> Thus can you tell me what my next step would be?
>
> Thanks!


Wendy Elizabeth

7/2/2007 3:44:00 PM

0

"Damir":
What I am trying to do is 'step through (debug) t-sql' commands using
visual studio.net 2005. So far nothing has woirked.
I did click on 'show processes in all sessions' and "Show processes from
all User"
and the closest thing that I could see for the web execution is
'sqlweb.exe'. This process is my version of visual studio.net 2005 running on
my workstation.

Thus do you have any other suggestions that I should try.

Thanks!



"Damir" wrote:

> Hallo Wendy
>
> I'm not sure I understood the Question the right way, but there is a
> Checkbox called
> "Show processes from all User", so select this checkbox and you will find
> the SqlServer.exe
>
> SqlServer.exe is a service and is running under System account.
>
> Damir
>
> "Wendy Elizabeth" <WendyElizabeth@discussions.microsoft.com> wrote in
> message news:C6CDABF7-38FE-4063-A883-263FD362A2DF@microsoft.com...
> > I have a question about setting up visual studio.net 2005 professional
> > version to debug with a sql server 2000 database. The visual studio.net
> > 2005
> > is on my workstation and the sql server 2000 databases are on two separate
> > window server boxes.
> > My goal is to debug some t-sql commands. To do this, I have setup a
> > project as a database project. The insturctions on the microsoft website
> > url
> > says that I need to
> > attach to a process and the process that I need to attach to is
> > 'sqlserver.exe'. However, I can not find this process to connect so. Thus,
> > I
> > can not attach to it if it is not in the drop down list.
> > Thus can you tell me what my next step would be?
> >
> > Thanks!
>
>
>