Query errors not displaying?

Question

Query errors not displaying?

jcrawf02

SSC-Insane

Points: 24198
More actions
December 18, 2008 at 9:42 am

#195239

Anybody have this issue before? Using Management Studio, running a query and it errors out - only it won't tell me why?
Messages tab is completely blank.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 1

Check the error log. You might be generating an error of sufficiently high a severity that it's just dropping the connection.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 2

Well isn't that a nice, fuzzy thought? All I did was

DECLARE @chaos varchar(max)

SELECT @chaos = replicate('DROP DATABASE ' + (SELECT name FROM sys.databases WHERE ID = N) + ' GO ',32767)

FROM Tally

WHERE N < 32,767

EXEC(@chaos)

😛

just kidding.

I'm just a lowly report writer, so I doubt it. Just trying to INSERT data into a global temp table.

Now, I'm doing just over 55k INSERTs, because I can't get my import wizard working, but I've done crazy stuff like that before, and it didn't choke.

Actually, I've run this exact script before and it didn't choke, so it's not that either.

*** Edit - oh yeah, duh. the "lowly report writer" comment means I can't get to the error logs either. Sorry, wasn't ignoring your suggestion.

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 3

actually, that query wouldn't work. It puts 32767 times the same drop statement for each database until it runs out of databases then it replicates null and since it's only a single value, all you get is null.

What query were you really running?

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 4

Bummer, there goes my grand scheme. 😉

just running inserts, sample below (minus the data)

INSERT INTO ##UCHP (status,[Name],Provider,DOS,[Claim Amt],[Paid Amt],[Paid Date],[Check Number],[Claim Number],[Payor]) VALUES ( ... )

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 5

Hmmm. I'm still with my original thought. You had a high severity error.

Any chance other people are inserting to that global temp table at the same time?

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 6

It'd be a long shot, that's a table for a termed vendor, on whom I'm doing analysis, it didn't exist in the tempdb before I ran the script, and I dropped it after the first error.

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 7

Do you have access to a trace or, assuming it's not production, can you run Profiler against it?

Without more info, I'm flummoxed. Sorry.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 8

Thanks, gotta run tonight, but I'll try Profiler tomorrow. Haven't actually used it before, so that'll be fun, I enjoy learning new tricks.

Thanks for the suggestions, I'll let you know what the results are.

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."