polling interval

How do I disable polling interval for one server in a
group in Enterprise Manager. tnxright click on the server name, click on Edit sql server
registration properties, uncheck Display sql server state
in concole.
>--Original Message--
>How do I disable polling interval for one server in a
>group in Enterprise Manager. tnx
>.
>

PLS HELP: Database is marked as (loading) after restore

Hi,
We just restored a database to SQL Server 2000 and now if i go to
Enterprise Manager i see that database with "(loading)" on the right.
When i click on expnand sign, i see "No Items"?
When i try to see it's properties i get this message:
"Error 927: Database "DBName" can not be opened. It is in the middle of
a restore."
But how come - i've seen the restore finished successfully.
Any ideas?
Thank you,
MuZZy
Try:
restore database MyDB with recovery
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"MuZZy" <tnr@.newsgroups.nospam> wrote in message
news:uzB73n8DGHA.3528@.TK2MSFTNGP12.phx.gbl...
Hi,
We just restored a database to SQL Server 2000 and now if i go to
Enterprise Manager i see that database with "(loading)" on the right.
When i click on expnand sign, i see "No Items"?
When i try to see it's properties i get this message:
"Error 927: Database "DBName" can not be opened. It is in the middle of
a restore."
But how come - i've seen the restore finished successfully.
Any ideas?
Thank you,
MuZZy
|||Hi MuZZy
What do you mean that you have 'seen the restore finished successfully'?
Does that mean you were able to use the database after the restore?
It's possible you ran the restore with NORECOVERY.
Try using Query Analyzer and recovering the database:
RESTORE DATABASE DBName WITH RECOVERY
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"MuZZy" <tnr@.newsgroups.nospam> wrote in message
news:uzB73n8DGHA.3528@.TK2MSFTNGP12.phx.gbl...
> Hi,
> We just restored a database to SQL Server 2000 and now if i go to
> Enterprise Manager i see that database with "(loading)" on the right. When
> i click on expnand sign, i see "No Items"?
> When i try to see it's properties i get this message:
> "Error 927: Database "DBName" can not be opened. It is in the middle of a
> restore."
> But how come - i've seen the restore finished successfully.
> Any ideas?
> Thank you,
> MuZZy
>
|||MuZZy wrote:
> Hi,
> We just restored a database to SQL Server 2000 and now if i go to
> Enterprise Manager i see that database with "(loading)" on the right.
> When i click on expnand sign, i see "No Items"?
> When i try to see it's properties i get this message:
> "Error 927: Database "DBName" can not be opened. It is in the middle of
> a restore."
> But how come - i've seen the restore finished successfully.
> Any ideas?
> Thank you,
> MuZZy
Thanks for your responses, guys. I tried that but got an error saying that database file is restored
only partially so command acn't be completed or something like that.
It seems to me that the backup file is somehow invalid, as we never had any problems with another
clients' backups ever. I'm going to ask them to send me another backup ad we'll see then
|||Perhaps you were sent a backup which didn't contain all the filesgroups for the database. That can
be on possible reason.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"MuZZy" <tnr@.newsgroups.nospam> wrote in message news:OJMT2V%23DGHA.2424@.TK2MSFTNGP10.phx.gbl...
> MuZZy wrote:
> Thanks for your responses, guys. I tried that but got an error saying that database file is
> restored only partially so command acn't be completed or something like that.
> It seems to me that the backup file is somehow invalid, as we never had any problems with another
> clients' backups ever. I'm going to ask them to send me another backup ad we'll see then
|||Hi Muzzy,
First of all, as MVP Tibor suggested, please make sure you have contained
all the filegroups for the database.
Secondly, if the database file located remotely, please copy them to local
and then try to resotre again.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

PLS HELP: Database is marked as (loading) after restore

