My favorites | Sign in
Project Home Source
New issue   Search
for
  Advanced search   Search tips   Subscriptions
Issue 3087: Connection crash on MS Azure, where master.dbo.sysprocesses table does not exist
1 person starred this issue and may be notified of changes. Back to list
Status:  Fixed
Owner:  ----
Closed:  Jan 2013


Sign in to add a comment
 
Reported by romanov4...@gmail.com, Jan 14, 2013
What exact steps will reproduce the problem?
1. Create database in Windows Azure
2. Connect to database

What was the expected output?

What happened instead?
1. Error message: SQL (208): Invalid object name 'master.dbo.sysprocesses'
2. Crash: Division by zero.
See attach

Version used?
 HeidiSQL revision: 7.0.0.4309
 SQL Server version: Windows Azure, don't know SQL Server version :(
 Operating system: Windows 7 x64
bugreport.txt
2.5 KB   View   Download
Jan 14, 2013
Project Member #1 a...@anse.de
You need to report the server version, I cannot fix anything otherwise.
Status: NeedInfo
Labels: Severity-Broken
Jan 14, 2013
#2 romanov4...@gmail.com
Thanks! dbForge Stdudio showed server version 11.00.2224
Jan 15, 2013
Project Member #3 a...@anse.de
Thanks. Any idea how to query sysprocesses on MSSQL 11?
Jan 15, 2013
#4 romanov4...@gmail.com
No ideas :( It my first try to work with Windows Azure and MS SQL
In any case, thanks for the great program!
Jan 15, 2013
Project Member #5 a...@anse.de
http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/9339be5a-cacc-421a-ae9a-5e1fd036841c

"SQL Azure does not have a sysprocesses table, because the hardware is shared between users and MS doesn't want you to see what's running."

Ok, I should modifiy HeidiSQL so that sysprocesses is not running into a connection blocker if the query fails. Querying sysprocesses is used to determine the server's uptime, a useful but dispensable information.
Summary: Connection crash on MS Azure, where master.dbo.sysprocesses table does not exist (was: Crash, when connect to Windows Azure)
Status: Accepted
Labels: MSSQL
Jan 15, 2013
Project Member #6 a...@anse.de
This issue was closed by revision r4311.
Status: Fixed
Jan 15, 2013
#7 romanov4...@gmail.com
Thanks!
Sign in to add a comment

Powered by Google Project Hosting