Enterprise Manager table property consistency

I have one table in my SQL server 2000 (w2k server up to date service packs) where when I right click 'properties' of the table in Enterprise Manager I get 13316 records. But if I open the table in enterprise manager and SELECT count(*) I get 13315 recor
ds. However, using the same table in Query Analyzer, Select count(*) results in 13315 records and Select *
results in 13315 rows showing in the lower right of the Query pane.
It seems to be occuring in just this one table using Enterprise Manager.
Probably no big deal. Anyone know what may be causing this?
TIA
Ken,
Refer DBCC UPDATEUSAGE in BooksOnLine.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:53400F61-A8C3-4423-BCCA-B14A84E7FDBD@.microsoft.com...
> I have one table in my SQL server 2000 (w2k server up to date service
packs) where when I right click 'properties' of the table in Enterprise
Manager I get 13316 records. But if I open the table in enterprise manager
and SELECT count(*) I get 13315 records. However, using the same table in
Query Analyzer, Select count(*) results in 13315 records and Select *
> results in 13315 rows showing in the lower right of the Query pane.
> It seems to be occuring in just this one table using Enterprise Manager.
> Probably no big deal. Anyone know what may be causing this?
> TIA
|||In addition to Dinesh's response, both counts and table/index sizes are
numbers that are NOT updated for each insert, update or delete. They are
periodically updated, so they will be close most of the time , but not
exact...
The command that Dinesh showed you will update the information.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:53400F61-A8C3-4423-BCCA-B14A84E7FDBD@.microsoft.com...
> I have one table in my SQL server 2000 (w2k server up to date service
packs) where when I right click 'properties' of the table in Enterprise
Manager I get 13316 records. But if I open the table in enterprise manager
and SELECT count(*) I get 13315 records. However, using the same table in
Query Analyzer, Select count(*) results in 13315 records and Select *
> results in 13315 rows showing in the lower right of the Query pane.
> It seems to be occuring in just this one table using Enterprise Manager.
> Probably no big deal. Anyone know what may be causing this?
> TIA

Enterprise Manager table property consistency

I have one table in my SQL server 2000 (w2k server up to date service packs)
where when I right click 'properties' of the table in Enterprise Manager I
get 13316 records. But if I open the table in enterprise manager and SELECT
count(*) I get 13315 recor
ds. However, using the same table in Query Analyzer, Select count(*) result
s in 13315 records and Select *
results in 13315 rows showing in the lower right of the Query pane.
It seems to be occuring in just this one table using Enterprise Manager.
Probably no big deal. Anyone know what may be causing this?
TIAKen,
Refer DBCC UPDATEUSAGE in BooksOnLine.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:53400F61-A8C3-4423-BCCA-B14A84E7FDBD@.microsoft.com...
> I have one table in my SQL server 2000 (w2k server up to date service
packs) where when I right click 'properties' of the table in Enterprise
Manager I get 13316 records. But if I open the table in enterprise manager
and SELECT count(*) I get 13315 records. However, using the same table in
Query Analyzer, Select count(*) results in 13315 records and Select *
> results in 13315 rows showing in the lower right of the Query pane.
> It seems to be occuring in just this one table using Enterprise Manager.
> Probably no big deal. Anyone know what may be causing this?
> TIA|||In addition to Dinesh's response, both counts and table/index sizes are
numbers that are NOT updated for each insert, update or delete. They are
periodically updated, so they will be close most of the time , but not
exact...
The command that Dinesh showed you will update the information.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:53400F61-A8C3-4423-BCCA-B14A84E7FDBD@.microsoft.com...
> I have one table in my SQL server 2000 (w2k server up to date service
packs) where when I right click 'properties' of the table in Enterprise
Manager I get 13316 records. But if I open the table in enterprise manager
and SELECT count(*) I get 13315 records. However, using the same table in
Query Analyzer, Select count(*) results in 13315 records and Select *
> results in 13315 rows showing in the lower right of the Query pane.
> It seems to be occuring in just this one table using Enterprise Manager.
> Probably no big deal. Anyone know what may be causing this?
> TIAsql

