Error with the Code Above
-
When I run the jordanac code, I receive these errors:
Server: Msg 207, Level 16, State 3, Line 2
Invalid column name 'sql_handle'.
Server: Msg 195, Level 15, State 1, Line 3
'fn_get_sql' is not a recognized function name.
My SQL was updated to SP3, at least if think, could someone confirm that the version showed in Properties of my SQL (8.00.194(RTM)) is the SP3 ?
[]s,
JR
-
Try adding dbo. in front of it.
If you look in the list of functions in EM, is it there?
Cheers,
Crispin
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
-
According to http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=3&tabid=4 you should be on 8.00.760 or above if you had SP3.
8.00.194 is the version number without any SP
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
...in addition, when running via QA select master as db, or you'll get something like this
Server: Nachr.-Nr. 208, Schweregrad 16, Status 1, Zeile 2
Invalid object name 'sysprocesses'.Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
quote:
...in addition, when running via QA select master as db, or you'll get something like this
Server: Nachr.-Nr. 208, Schweregrad 16, Status 1, Zeile 2
Invalid object name 'sysprocesses'.Frank, it's good to read auf deutsch once in awhile.
Dr. Peter Venkman: Generally you don't see that kind of behavior in a major appliance.
Patrick
Quand on parle du loup, on en voit la queue
-
You will find a long list of sql version number with some descriptions at
http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=3&tabid=4
Steven
-
quote:
quote:
...in addition, when running via QA select master as db, or you'll get something like this
Server: Nachr.-Nr. 208, Schweregrad 16, Status 1, Zeile 2
Invalid object name 'sysprocesses'.Frank, it's good to read auf deutsch once in awhile.
Dr. Peter Venkman: Generally you don't see that kind of behavior in a major appliance.
Patrick
on our servers we prefer to use the 'original' english versions.
But my developer edition is the german version.
Sometimes this gets funny results
And I must admit I like also the english version of SQL books more. The translators seem to try to translate everything into german.
Even technical terms that shouldn't be translated at all.
From a coworker I borrowed the german version of Inside SQL Server 2000. After a week I gave it back, because I found it hard to follow what is explained there. From my $100 gift from this site (thanks again
!) I bought the english version of the book. I'm feeling much more confident with it.Another side-effect from posting to this forum, is that I try to talk to our IT staff about SQL Server using english terms. Sometimes I don't even know their german equivalent.
Frank
Edited by - Frank Kalis on 10/29/2003 03:35:58 AM
Edited by - Frank Kalis on 10/29/2003 03:36:25 AM
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Laughing, yes, Frank. We exist in several languages. Most of my servers are English (default) but I had a couple of my developers install the French version.
Just looking at the error messages can make me smile.
Bonne chance
Dr. Peter Venkman: Generally you don't see that kind of behavior in a major appliance.
Patrick
Quand on parle du loup, on en voit la queue
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply