Hi all,
I'm trying to debug storedprocedures in query analyzer from workstation, login with server adminuser.Debugger is not stoping at break points.
any help regarding this will be greatly appreciated.
thanks.
Environment:SQLServer Developer Edition on Machine AEnterprise Manager running on remote machine BBoth machines are in the same subnetI open Enterprise Mgr on Machine A, right click on the Stored Proc, enterthe parameters and the debugger stops on the first line and I can singlestep through it just fine.I open Enterprise Mgr on Machine B and connect to the same database onMachine B, right click on the same Stored Proc, enter the same parametersand the debugger doesn't stop, but it runs the proc al the way through.Even if I set a break point on one of the lines from this machine it doesn'tstop. I don't get any errors, it just runs right thought the proc.I've been through all the DCOM settings, Logins with Admin rights and not aSYSTEM account. Checked all the debug files and have them all registered.Anyone else expericened this? Anyone have any ideas on how to fix it?-Steve
View 4 Replies View RelatedI am trying to use the Transact-SQL debugger to step through a stored procedure on a server to determine where it is failing. I right-click the stored procedure I want to debug in the Query Analyzer's Object Browser and choose Debug... In the Debug Procedure dialog I fill in the values for the parameters, choose the Auto roll back checkbox, and press Execute.
The T-SQL Debugger screen comes up with my stored procedure and a message on the bottom of Waiting for user input. But I can input nothing, neither click on the icons on top, set breakpoints, or doing anything else, as the stored procedure runs to the end and gives me the return code.
If I subsequently set some breakpoints in my stored procedure and try the Go button. Once again the stored procedure runs to the end without stopping at any breakpoint.
In both cases, the stored procedure shows the waiting icon as it proceeds to the end, so that I can not click on anything to stop it.
I have been told this is may be a permissions issue between myself as a client on my machine and the stored procedure on the server. If so, does anybody know what I the things that have to be done on the permissions side to be able to debug the stored procedure using the Transact SQL debugger.
I have Team suite VS2005 sp1 installed and I can't debug my SSIS packages. If I put any break points in the Script code when I try to debug I get the message.
"SQL Server Integration Services Script Task has encountered a problem and needs to close. We are sorry for the inconvenience."
I click on close and it runs the package but doesn't stop at any break point. If I take out all break points it will run without this error. A couple of times I have managed to put in a single break point early in the package within a different script component which causes it to break... but at a completely different point within a completely different script component. It's so weird. Any help would be appreciated.
Hoots.
On the main BIDS menubar, there is a menu for Debug. If I select Debug > Delete All Breakpoints, any breakpoint in a script task is still there afterwards. Is there a way other than opening the script task and removing it there?
View 3 Replies View RelatedGreetings everyone, I'm posting this thread with the hope that someone will notice it and might offer me a helping hand regarding one of my problems.I have the database named "DBEXAMPLE" with the table MEMB_INFO that contains two important columns that are named cur_points and points where cur_points column contains the total available points that a member can use/spend on a game and the points column stores the total of the points that a member used so far.So as i plan to wipe all data of the database, i need to keep the member login,password and total points that each member purchased.So i will somehow need to update the cur_points column with the total of current cur_points+points columns and then wipe points column.I've personally asked a friend regarding this and he said that this should be something complicated and it might require php also.Really appreciate if someone could help me regarding this.small schema:Database: DBEXAMPLETable: MEMB_INFOColumn cur_points -> total available points that a member can spendColumn points -> total points that the member has already spentColumn memb___id -> member login aka account idTODO -> update cur_points column with the total of cur_points+points columns for each member(buyer)With best regards.
View 5 Replies View RelatedI have a report with several matrix objects. The data contained in each matrix is simple. One matrix has one column of labels and a column of data. The other has 3 columns of data. Both matrix's only show about 25 rows of data. A variable amount of data is displayed above the matrix's so that sometime the render across a page boundary. Whenever this happens the matrix doesn't render rows down to the bottom of the page. A considerable amount of empty space is left on the page, the completed matrix is displayed on the next page. I'm wondering how to get the matrix to render in this empty space.
This problem only occurs when I view the report on screen, in the Visual Studio "Preview" window, or from the Report Server web site. Tiff, pdf and printed output doesn't contain the extra space.
I've tried adding my matrix to a List and a Rectangle to see of this would fix the problem but it didn't help.
I've check the dimensions and margins or the page and I don't think I have any sizing problems, everything should fit on the page.
--Mark
Anyone know of any third party T-SQL debuggers for stepping through stored procedures? I understand there is one with VB6, but a student in my class doesn't work with VB. TIA.
View 1 Replies View RelatedHi,
I've just read in books on line that in Query Analyser there is a debugger tool. Unfortunately I can't work out how to access and use it. Can any one send me some info on this please.
Thanks
Steve
Hi All,
Once I open my TSQL Debugger all the icons are disables ( Step Into , Step Over ).
This is the fisrt time I am using it can you please point be in the right direction.
This happens after giving the Input parameters in the Dubug Window for the Stored Procedure
and when I click the EXECUTE button.
NOTE : This happeds when I lauch the Debugger from the ClIENT Machines. If I run the debugger on the
server directly it works fine. Am I missing any of the DLLs
Thx
venu
Hi,Could u tell me how to use the debug tool to debug out t-sql statements .With Thanks
View 2 Replies View RelatedI'm trying to get the T-SQL Debugger to work between SQL Server 7 and Visual Studio 6.0.
First of all, I am confused by the various articles I have read in MSDN. Some indicate that the debugger will work in Visual Basic and some indicate Visual Interdev. Does it work in both environments? After following all of the steps listed in the MSDN articles I cannot get the T-SQL Debugger to appear in my Add-Ins window in Visual Basic. Is there something else I need to do?
Secondly, I can see my stored procedures in Visual Interdev and once I open one in the editor the only commands enabled on the DEBUG menu are Clear All Breakpoints, Breakpoints... and Processes.... According to one of the MSDN articles I should see all of the DEBUG menu commands enabled. Any ideas what I can do to get the rest of the menu commands enabled?
Also, I can set a breakpoint in a stored procedure by clicking in the gray area to the left of the line of code where I want the debugger to stop. The red dot appears next to the line of code. But when I execute the stored procedure the debugger asks for the parameters but never stops at the breakpoint. It runs the stored procedure to completion.
I would appreciate any ideas on how to get this working.
TIA.
Jane
Hello All
Can anyone tell me besttool for debugging the Stored Procedure user
friendly. We are using Powerbuilder/Sql Server 6.5 as back end. we got
lots of stored procedures and I am having tough time in debugging.
I actually moved from Oracle and don't know much about Sqlserver just started
learning.
If anyone tell me best tool,method for doing then I will be very greatful
Thanks In Advance
Sundar
I can get the debugger to work: I get a message:"sp debugging may not work if you log as as Local System Account" whileSQL Service is configured to run as a service. You can open Event Viwerto see details." (Viwer means "Viewer" this is not one of my typos...)My text book says that this message means there is a problem that canbe fixed in the SQL Server registration node (just under the servergroup in Enterprise Manager), Properties dialog, Security tab, Start UpService.The book says to enter a valid user account and password in the StartUp Service area. However, there is in my case a "LocalSystem" and anencrypted password entered in this area and and I have no idea howthese got in there.I assume the latter are default settings from when SQL wasinstalled...Can I can this to "sa" and no password? I'm afraid tochange the existing setting if I don't understand what it is and whereit came from..Thank you **very** much for help...I would like to use the debugger.J.
View 1 Replies View RelatedHi,When I debug our sp by using T-SQL Debugger, I got following error.Server: Msg 229, Level 14, State 5, Procedure sp_sdidebug, Line 1[Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permissiondenied on object 'sp_sdidebug', database 'master', owner 'dbo'.and when I grant the permission of sp_sdidebug, I got following error.Server: Msg 4610, Level 16, State 1, Line 1You can only grant or revoke permissions on objects in the currentdatabase.I am using following statement to grant the permission.GRANT EXECUTEON sp_sdidebugTO myuserHere, I want to clear, myuser is I, which one i log QA.and myuser has public and dbowner permission--Rahul
View 2 Replies View RelatedI'm using the Transact-SQL Debugger for the first time here.I go to Object Browser, find my stored procedure, right click andchoose "Debug".The "Debug Procedure" window comes up, and I click on the Executebutton.The Debug environment comes up and automatically executes myprocedure. It doesn't allow me to single step through the code.What am I missing here?All of the "step" buttons, "restart", and "stop debugging" buttonsare dimmed out.Thanks.Ken
View 3 Replies View RelatedHow do I get into Transact SQL Debugger?
I am using Visual Studio 2005, and I go to server explorer and make a new connection to a database.
I select a stored procedure and right mouse click.
There is no menu item called "Step Into ... " in the pop up menu.
So what am I missing? Do I have to install or set up something
in order to use Transact SQL Debugger?
Any pointer or answer is greatly appreciated. Thanks a lot.
Chris
hi,
while trying out one function which needs to connect to the database,i got this error:
An unhandled win32 exception occurred in name.vshost.exe[1668].
it prompted me to select a debugger.what does this error mean?
I installed the SQL 2000 trial as a local server on a standalone XP Pro system. When use the debugger, it executes the stored procedure without allowing me to step into the code.
Any help would be greatly appreciated.
I am trying to debug a t-SQL function. I am supposed to have both Enterprise Manager for SQL 2000, and Management Studio for SQL 2005, on my computer. In the books-online for SQL 2000 there is a reference to a T-SQL debugger which does all the things that you'd expect: checkpoints, ablility to stop and examine data, etc. I don't seem to have books-online for SQL 2005 - I merely get "help on Help" which is rather useless.Anyway, how do I get this debugger to work? I can't find anything in either Enterprise Manager or Management Studip.Thanks, Robert Barnes
View 4 Replies View Relatedhi all I'm working on a complicated activex script which is a part of a DTS package. Are there some debuggers around that could help make the task easier? Specifically I'm looking for an ActiveX script debugger. Can somebody point me to a tutorial or something? Regards
View 1 Replies View RelatedPlease kindly advise in details how to use a debugger on stored procedures.Thanks.
View 4 Replies View RelatedTransact-sql debugger comes with sqlserver 2000. I checked my server and
all the dll;s are loaded correctly, sqldbreg process is running. I also configured the client correctly.
How do I invoke this debugger? Which settings you change to get to the toolbar for the debugger in query anayl..
I know how to create mount point in windows 20003 cluster, I am not sure how
to set it up with SQL 2005 running on the cluster.
Does sql need to be dependant on any of the disks? I have tried looking for
a guide, but cannot find.
current setup active active cluster running. I need to add san space which
will hold the databases. The san will be carved up into drive letters. each
drive letter will hold 3 mount points.
ie.
node 1
J:-2 mount point
k:2 mount point
l:2 mount point
node 2-
r:-2 mount point
s:2 mount point
t:2 mount point
each node would be able to own the disk if the other node failed over.
any help is appreciate. I have tried books online etc.. cannot find a good
step by step.;
thanks
Hi
Can anyone let me know if there is any Debugger for stored procedure in SQL Server 7.0, if yes
where can i find one
thanks and regards
Arun
At Sql Server Live, I saw Sharon Dooley using the debugger in Query Analyzer, but now that I've tried it I can't step an sp, instead, I get....Quote:
SP debugging may not work properly if you log on as 'Local
System account' while SQL Server is configured to run as a
service.
You can open Event Viwer to see details.
Do you wish to continue?
End Quote:
I'm logged in at a W2Kpro box connectig via client tools
to a W2KSVR box via Integrated NT security. SS2K is NOT
installed locally.
(This is prob. a really dumb question but it's driving me mad!!...)
I am using the Debugger in SQL Query Analyzer & want to set the value of a datetime parameter prior to executing the stored proc. The "Debug procedure" window allows me to specify the parameter values - but I can't get it to accept a datetime. The language is us_english & I've tried most ways if specifying the date - 01/02/2004, with/out quotes, 02 Jan 2004, as a full datetime, swapping day/month values etc etc. The procedure always fails immediately with: Invalid character value for cast specification.
Thanks.
On my development maching, I have three different SQL Server instances:..SQL2000..SQL2005EXPRESS..SQL2005When i try to debug a stored procedure in Query Analyzer, I get thefollowing error:"Server: Msg 508, Level 16, State 1, Procedure sp_sdidebug, Line 1[Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to debuggeron MYPCSQL2000 (Error = 0x800401f3). Ensure that client-side components,such as SQLLE.DLL, are installed and registered on MYPC. Ddebugging disablefor connection 53."Client side components _are_ installed. What gives? Any ideas?J. JespersenDenmark
View 1 Replies View RelatedHI All,
I use MSSQL as my database and ASP.NET as my front application. I want to display Price value S$23.68.
The dayatype I used is smallmoney, but it display: S$23.6800. HOw do I control the number of decimals point in the column of MSSQL??
Thanks a lot
Suigion
Dear experts,
Hi, I got a table name Employee, with the following fields
EmployeeID
Name,
ManagerID
ManagerID2,
ManagerID3,
ManagerID4 ..
ManagerID, ManagerID2, ManagerID3, ManagerID4 are all pointing to EmployeeID in the same table.
Now I want to select the all employee records where the manager NAME is like '%Raymond%'. (i.e. any of the four managers name is like '%Raymond%'.
How do I construct the select query? I tried this, but it does not work if there are more than 1 manager named 'Raymond'
DECLARE @Name varchar(50)
SET @Name = '%Raymond%'
DECLARE @EmployeeNumber nvarchar(50)
Select
@EmployeeNumber = EmployeeID
from
Employee
where
[Name] like @Name
SELECT
'HumanResources.Employee' as TableName,
E.[Name] as EmployeeName ,
isnull((Select [Name] from Employee E2 where E2.EmployeeID = E.ManagerID),'') as Manager1,
isnull((Select [Name] from Employee E2 where E2.EmployeeID = E.ManagerID2),'') as Manager2,
isnull((Select [Name] from Employee E2 where E2.EmployeeID = E.ManagerID3),'') as AppraisingManager,
isnull((Select [Name] from Employee E2 where E2.EmployeeID = E.ManagerID4),'') as ModeratingManager,
E.CurrentFlag as Active
FROM
HumanResources.Employee E
WHERE
(E.[ManagerID] = @EmployeeNumber)
or (E.[ManagerID2] = @EmployeeNumber)
or (E.[AppraisingManagerID] = @EmployeeNumber)
or (E.[ModeratingManagerID] = @EmployeeNumber))
Any help is very much appreciated.
I understand mount points help scalability in easier maintenance.
By scalability do we mean more than 26 drive letters or it means adding more space to the same mount point letter on with more ease .
Can I add more space to a mountpoint if required later on by adding hard disks .
Also if one can give some pointers to good file group configuration guidelines / storage align partitions , it will be very much helpful
Further I my server CPU has 4 cores , will having 4 filegroups help me in improving system performance.
If SAN has 2 controllers , is it preferred to run data file partition on one controller and log file partition on another.
Thanks in advance.
I have a column in a table with a data type of float.
When I update it to store 7.50, it changes it to 7.5
Is there any way to force it to store 2 decimal points?
Hello,
We have a requirement to be able to monitor mount points. The xp_fixeddrives does not support mount point monitoring. Is there another way to do it. Does microsoft working on updating the xp_fixeddrives. Let me know if anyone has any ideas how to monitor mount points.
Thanks