Enterprise Manager table property consistency

I have one table in my SQL server 2000 (w2k server up to date service packs) where when I right click 'properties' of the table in Enterprise Manager I get 13316 records. But if I open the table in enterprise manager and SELECT count(*) I get 13315 records. However, using the same table in Query Analyzer, Select count(*) results in 13315 records and Select
results in 13315 rows showing in the lower right of the Query pane
It seems to be occuring in just this one table using Enterprise Manager
Probably no big deal. Anyone know what may be causing this
TIAKen,
Refer DBCC UPDATEUSAGE in BooksOnLine.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:53400F61-A8C3-4423-BCCA-B14A84E7FDBD@.microsoft.com...
> I have one table in my SQL server 2000 (w2k server up to date service
packs) where when I right click 'properties' of the table in Enterprise
Manager I get 13316 records. But if I open the table in enterprise manager
and SELECT count(*) I get 13315 records. However, using the same table in
Query Analyzer, Select count(*) results in 13315 records and Select *
> results in 13315 rows showing in the lower right of the Query pane.
> It seems to be occuring in just this one table using Enterprise Manager.
> Probably no big deal. Anyone know what may be causing this?
> TIA|||In addition to Dinesh's response, both counts and table/index sizes are
numbers that are NOT updated for each insert, update or delete. They are
periodically updated, so they will be close most of the time , but not
exact...
The command that Dinesh showed you will update the information.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:53400F61-A8C3-4423-BCCA-B14A84E7FDBD@.microsoft.com...
> I have one table in my SQL server 2000 (w2k server up to date service
packs) where when I right click 'properties' of the table in Enterprise
Manager I get 13316 records. But if I open the table in enterprise manager
and SELECT count(*) I get 13315 records. However, using the same table in
Query Analyzer, Select count(*) results in 13315 records and Select *
> results in 13315 rows showing in the lower right of the Query pane.
> It seems to be occuring in just this one table using Enterprise Manager.
> Probably no big deal. Anyone know what may be causing this?
> TIA

Enterprise manager query timeout

When I check the server's query timeout on the Server properties /
Connections tab in enterprise manager, it is set to 600 seconds.
Yet when I run a complicated query, it times out after 40 seconds.
The same query takes about a minute in OSQL, and succeeds there.
Is there an additional time-out that EM imposes, and can it be changed?
"Lucvdv" <replace_name@.null.net> wrote in message
news:kpjgh1lgjsqe3boeredlvn7iu5ipr3dp2k@.4ax.com...
> When I check the server's query timeout on the Server properties /
> Connections tab in enterprise manager, it is set to 600 seconds.
> Yet when I run a complicated query, it times out after 40 seconds.
> The same query takes about a minute in OSQL, and succeeds there.
> Is there an additional time-out that EM imposes, and can it be
> changed?
I believe this is a known issue. You should use Query Analyzer for all
your querying rather than going through SQL EM. This problem may have
been addressed in the recent SQL Server service pack (not sure). What SP
are you running on the client?
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||On Fri, 2 Sep 2005 10:34:38 -0400, "David Gugick"
<david.gugick-nospam@.quest.com> wrote:

> "Lucvdv" <replace_name@.null.net> wrote in message
> news:kpjgh1lgjsqe3boeredlvn7iu5ipr3dp2k@.4ax.com...
> I believe this is a known issue. You should use Query Analyzer for all
> your querying rather than going through SQL EM. This problem may have
> been addressed in the recent SQL Server service pack (not sure). What SP
> are you running on the client?
Still SP3 on server and client.
I haven't downloaded SP4 yet because it looked like the changes are mostly
intended for 64 bit systems, I decided to wait until I get it through MSDN.
I'll take your advice and use Query Analyzer.
|||First of all the query time-out setting on the connections tab is only
for remote server queries. From what I understand your running a local
query.
The problem is that EM as a client application has it's own timeout
configuration setting which I admit is rather short. Query Analyzer on
the other hand by default waits as long as it needs, so you won't get
any timeout.
M
|||On 5 Sep 2005 01:03:31 -0700, m.bohse@.quest-consultants.com wrote:

