by Eugene Kamashe » Sat, 10 Feb 2001 20:56:47
Syntax
From SQL Manager source code for sp_statistics:
CREATE PROCEDURE [sp_statistics]
AS
set nocount on
return
Is it joke from Microsoft?
Eugene.
by Dejan Sark » Sat, 10 Feb 2001 21:20:48
somebody must have changed it. You can check the code of the procedure in
the Instcat.sql file in the Install folder.
HTH,
Dejan Sarka
> Syntax
> From SQL Manager source code for sp_statistics:
> CREATE PROCEDURE [sp_statistics]
> AS
> set nocount on
> return
> Is it joke from Microsoft?
> Eugene.
by Eugene Kamashe » Sat, 10 Feb 2001 21:49:49
Eugene.
Quote:> Eugene,
> somebody must have changed it. You can check the code of the procedure in
> the Instcat.sql file in the Install folder.
> HTH,
> Dejan Sarka
by Tibor Karasz » Sat, 10 Feb 2001 21:56:19
The proc you are looking at is not the proper one...
Either you are looking in the wrong database, or someone has been overwriting the
proper sp_statistics. If you are looking in master, then you should reinstall (do a
search in the install directory for the procname).
--
Tibor Karaszi, SQL Server MVP
FAQ from Neil at: http://www.sqlserverfaq.com
Please reply to the newsgroup only, not by email.
> Syntax
> From SQL Manager source code for sp_statistics:
> CREATE PROCEDURE [sp_statistics]
> AS
> set nocount on
> return
> Is it joke from Microsoft?
> Eugene.
by Tibor Karasz » Sat, 10 Feb 2001 22:16:26
I guess that you'll act the same way that, for instance, MS will act if you claim aQuote:> Who gives me guaranty in regard to correct installation that
> procedure next time? Customer will not undarstand me if I ask him to do such
> things.
--
Tibor Karaszi, SQL Server MVP
FAQ from Neil at: http://www.sqlserverfaq.com
Please reply to the newsgroup only, not by email.
> Eugene.
> > Eugene,
> > somebody must have changed it. You can check the code of the procedure in
> > the Instcat.sql file in the Install folder.
> > HTH,
> > Dejan Sarka
by Rick Davi » Sat, 10 Feb 2001 22:16:05
You shouldn't need to do this. If I was you I would look at who else has the
rights to change system SP's and ask them if they changed it. It could also be
one of them is a practical joker or simply malicious.
This procedure(the altered one) simply does not exist in the install.
Rick
Thak's a lot. Of course there is quite another source code for
[sp_statistics] in the Instcat.sql. But what about deploying of my
application? Who gives me guaranty in regard to correct installation that
procedure next time? Customer will not undarstand me if I ask him to do such
things.
It's not a question to you Dejan. It's a rhetorical question.
Eugene.
> Eugene,
> somebody must have changed it. You can check the code of the procedure in
> the Instcat.sql file in the Install folder.
> HTH,
> Dejan Sarka
.
by Eugene Kamashe » Sat, 10 Feb 2001 23:11:37
by Dan Guzma » Sat, 10 Feb 2001 23:57:09
I assume the proc exists only in master?
Hope this helps.
-----------------------
SQL FAQ links (courtesy Neil Pike):
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq
-----------------------
Quote:> Believe me guys. Nobody knows about this procedure. I am a one who is
> arranging such things at the company. All others even don't know what
> system procedures are. I am confused not less than you. My first reaction
> was laugh. But now I am not laughing. Now I am thinking about magic.
> I want to be sure that our customers will not catch this problem in the
> future. Just tell me guys. Is everything ok with this procedure on your
> servers?
> Eugene.
by Eugene Kamashe » Sun, 11 Feb 2001 00:32:14
Of course I am not stupid :)Quote:> I assume the proc exists only in master?
I've checked date and time of creation. They are the same as all othersQuote:> No problem here. You might take a look at the create datetime in case
that
> provides a clue as to what may have happened.
In any case. Problem's been solved. Thank you all for participation.
Eugene.
1. string concat -- am i going mental?
any ideas why i can't get the following to work and/or
suggested workarounds?
-- 'test' - what the dillyo?
this behavior occurs w/ nchar as well. am i crazy?
appreciated,
matt
3. ado-commands -where am I going wrong ?
4. Looking for a SQL Beautifier
5. Linked Servers Help I am going crazy
7. VFP Data Grouping - am I going mad ??
8. I have a really dumb basic question.
9. ** HELP WITH vb 4.0 I am going crazy**
10. Oracle8 for SCO : Does it use shared libs - am going to put on Linux
11. ado-commands -where am I going wrong ?
12. TTables or Am I going MAD??
13. Am I going mad??