Hi,
We just restored a database to SQL Server 2000 and now if i go to
Enterprise Manager i see that database with "(loading)" on the right.
When i click on expnand sign, i see "No Items"?
When i try to see it's properties i get this message:
"Error 927: Database "DBName" can not be opened. It is in the middle of
a restore."
But how come - i've seen the restore finished successfully.
Any ideas?
Thank you,
MuZZyTry:
restore database MyDB with recovery
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"MuZZy" <tnr@.newsgroups.nospam> wrote in message
news:uzB73n8DGHA.3528@.TK2MSFTNGP12.phx.gbl...
Hi,
We just restored a database to SQL Server 2000 and now if i go to
Enterprise Manager i see that database with "(loading)" on the right.
When i click on expnand sign, i see "No Items"?
When i try to see it's properties i get this message:
"Error 927: Database "DBName" can not be opened. It is in the middle of
a restore."
But how come - i've seen the restore finished successfully.
Any ideas?
Thank you,
MuZZy|||Hi MuZZy
What do you mean that you have 'seen the restore finished successfully'?
Does that mean you were able to use the database after the restore?
It's possible you ran the restore with NORECOVERY.
Try using Query Analyzer and recovering the database:
RESTORE DATABASE DBName WITH RECOVERY
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"MuZZy" <tnr@.newsgroups.nospam> wrote in message
news:uzB73n8DGHA.3528@.TK2MSFTNGP12.phx.gbl...
> Hi,
> We just restored a database to SQL Server 2000 and now if i go to
> Enterprise Manager i see that database with "(loading)" on the right. When
> i click on expnand sign, i see "No Items"?
> When i try to see it's properties i get this message:
> "Error 927: Database "DBName" can not be opened. It is in the middle of a
> restore."
> But how come - i've seen the restore finished successfully.
> Any ideas?
> Thank you,
> MuZZy
>|||MuZZy wrote:
> Hi,
> We just restored a database to SQL Server 2000 and now if i go to
> Enterprise Manager i see that database with "(loading)" on the right.
> When i click on expnand sign, i see "No Items"?
> When i try to see it's properties i get this message:
> "Error 927: Database "DBName" can not be opened. It is in the middle of
> a restore."
> But how come - i've seen the restore finished successfully.
> Any ideas?
> Thank you,
> MuZZy
Thanks for your responses, guys. I tried that but got an error saying that d
atabase file is restored
only partially so command acn't be completed or something like that.
It seems to me that the backup file is somehow invalid, as we never had any
problems with another
clients' backups ever. I'm going to ask them to send me another backup ad we
'll see then|||Perhaps you were sent a backup which didn't contain all the filesgroups for
the database. That can
be on possible reason.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"MuZZy" <tnr@.newsgroups.nospam> wrote in message news:OJMT2V%23DGHA.2424@.TK2MSFTNGP10.phx.gb
l...
> MuZZy wrote:
> Thanks for your responses, guys. I tried that but got an error saying that
database file is
> restored only partially so command acn't be completed or something like th
at.
> It seems to me that the backup file is somehow invalid, as we never had an
y problems with another
> clients' backups ever. I'm going to ask them to send me another backup ad we'll se
e then|||Hi Muzzy,
First of all, as MVP Tibor suggested, please make sure you have contained
all the filegroups for the database.
Secondly, if the database file located remotely, please copy them to local
and then try to resotre again.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

PLS HELP: Database is marked as (loading) after restore