> First of all the query time-out setting on the connections tab is only
> for remote server queries. From what I understand your running a local
> query.
> The problem is that EM as a client application has it's own timeout
> configuration setting which I admit is rather short. Query Analyzer on
> the other hand by default waits as long as it needs, so you won't get
> any timeout.
I found the setting, Tools -> Options -> Advanced -> Connection settings,
the default is 0 = infinite (says online help).
Trying to override it (I set it to 600 seconds) makes no difference.
I upgraded to SP4, and it's still the same

Enterprise Manager problem : jobs and alerts flash, while Agent properties lock-up

I am having a problem with Enterprise Manager. The server is SQL
Server 2000, SP 2, with the hotfix (the server is used for an ePiphany
application, which does not support sp3).
Anyway, when you try to "double-click" a job, it flashes up once, then
disappears. The same can be said for the alerts, and it does not list
any operators (if you query sysoperators, you see all the operators).
In addition, if you try to display the SQL Agent properties,
Enterprise Manager locks up.
This problem has been narrowed down to only inflict the items under
Management>SQL Server Agent. It does not affect viewing current
activity, maint plans, backup devices, or the SQL Error log.
Their is a KB article about the same type of problem with maintenance
plans, and the fix is to alter the path for the log file of SQL Agent.
This is not possible with this problem because you cannot get to the
properties to alter the log file location for the agent.
Anybody seen this problem?
HGHumphreyYou can change the location of sql agent log file in the
registry, go to
SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent
under My Computer\HKEY_LOCAL_MACHINE
and change the file path in ErrorLogFile
Alternatively if you have another pc with Enterprise
Manager you can use it to manage your server.
hth.
>--Original Message--
>I am having a problem with Enterprise Manager. The
server is SQL
>Server 2000, SP 2, with the hotfix (the server is used
for an ePiphany
>application, which does not support sp3).
>Anyway, when you try to "double-click" a job, it flashes
up once, then
>disappears. The same can be said for the alerts, and it
does not list
>any operators (if you query sysoperators, you see all the
operators).
>In addition, if you try to display the SQL Agent
properties,
>Enterprise Manager locks up.
>This problem has been narrowed down to only inflict the
items under
>Management>SQL Server Agent. It does not affect viewing
current
>activity, maint plans, backup devices, or the SQL Error
log.
>Their is a KB article about the same type of problem with
maintenance
>plans, and the fix is to alter the path for the log file
of SQL Agent.
> This is not possible with this problem because you
cannot get to the
>properties to alter the log file location for the agent.
>Anybody seen this problem?
>HGHumphrey
>.
>|||That does not work either. Any other clues?
HGHumphrey
<anonymous@.discussions.microsoft.com> wrote in message news:<ebd201c3f0b2$60ca6e30$a601280a@.phx.gbl>...
> You can change the location of sql agent log file in the
> registry, go to
> SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent
> under My Computer\HKEY_LOCAL_MACHINE
> and change the file path in ErrorLogFile
> Alternatively if you have another pc with Enterprise
> Manager you can use it to manage your server.
> hth.
>
> >--Original Message--
> >I am having a problem with Enterprise Manager. The
> server is SQL
> >Server 2000, SP 2, with the hotfix (the server is used
> for an ePiphany
> >application, which does not support sp3).
> >
> >Anyway, when you try to "double-click" a job, it flashes
> up once, then
> >disappears. The same can be said for the alerts, and it
> does not list
> >any operators (if you query sysoperators, you see all the
> operators).
> >In addition, if you try to display the SQL Agent
> properties,
> >Enterprise Manager locks up.
> >
> >This problem has been narrowed down to only inflict the
> items under
> >Management>SQL Server Agent. It does not affect viewing
> current
> >activity, maint plans, backup devices, or the SQL Error
> log.
> >
> >Their is a KB article about the same type of problem with
> maintenance
> >plans, and the fix is to alter the path for the log file
> of SQL Agent.
> > This is not possible with this problem because you
> cannot get to the
> >properties to alter the log file location for the agent.
> >
> >Anybody seen this problem?
> >
> >HGHumphrey
> >.
> >|||This has been fixed. It was because we had an entry in the
Sysoperators table that was blank. Once this was deleted, and the
services were restarted, it was fine.
Thanks,
HGHumphrey
hhumphrey@.hrblock.com (HGHumphrey) wrote in message news:<188b70ac.0402101354.6b1ffbcb@.posting.google.com>...
> I am having a problem with Enterprise Manager. The server is SQL
> Server 2000, SP 2, with the hotfix (the server is used for an ePiphany
> application, which does not support sp3).
> Anyway, when you try to "double-click" a job, it flashes up once, then
> disappears. The same can be said for the alerts, and it does not list
> any operators (if you query sysoperators, you see all the operators).
> In addition, if you try to display the SQL Agent properties,
> Enterprise Manager locks up.
> This problem has been narrowed down to only inflict the items under
> Management>SQL Server Agent. It does not affect viewing current
> activity, maint plans, backup devices, or the SQL Error log.
> Their is a KB article about the same type of problem with maintenance
> plans, and the fix is to alter the path for the log file of SQL Agent.
> This is not possible with this problem because you cannot get to the
> properties to alter the log file location for the agent.
> Anybody seen this problem?
> HGHumphrey

