Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Canceled by user.

Author  Topic 

SMerrill
Posting Yak Master

206 Posts

Posted - 2010-06-25 : 20:14:50
I have Visual Studio 2010 Premium and SQL 2008 SP1 Enterprise, both installed on my personal Windows Server 2008 R2 Enterprise, 64-bit laptop.
I am administrator on the box, and have logged in to both products as administrator. I am using Windows Authentication, and have enabled both CLR and SQL debugging on the project.

All I get when I step into debugging is "Canceled by user."

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2010-06-29 : 16:51:11
what are you debugging. show your stuff

<><><><><><><><><><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion
Go to Top of Page

SMerrill
Posting Yak Master

206 Posts

Posted - 2010-07-01 : 18:48:23
I'm debugging the simplest of SQL CLR Stored Procedures written in C#.
SETUP
1. Consider any canned walkthrough which contains the statement: SqlContext.Pipe.Send("Hello, World!");
2. Mark it as UNSAFE, but set ALTER DATABASE dbname SET TRUSTWORTHY ON;
3. Mark it as Owned by "dbo'.
4. Start VS as Administrator, and here we go:
PROBLEM
5. Use "Step into Stored Procedure", and I can debug fine. However,
6. Use F5 alone to start the procedure, and the debugger rolls over dead and states 'Canceled by user.' (sic)



~ Shaun Merrill
Seattle area
Go to Top of Page
   

- Advertisement -