Questions tagged [debugging]
76 questions
20
votes
2 answers
How do I determine why a MongoDB document is failing validation?
How do I determine why a MongoDB document insert is failing validation? All I get back is a writeError that says "Document failed validation", which isn't very helpful.
(This happens often, and I'd like to understand how to properly debug these,…
Jonathan Wheeler
- 303
- 1
- 2
- 6
16
votes
1 answer
How do I find out *why* a user has certain effective permissions?
I know that I can query effective permissions by using sys.fn_my_permissions:
USE myDatabase;
SELECT * FROM fn_my_permissions('dbo.myTable', 'OBJECT')
entity_name | subentity_name | permission_name…
Heinzi
- 3,210
- 2
- 32
- 43
11
votes
1 answer
Surprising results for data types with type modifier
While discussing a recursive CTE solution for this question:
Get the last 5 distinct values for each ID
@ypercube stumbled across a surprising exception, which lead us to investigate the handling of type modifiers. We found surprising behavior.
1.…
Erwin Brandstetter
- 185,527
- 28
- 463
- 633
7
votes
2 answers
How to debug deadlocks in SQL Server 2008 R2?
I'm using SQL Server 2008 R2 that automatically lock database items based on my queries.
Sometimes this deadlocks - two threads with different queries never ends.
Is there any way to debug how SQL Server locks and unlocks resources? I have tried…
grigoryvp
- 173
- 1
- 1
- 5
7
votes
1 answer
SQL Server: Failed to start debugger - Data is Null
I'm a developer working on a web application using an instance of SQL Server 2014. I use Visual Studio 2010 sp1 for development. For a task I'm currently working on, I'd like to use the SQL Server Remote Debugger to debug a very large stored…
Garrett Bates
- 193
- 1
- 5
6
votes
4 answers
SQL Server Debugger Permissions without Granting sysadmin to Devs
BOL documentation says sysadmin permission is required to run debugger.
I'm 90% certain there is no workaround to this requirement, but thought I would ask just in case someone found a way to grant Debugger permission without granting sysadmin…
GWR
- 2,847
- 9
- 35
- 42
6
votes
1 answer
Failed to start TSQL debugger
I want to debug in TSQL.When I start the debug the following message box popup. In SSMS v17.2
Then I see this message:
In Microsoft Visual Studio 2015 Server Explorer same Error:
Then I see this message:
Thank You!
József Kökény
- 228
- 2
- 8
5
votes
1 answer
Remote Debugging
I'm having an issue with remote debugging. I have a non-domain server and a non-domain client PC. The client PC can successfully connect to the server and the instance, and it even runs SSMS as the context of the local administrator account of the…
Thomas Stringer
- 42,434
- 9
- 120
- 155
5
votes
2 answers
How to Log Debug Information About a Stored Procedure
We have a group of fairly complex stored procedures that process a transaction queue on a round the clock schedule. These scripts use a number of print statements to document what is being done to aid in debugging.
I want to keep this information…
Caynadian
- 255
- 1
- 4
- 10
5
votes
1 answer
How to change default port for T-SQL Debugger
The default port for T-SQL Debugger is 135, it is possible to change this port ? In my company this port is on special list of banned ports, therefore we need to open that service on another port number.
I am following this article:
Transact-SQL…
Muflix
- 1,099
- 5
- 15
- 27
4
votes
1 answer
What PL/pgSQL debugger can I use?
I'm building a lot of PL/pgSQL functions and a debugger would really come in handy because RAISE NOTICE is not enough.
I read about a pgAdmin plugin you can install but it was only on Windows and I'm running Mac OS X.
oxfist
- 361
- 1
- 5
- 14
4
votes
1 answer
Why is the "The package can not be saved to the file system since its protection level is server storage" error?
When I execute
dtutil /sourceserver localhost /SQL "\Maintenance Plans\MaintenancePlan_daily" /copy file;.\MaintenancePlan_daily.dtsx
from the answer to my question "Any way to import-export-migrate-save-restore a maintenance plan without having…
Fulproof
- 1,392
- 2
- 26
- 36
4
votes
2 answers
Where to look for possible deadlock causes?
We've been having several problems the past days in our production environment, and some of them seem to boil down to database issues.
Just realized we are having deadlocks (68 actually), on database "waypoint":
Can anyone please provide hints on…
Gonzalo Vasquez
- 1,059
- 2
- 18
- 33
4
votes
2 answers
Why are breakpoints not being hit in SQL Server Management Studio?
SQL Server Management Studio allows debugging of SQL (breakpoints and stepping through the SQL). It is possible to step in to a stored proc being called and to see a call stack. However I cannot determine how to set a breakpoint on a stored proc…
redcalx
- 383
- 3
- 5
- 11
3
votes
1 answer
A workaround for restoring HierarchyId in SQL server 2014
After installing VS 2015 CTP 4, HierarchyID stopped working in SQL Server 2014. This is the bug listed here.
I am looking for a workaround.
To that end, I have tried reinstalling everything associated with SQL Server 2014 and Visual Studio 2015…
soandos
- 157
- 1
- 2
- 8