Enterprise Manager problem : jobs and alerts flash, while Agent properties lock-up

I am having a problem with Enterprise Manager. The server is SQL
Server 2000, SP 2, with the hotfix (the server is used for an ePiphany
application, which does not support sp3).
Anyway, when you try to "double-click" a job, it flashes up once, then
disappears. The same can be said for the alerts, and it does not list
any operators (if you query sysoperators, you see all the operators).
In addition, if you try to display the SQL Agent properties,
Enterprise Manager locks up.
This problem has been narrowed down to only inflict the items under
Management>SQL Server Agent. It does not affect viewing current
activity, maint plans, backup devices, or the SQL Error log.
Their is a KB article about the same type of problem with maintenance
plans, and the fix is to alter the path for the log file of SQL Agent.
This is not possible with this problem because you cannot get to the
properties to alter the log file location for the agent.
Anybody seen this problem?
HGHumphreyThis has been fixed. It was because we had an entry in the
Sysoperators table that was blank. Once this was deleted, and the
services were restarted, it was fine.
Thanks,
HGHumphrey
hhumphrey@.hrblock.com (HGHumphrey) wrote in message news:<188b70ac.0402101354.6b1ffbcb@.p
osting.google.com>...
> I am having a problem with Enterprise Manager. The server is SQL
> Server 2000, SP 2, with the hotfix (the server is used for an ePiphany
> application, which does not support sp3).
> Anyway, when you try to "double-click" a job, it flashes up once, then
> disappears. The same can be said for the alerts, and it does not list
> any operators (if you query sysoperators, you see all the operators).
> In addition, if you try to display the SQL Agent properties,
> Enterprise Manager locks up.
> This problem has been narrowed down to only inflict the items under
> Management>SQL Server Agent. It does not affect viewing current
> activity, maint plans, backup devices, or the SQL Error log.
> Their is a KB article about the same type of problem with maintenance
> plans, and the fix is to alter the path for the log file of SQL Agent.
> This is not possible with this problem because you cannot get to the
> properties to alter the log file location for the agent.
> Anybody seen this problem?
> HGHumphrey

Enterprise Manager Hangs trying to show TEMPDB properties

Hi there -

I am trying to look at TEMPDB properties in Enterprise Manager but it just hangs forever. I can look at props for all other databases on that server OK. The server is working OK but users reporting performance problems.

Also, how to increase the size of TEMPDB in T-SQL - I can see it is approx 200MB plus 300MB for the transaction log at the moment.