Hi,
We just restored a database to SQL Server 2000 and now if i go to
Enterprise Manager i see that database with "(loading)" on the right.
When i click on expnand sign, i see "No Items"?
When i try to see it's properties i get this message:
"Error 927: Database "DBName" can not be opened. It is in the middle of
a restore."
But how come - i've seen the restore finished successfully.
Any ideas?
Thank you,
MuZZyTry:
restore database MyDB with recovery
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"MuZZy" <tnr@.newsgroups.nospam> wrote in message
news:uzB73n8DGHA.3528@.TK2MSFTNGP12.phx.gbl...
Hi,
We just restored a database to SQL Server 2000 and now if i go to
Enterprise Manager i see that database with "(loading)" on the right.
When i click on expnand sign, i see "No Items"?
When i try to see it's properties i get this message:
"Error 927: Database "DBName" can not be opened. It is in the middle of
a restore."
But how come - i've seen the restore finished successfully.
Any ideas?
Thank you,
MuZZy|||Hi MuZZy
What do you mean that you have 'seen the restore finished successfully'?
Does that mean you were able to use the database after the restore?
It's possible you ran the restore with NORECOVERY.
Try using Query Analyzer and recovering the database:
RESTORE DATABASE DBName WITH RECOVERY
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"MuZZy" <tnr@.newsgroups.nospam> wrote in message
news:uzB73n8DGHA.3528@.TK2MSFTNGP12.phx.gbl...
> Hi,
> We just restored a database to SQL Server 2000 and now if i go to
> Enterprise Manager i see that database with "(loading)" on the right. When
> i click on expnand sign, i see "No Items"?
> When i try to see it's properties i get this message:
> "Error 927: Database "DBName" can not be opened. It is in the middle of a
> restore."
> But how come - i've seen the restore finished successfully.
> Any ideas?
> Thank you,
> MuZZy
>|||MuZZy wrote:
> Hi,
> We just restored a database to SQL Server 2000 and now if i go to
> Enterprise Manager i see that database with "(loading)" on the right.
> When i click on expnand sign, i see "No Items"?
> When i try to see it's properties i get this message:
> "Error 927: Database "DBName" can not be opened. It is in the middle of
> a restore."
> But how come - i've seen the restore finished successfully.
> Any ideas?
> Thank you,
> MuZZy
Thanks for your responses, guys. I tried that but got an error saying that database file is restored
only partially so command acn't be completed or something like that.
It seems to me that the backup file is somehow invalid, as we never had any problems with another
clients' backups ever. I'm going to ask them to send me another backup ad we'll see then|||Perhaps you were sent a backup which didn't contain all the filesgroups for the database. That can
be on possible reason.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"MuZZy" <tnr@.newsgroups.nospam> wrote in message news:OJMT2V%23DGHA.2424@.TK2MSFTNGP10.phx.gbl...
> MuZZy wrote:
>> Hi,
>> We just restored a database to SQL Server 2000 and now if i go to Enterprise Manager i see that
>> database with "(loading)" on the right. When i click on expnand sign, i see "No Items"?
>> When i try to see it's properties i get this message:
>> "Error 927: Database "DBName" can not be opened. It is in the middle of a restore."
>> But how come - i've seen the restore finished successfully.
>> Any ideas?
>> Thank you,
>> MuZZy
> Thanks for your responses, guys. I tried that but got an error saying that database file is
> restored only partially so command acn't be completed or something like that.
> It seems to me that the backup file is somehow invalid, as we never had any problems with another
> clients' backups ever. I'm going to ask them to send me another backup ad we'll see then|||Hi Muzzy,
First of all, as MVP Tibor suggested, please make sure you have contained
all the filegroups for the database.
Secondly, if the database file located remotely, please copy them to local
and then try to resotre again.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Plot Table Relationships

Hello,

I am looking to print the table structure of a Microsoft SQL Server 7 database through the Enterprise Manager Utility. I would like to print it to a plotter but the print options in the Enterprise Manager are inadequate. I believe I will need to use another program to manipulate the object prior to plot due to its size. I have the following tools available:

VB6
Autocad
(Do not have Adobe Writer)

Is there a way to get this print object to Autocad or even as a bitmap?

Thanks is advance,
bdsDo you have MSAccess?|||Originally posted by SimSoph
Do you have MSAccess?

Yes...I do.

Thanks,
bds|||You can also do it through Visio|||Thanks for the tips. I asked around and we have a trial version of Visio which should do the trick.

I got desperate the other day and started to write a small SQL script to query the information and dump it to a HTML file using 'sp_makewebtask'.

Please! Help me.

When I open SQL Server 2000( Enterprise Manager). I face on the problem:
"Microsoft Management Console:mmc.exe - Application Error".
I don't instal SQL Server 2000 again. How can I do it?
Please, help me! Thank!Hi
Re-apply SQL Server 2000 SP3a onto the machine. If that does not solve it,
apply the latest Windows SP on you machine. mmc is a windows application and
SQL server just uses it for EM.
Regards
Mike
"hvan2203" wrote:

> When I open SQL Server 2000( Enterprise Manager). I face on the problem:
> "Microsoft Management Console:mmc.exe - Application Error".
> I don't instal SQL Server 2000 again. How can I do it?
> Please, help me! Thank!
>|||Thank you!
You send for me "SQL Server 2000 SP3a". I need it, I try it
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Re-apply SQL Server 2000 SP3a onto the machine. If that does not solve it,
> apply the latest Windows SP on you machine. mmc is a windows application a
nd
> SQL server just uses it for EM.
> Regards
> Mike
> "hvan2203" wrote:
>|||Download it here:
http://www.microsoft.com/sql/downloads/2000/sp3.asp
David Portas
SQL Server MVP
--

