Cannot Debug SP.

Hi, everybody?!
I cannot use debugging function on some clients. For example, on my PC I
cannot use debugging facility.
Whenever I try to use debugging facility, it just returns results and ends.
I cannot use step-by-step function.
But on my laptop, I can use the function very well.
I wonder why I can't use the function on some clients, and can on other
ones.
Thanks.This is usually fixed by stepping through the section in BooksOnLine under
"troubleshooting SQL Server, Transact-SQL debugger" and ensuring you have
all the steps done correctly.
--
Andrew J. Kelly
SQL Server MVP
"Kim, KeukTae" <zyuuzika@.korea.com> wrote in message
news:OweEoodSDHA.3700@.tk2msftngp13.phx.gbl...
> Hi, everybody?!
> I cannot use debugging function on some clients. For example, on my PC I
> cannot use debugging facility.
> Whenever I try to use debugging facility, it just returns results and
ends.
> I cannot use step-by-step function.
> But on my laptop, I can use the function very well.
> I wonder why I can't use the function on some clients, and can on other
> ones.
> Thanks.
>
>

Cannot create a file when that file already exists

Platform: VC 7.0, NT4.0
Database: SQL Server 2000
Hi,
I created an in-proc server. It uses registry related function like
RegOpenKeyEx.
When I execute this COM object from Visual Basic it works fine.
When I execute same COM object from SQL Server Store procedure it files and
returns error like "Cannot create a file when that file already exists". May
I know why same code fails in case of SQL Server?
Thanks in advance.
Regards
VijayHi
CREATE FUNCTION dbo.fn_file_exists(@.filename VARCHAR(300))
RETURNS INT
AS
BEGIN
DECLARE @.file_exists AS INT
EXEC master..xp_fileexist @.filename, @.file_exists OUTPUT
RETURN @.file_exists
END
GO
-- test
SELECT dbo.fn_file_exists('d:\test1.txt')
"vijay" <vijaysingh@.abo.abosoftware.com> wrote in message
news:ujQzO7VxDHA.1856@.TK2MSFTNGP09.phx.gbl...
> Platform: VC 7.0, NT4.0
> Database: SQL Server 2000
>
> Hi,
> I created an in-proc server. It uses registry related function like
> RegOpenKeyEx.
> When I execute this COM object from Visual Basic it works fine.
> When I execute same COM object from SQL Server Store procedure it files
and
> returns error like "Cannot create a file when that file already exists".
May
> I know why same code fails in case of SQL Server?
>
> Thanks in advance.
>
> Regards
> Vijay
>