(Microsoft Windows 2003 Std Edition SP1, SQL Server 2000 Std Edition SP3)

Thanks for helping,

Michael

Hi Michael,

Are you trying to use Enterprise Manager on the database server, it is probably a busy box.

You can increase the size of the tempdb by using the the alter database comand.

Code Snippet

ALTER DATABASE TEMPDB MODIFY FILE (NAME=TEMPDEV, SIZE =1000MB)

GO

ALTER DATABASE TEMPDB MODIFY FILE (NAME=TEMPLOG, SIZE =1000MB)

GO

Jag

Enterprise manager crashing SQL Server

Hi

We're having trouble with Enterprise manager when trying to view views or table data/properties, we get an access violation error and the database crashes sometimes corrupting tables.
Ive seen some posts stating a post SP3 for SQL Server is required and some posts saying client access should be modfied.
However our enterprise manager clients are registered with SA so I dont think that is an issue.
Can anyone give me some help with this and/or direct me to the hotfix please.

Cheers

LouiseThis is the problem due to mismatched DLLs and corrupted client tools installed. Ensure to install SQL client tools from scratch.

And its better to review the task using query analyzer rather than opening from Enterprise Manager due to flaky behaviour of such GUI tools.|||thanks will give that a go and reinstall my client tools

Cheers

Enterprise Manager can't get database properties

Hi again!
On my previous question I got no answers or any help,
yet it is for me great problem.
I can't get DB properties from any DB on any
instance of three installed. EM shut itself down instead,
without any warning or error message.
I need to change some data types and collation settings.
Any help (desperately needed) would be appreciated!
Peter
Message posted via http://www.sqlmonster.com
Sounds like you might need to reregister SQL-DMO. From a command prompt run
the following and see if that helps
regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqldmo.dll"
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Peter K. via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:4ef1c47f4a7f460b9dcc1ddf45893888@.SQLMonster.c om...
> Hi again!
> On my previous question I got no answers or any help,
> yet it is for me great problem.
> I can't get DB properties from any DB on any
> instance of three installed. EM shut itself down instead,
> without any warning or error message.
> I need to change some data types and collation settings.
> Any help (desperately needed) would be appreciated!
> Peter
> --
> Message posted via http://www.sqlmonster.com
|||Hi,
I am sorry for late answer, but i've been busy lately.
Yes, I tried reregister sqldmo.dll and it helped.
But I am curious what couses that mysterious
disappearance of properties.
Thank you very much for your help!
Sincerely,
Peter
Message posted via http://www.sqlmonster.com
|||I'm not sure. I've had this myself on my home PC and can't remember doing
anything that should have affected it. Things like service packs/hotfixes
etc could do it. Generally, (re)registering sqldmo.dll seems to fix it.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Peter K. via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:689d519bd4d849318cf6cc5442345bbb@.SQLMonster.c om...
> Hi,
> I am sorry for late answer, but i've been busy lately.
> Yes, I tried reregister sqldmo.dll and it helped.
> But I am curious what couses that mysterious
> disappearance of properties.
> Thank you very much for your help!
> Sincerely,
> Peter
> --
> Message posted via http://www.sqlmonster.com

Enterprise Manager

Hi All,
When I view the database properties using Enterprise Manager, some of the databases on the server are reporting that there is zero space available while others have space available. Does anybody know why?in the database properties section go to the data files tab...over there in the location column check out what are the options available...if you say restrict file growth and if the database is full the space available will be zero.....also check whether there is any space available on the drive where the mdf file is created...might be the case that the drive is full...|||I've checked the options in the Database Properties and the option selected is unrestricted file growth. Also, the disk have enough space available on the drive where the mdf file is created. What else can it be?

enterprise manager

how sql-DBA can disable security of sqlserver registration properties.(for e
x.a user can change the password).
i want to disable sqlserver registration properties option in the console ro
ot.This is not possible. A user can always change his own password and there
is not a way to disable this.
Rand
This posting is provided "as is" with no warranties and confers no rights.