Hidden Master, Model, MSDB, and Tempdb Databases.

Thanks in advance.
I have an instance of Enterprise Manager for SQL Server 2000 on my
desktop that does not list the above databases. When I attempt to add
any of them, I receive: "Error 5123: CREATE FILE encountered operating
system error 32.". I see all the databases in the server's copy of EM.
My questions are twofold. What is the likely reason my workstation
copy of EM got this way? How do I best fix this? I suspect I may have
to wait for no users to be on the system, but I hope someone knows a
way to fix this without doing so. Also the TempDB does not appear as
an mdf file, which I guess is because it is a temporary construct that
exists in memory only. So I do not even being to know how to make that
appear in my list.
Mark Simmerman
SQL Learner
Napa, CaliforniaRight-click on the Server, select 'Edit SQL Server Registration properties
and make sure 'show system databases and system objects' is checked.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mark" <xxxdbaxxx@.gmail.com> wrote in message
news:1148081170.238568.164540@.38g2000cwa.googlegroups.com...
> Thanks in advance.
> I have an instance of Enterprise Manager for SQL Server 2000 on my
> desktop that does not list the above databases. When I attempt to add
> any of them, I receive: "Error 5123: CREATE FILE encountered operating
> system error 32.". I see all the databases in the server's copy of EM.
>
> My questions are twofold. What is the likely reason my workstation
> copy of EM got this way? How do I best fix this? I suspect I may have
> to wait for no users to be on the system, but I hope someone knows a
> way to fix this without doing so. Also the TempDB does not appear as
> an mdf file, which I guess is because it is a temporary construct that
> exists in memory only. So I do not even being to know how to make that
> appear in my list.
>
> Mark Simmerman
> SQL Learner
> Napa, California
>|||Except for MSDB, those system databases MUST exist on your server, so trying
to 'add' them is pointless. They're already there which is why you're
getting the message you reported.
I presume you also have Query Analyzer, so you could run a query:
exec sp_helpdb
and you should see the system databases listed with all the others.
Right click on the name of your server (or LOCAL) in Enterprise Manager.
Choose 'Edit SQL Server Registration Properties'
Check the box near the button of the dialog box that says 'Show system
databases and system objects'
Click OK
Now when you expand your Databases node in Enterprise Manager, you should
see the system databases.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Mark" <xxxdbaxxx@.gmail.com> wrote in message
news:1148081170.238568.164540@.38g2000cwa.googlegroups.com...
> Thanks in advance.
> I have an instance of Enterprise Manager for SQL Server 2000 on my
> desktop that does not list the above databases. When I attempt to add
> any of them, I receive: "Error 5123: CREATE FILE encountered operating
> system error 32.". I see all the databases in the server's copy of EM.
>
> My questions are twofold. What is the likely reason my workstation
> copy of EM got this way? How do I best fix this? I suspect I may have
> to wait for no users to be on the system, but I hope someone knows a
> way to fix this without doing so. Also the TempDB does not appear as
> an mdf file, which I guess is because it is a temporary construct that
> exists in memory only. So I do not even being to know how to make that
> appear in my list.
>
> Mark Simmerman
> SQL Learner
> Napa, California
>|||That was sooooo simple. Thanks, Kalen and Dan.

Help-Forecasting Model Viewer

Hi,
I am working in Share point service now.

I created a website using share point.
I worked in mining algorithms in sqlserevr 2005.
I am able to view scorecard, BIP in my website.

My Question is:
I am having a forecasting model developed using Time series algorithm in Sqlserver 2005.
I need viewer to view my forecasting model, I created.
Plz suggest me any viewer like DataAnalyzer, to view my forecasting model.
Tx in Advance!

Was your question answered in the newsgorup, or do you still need more information?

Realistically you can use any charting control and simply query the model for the data if the redistributable viewers don't work for you.

|||

Hai,

I used pivot table OWC to show my data.

Unfortunately, it doenot work with DMX query.

But spreadsheet OWC accepts DMX query. why not pivot table?

I need some solution to run my DMX query and give as input to my chart/pivot control.

plz help me.

its urgent

Tx in advance.

|||You will have to write some custom Excel code (you can find samples on sqlserverdatamining.com) to execute the DMX query and put it in a worksheet. Then you can put the result into an Excel pivot table

Help-Forecasting Model Viewer

Hi,
I am working in Share point service now.

I created a website using share point.
I worked in mining algorithms in sqlserevr 2005.
I am able to view scorecard, BIP in my website.

My Question is:
I am having a forecasting model developed using Time series algorithm in Sqlserver 2005.
I need viewer to view my forecasting model, I created.
Plz suggest me any viewer like DataAnalyzer, to view my forecasting model.
Tx in Advance!

Was your question answered in the newsgorup, or do you still need more information?

Realistically you can use any charting control and simply query the model for the data if the redistributable viewers don't work for you.

|||

Hai,

I used pivot table OWC to show my data.

Unfortunately, it doenot work with DMX query.

But spreadsheet OWC accepts DMX query. why not pivot table?

I need some solution to run my DMX query and give as input to my chart/pivot control.

plz help me.

its urgent

Tx in advance.

|||You will have to write some custom Excel code (you can find samples on sqlserverdatamining.com) to execute the DMX query and put it in a worksheet. Then you can put the result into an Excel pivot table