Re: Edit System Stored Procedure, i.e. sp_helpdb
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 08/26/04
- Next message: Aaron [SQL Server MVP]: "Re: Install SP3a"
- Previous message: Katherine: "Transliteration failed exception writing a large Java Unicode char"
- In reply to: NRS: "Re: Edit System Stored Procedure, i.e. sp_helpdb"
- Next in thread: David G.: "Re: Edit System Stored Procedure, i.e. sp_helpdb"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Aug 2004 19:25:34 +0200
Perhaps that bug only show itself if you have an owner of a database that doesn't exist in syslogins?
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "NRS" <NRS@discussions.microsoft.com> wrote in message news:41773F80-647D-4E34-A26E-BF3ACA652F89@microsoft.com... > I know it's strange and I have the same thought as you. > I am asking this question because of one colleague that does not know SQL > Server. > So I talk with her right know to know exactly the problem, and she show me a > email from technical support of Scala where they explain: > > The Installation wizard uses a Stored Procedure on the SQL server called > sp_helpdb that retrieves information on the iScala databases. Information > like Collation/sortorder etc. Sometimes the Stored Procedure retrieves null > values instead of real values which causes the Stored Procedure itself to > crash. (Microsoft Bug). > > Workaround: > - Open the Enterprise Manager (SQL). > - Select Databases = Master > - Select Stored Procedures > - Doubleklick the storedprocedure named "sp_helpdb" > - Change the line that begins with: > ****************************** > create table #spdbdesc > ( > dbname sysname, > owner sysname, > created nvarchar(11), > dbid smallint, > dbdesc nvarchar(600) null, > dbsize nvarchar(13) null, > cmptlevel tinyint > ) > ****************************** > > Change to: > ****************************** > create table #spdbdesc > ( > dbname sysname, > owner sysname null, > created nvarchar(11), > dbid smallint, > dbdesc nvarchar(600) null, > dbsize nvarchar(13) null, > cmptlevel tinyint > ) > ****************************** > > The oly diference is in this line > owner sysname null, > where they add null. > > I really don't beleave it, that is a MS Bug like they say. I beleave if it > was a bug it as already been corrected (it's too simple and someone should > found after the release of SQL 2000). > As a matter of fact, I went checking the Server to see if have the latest > service pack, because if was a bug i think that sould be resolved in SP of > SQL, but she got the SP3. > I have to check with Scala this question again. > Thanks > NRS > > "Tibor Karaszi" wrote: > > > It is not supported by MS to change the source code in SQL Server. Are you *really* sure that you want an > > unsupported SQL Server installation. What about other code (Enterprise Manager, Query Analyzer etc etc) that > > might use sp_helpdb? > > > > -- > > Tibor Karaszi, SQL Server MVP > > http://www.karaszi.com/sqlserver/default.asp > > http://www.solidqualitylearning.com/ > > > > > > "NRS" <NRS@discussions.microsoft.com> wrote in message > > news:21FA6250-6782-4368-9895-D7ED2A042421@microsoft.com... > > > That's one of the solutions, but not for my problem, because I need to call > > > it sp_helpdb, I have one call from one application to that stored procedure > > > that needs to be changed. So if I create a new one with my modifications it > > > won't work because i don't have the source code of the apllication to change > > > the call to the stored procedure. > > > > > > Thanks, > > > NRS > > > > > >
- Next message: Aaron [SQL Server MVP]: "Re: Install SP3a"
- Previous message: Katherine: "Transliteration failed exception writing a large Java Unicode char"
- In reply to: NRS: "Re: Edit System Stored Procedure, i.e. sp_helpdb"
- Next in thread: David G.: "Re: Edit System Stored Procedure, i.e. sp_helpdb"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
