MMSQL 7.0 on MMC

Hi all,

I'm facing an inconvinience with an MSSQL 7.0 installation, regarding it's accessibility in MMC. The case is as such:

When accessing the installation instance, I can navigate wihthin the tree without problems; accessing and viewing all the database, the tables, users etc within each databse. However, when highlighting a database, when it should display a summary on the right panel, it instead displays "an error occurred when trying to access the database information". Note that the puzzling thing is that accessing the database tables, users, rules etc is perfectly fine, and there is no problem with the application using the database either, in terms of accessing it.

There are also no error logged under Applications in the Event Viewer.

If you must know, an MSDE as been installed into the same machine after the MSSQL 7.0 installation.

I have not been able to find any resources on fixing this, and would appreciate if anyone can help on this matter.

Thanks.

Hi all,

Some progress report, and updates on what I've tried so far...

I've been searching and comparing this faulty MMC with a working one, and everything (setting wise) seem to be in order. I've checked registry settings, and config.ini files in the MSSQL directory, they look the same. I've even tried replacing the MSSQLServer.msc file in hopes that it was corrupted. Nothing.

I've also tried registering said MSDE into the MMC. The result? The same problem. Database, user and otherwise full access without problems. Except for the summary page when I have the database highlighted and the "Access Error" is shown. There should be none, since I can still access the database tables, users, etc by simply navigating down the explorer tree.

I would like to know though, if anyone can point me to where I might be able to see the MMC log files? Does one exist? Can I activate logging somewhere? I've been unable to find it, and am quite surmised that there is no such thing, but the programmer in me feels that something is not quite right to that. There has to be some form of logging somewhere for to troubleshoot from.

Is there a known version incompatibility between SQL7.0 and MSDE? With certain MMC/OD version? Patch levels?

Would appreciate if anyone can provide new insights.

Thanks.

mixing case sensitive/insensitive instances

Does anyone know of any issues with mixing a case sensitive instance with case INsensitive instances on a cluster? Is there anything I should do or consider before adding a case-sensitive instance?
Instances are as independent from each other regarding case sensitivity and
other SQL Server settings as if they were actually running on different
machines. You can have two instances on the same machine with different
service packs for example, or a SQL Server 7 and a SQL Server 2000 instance.
Jacco Schalkwijk
SQL Server MVP
"J Jetson" <JJetson@.discussions.microsoft.com> wrote in message
news:252CAC4C-D3C9-4DFC-BCA5-84A77AE0BC3F@.microsoft.com...
> Does anyone know of any issues with mixing a case sensitive instance with
> case INsensitive instances on a cluster? Is there anything I should do or
> consider before adding a case-sensitive instance?

mixing case sensitive/insensitive instances

Does anyone know of any issues with mixing a case sensitive instance with ca
se INsensitive instances on a cluster? Is there anything I should do or cons
ider before adding a case-sensitive instance?Instances are as independent from each other regarding case sensitivity and
other SQL Server settings as if they were actually running on different
machines. You can have two instances on the same machine with different
service packs for example, or a SQL Server 7 and a SQL Server 2000 instance.
Jacco Schalkwijk
SQL Server MVP
"J Jetson" <JJetson@.discussions.microsoft.com> wrote in message
news:252CAC4C-D3C9-4DFC-BCA5-84A77AE0BC3F@.microsoft.com...
> Does anyone know of any issues with mixing a case sensitive instance with
> case INsensitive instances on a cluster? Is there anything I should do or
> consider before adding a case-sensitive instance?

mixed case

I know this is more of a front-end issue, but I need to know how to do it in
TSQL (sql 2k). I have a field that I need to convert to mixed case. The
field contains values such as "LAW OFFICES OF JOHN DOE", and I need it to
read "Law Offices Of John Doe". I'm sure with some work I could come up
with a string parser that will do this, but I'm wondering if anyone out
there has already come up with this code. If so, I'd appreciate knowing how
you accomplished this task.
Thanks in advance,
AndreI got lots of hits when I googled 'SQL Server proper case'. Here's one:
http://vyaskn.tripod.com/code/propercase.txt
Hope this helps.
Dan Guzman
SQL Server MVP
"Andre" <no@.spam.com> wrote in message
news:uaQ5mvAAGHA.4036@.TK2MSFTNGP10.phx.gbl...
>I know this is more of a front-end issue, but I need to know how to do it
>in TSQL (sql 2k). I have a field that I need to convert to mixed case.
>The field contains values such as "LAW OFFICES OF JOHN DOE", and I need it
>to read "Law Offices Of John Doe". I'm sure with some work I could come up
>with a string parser that will do this, but I'm wondering if anyone out
>there has already come up with this code. If so, I'd appreciate knowing
>how you accomplished this task.
> Thanks in advance,
> Andre
>|||using a numbers table, you can easily get this - here's one way
[note: this only considers spaces to be word separators]
create table numbers (number int primary key)
-- populate the numbers table with numbers from 1 to x, however you'd like
create function ProperCase(@.in varchar(8000)) returns varchar(8000)
as
begin
declare @.out varchar(8000)
select @.out=''
declare @.res table (ltr char(1), number int)
insert @.res
select substring(@.in, number, 1) as ltr, number
from numbers
where number<=len(@.in)
select @.out=@.out+
case when number=1
or number in (select number+1 from @.res where ltr ='') then
upper(ltr) else lower(ltr) end
from @.res order by number
return @.out
end
Andre wrote:
> I know this is more of a front-end issue, but I need to know how to do it
in
> TSQL (sql 2k). I have a field that I need to convert to mixed case. The
> field contains values such as "LAW OFFICES OF JOHN DOE", and I need it to
> read "Law Offices Of John Doe". I'm sure with some work I could come up
> with a string parser that will do this, but I'm wondering if anyone out
> there has already come up with this code. If so, I'd appreciate knowing h
ow
> you accomplished this task.
> Thanks in advance,
> Andre
>|||Hi
If you searched Google you would find multiple ways of doing this including
http://www.aspfaq.com/show.asp?id=2299
John
"Andre" wrote:

> I know this is more of a front-end issue, but I need to know how to do it
in
> TSQL (sql 2k). I have a field that I need to convert to mixed case. The
> field contains values such as "LAW OFFICES OF JOHN DOE", and I need it to
> read "Law Offices Of John Doe". I'm sure with some work I could come up
> with a string parser that will do this, but I'm wondering if anyone out
> there has already come up with this code. If so, I'd appreciate knowing h
ow
> you accomplished this task.
> Thanks in advance,
> Andre
>
>|||http://vyaskn.tripod.com/code.htm#propercase
"Andre" <no@.spam.com> wrote in message
news:uaQ5mvAAGHA.4036@.TK2MSFTNGP10.phx.gbl...
>I know this is more of a front-end issue, but I need to know how to do it
>in TSQL (sql 2k). I have a field that I need to convert to mixed case.
>The field contains values such as "LAW OFFICES OF JOHN DOE", and I need it
>to read "Law Offices Of John Doe". I'm sure with some work I could come up
>with a string parser that will do this, but I'm wondering if anyone out
>there has already come up with this code. If so, I'd appreciate knowing
>how you accomplished this task.
> Thanks in advance,
> Andre
>|||Cool, thanks. I did search Google but for mixed case, not proper case.
Thanks for all the tips/links.
Andre