Please setup information of sql server database on web server

I have create database name and userid and password and now i want to create tables on sql server through enterprise manager. I have problem to connect registration.

Check the instructional videos on this site:

http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx#1

|||Unless you do not post your exact error you get here, we won′t be able to help you, if you are new to SQL Server and need rampup assitance you should stick to the link Arnie posted above.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Please Help! Service Pack update Cannot Verify User with SA login

I have SQL 2000 that has Service Pack 3 installed. So I installed Analysis
Services & Manager,Decision Service Objects and Client Components. Afterwards
I tried to run the update that MS put out for Analysis Services and in the
install you have two options: Use user logged on authentication or use SQL
authentication and provide the SA password. I do this and it always says it
could not verify user even though I have even changed the password and know
that it is correct. I am running SQL in Mixed Mode Authentication if this
makes a difference?
Also, Service Pack 3 was already installed on this server for SQL, But
Analysis Services and Manager was not. So I installed them. So Do I still
need to run the update. There are 3 different files for updateing SQL. 1.
Database Components
2. Analysis Services
3. Desktop Engine
But I get the error that I mentioned when I run the analysis update!
"Jay" wrote:

> I have SQL 2000 that has Service Pack 3 installed. So I installed Analysis
> Services & Manager,Decision Service Objects and Client Components. Afterwards
> I tried to run the update that MS put out for Analysis Services and in the
> install you have two options: Use user logged on authentication or use SQL
> authentication and provide the SA password. I do this and it always says it
> could not verify user even though I have even changed the password and know
> that it is correct. I am running SQL in Mixed Mode Authentication if this
> makes a difference?

Please Help! Service Pack update Cannot Verify User with SA login

I have SQL 2000 that has Service Pack 3 installed. So I installed Analysis
Services & Manager,Decision Service Objects and Client Components. Afterward
s
I tried to run the update that MS put out for Analysis Services and in the
install you have two options: Use user logged on authentication or use SQL
authentication and provide the SA password. I do this and it always says it
could not verify user even though I have even changed the password and know
that it is correct. I am running SQL in Mixed Mode Authentication if this
makes a difference?Also, Service Pack 3 was already installed on this server for SQL, But
Analysis Services and Manager was not. So I installed them. So Do I still
need to run the update. There are 3 different files for updateing SQL. 1.
Database Components
2. Analysis Services
3. Desktop Engine
But I get the error that I mentioned when I run the analysis update!
"Jay" wrote:

> I have SQL 2000 that has Service Pack 3 installed. So I installed Analysis
> Services & Manager,Decision Service Objects and Client Components. Afterwa
rds
> I tried to run the update that MS put out for Analysis Services and in the
> install you have two options: Use user logged on authentication or use SQL
> authentication and provide the SA password. I do this and it always says i
t
> could not verify user even though I have even changed the password and kno
w
> that it is correct. I am running SQL in Mixed Mode Authentication if this
> makes a difference?

Please Help! Service Pack update Cannot Verify User with SA login

I have SQL 2000 that has Service Pack 3 installed. So I installed Analysis
Services & Manager,Decision Service Objects and Client Components. Afterwards
I tried to run the update that MS put out for Analysis Services and in the
install you have two options: Use user logged on authentication or use SQL
authentication and provide the SA password. I do this and it always says it
could not verify user even though I have even changed the password and know
that it is correct. I am running SQL in Mixed Mode Authentication if this
makes a difference?Also, Service Pack 3 was already installed on this server for SQL, But
Analysis Services and Manager was not. So I installed them. So Do I still
need to run the update. There are 3 different files for updateing SQL. 1.
Database Components
2. Analysis Services
3. Desktop Engine
But I get the error that I mentioned when I run the analysis update!
"Jay" wrote:
> I have SQL 2000 that has Service Pack 3 installed. So I installed Analysis
> Services & Manager,Decision Service Objects and Client Components. Afterwards
> I tried to run the update that MS put out for Analysis Services and in the
> install you have two options: Use user logged on authentication or use SQL
> authentication and provide the SA password. I do this and it always says it
> could not verify user even though I have even changed the password and know
> that it is correct. I am running SQL in Mixed Mode Authentication if this
> makes a difference?