Im trying to move a database from a NT4 SQL2K server over to a WIN2K SQL2K box.
When i copy the stored procedures over via a generated script, 1 procedure fails to create itself, and the error i get is:
The text, ntext, and image data types are invalid in this subquery or aggregate
the error is supposedly the top line here:
SELECT *, 'cms_Document_Contents_ID'='', 'cms_Language_ID'='', 'Title'='', 'XML'='', 'search_text'='',
'File_XML'=(SELECT TOP 1 File_XML FROM cms_Document_Contents d
INNER JOIN cms_Document_Sections e ON d.cms_Document_Id=e.cms_Document_Id
WHERE d.cms_Language_ID=9 AND e.cms_Document_Section_ID=@.DocumentSectionId) ,
c.active, c.sequence, c.cms_Document_Section_ID, c.cms_Section_ID, c.cms_Document_Type_ID
FROM cms_Documents a
INNER JOIN cms_Document_Sections c ON a.cms_Document_ID=c.cms_Document_ID
WHERE c.cms_Document_Section_ID=@.DocumentSectionId
END
GO
wtf is going on? this works fine on the old server. i tried running it back there and it just complains that the stored procedure already exists.
i am not familiar with SQL, this is someone elses code, i dont understand the error and NEED all the help i can get.Somehow you got single quotes stuck around your column names.
Select 'cms_Document_Contents_ID'=''
...makes no sense. I assume the procedure is createing an empty column that will be populated later. Try this and see if you get the same error:
SELECT *,
cms_Document_Contents_ID='',
cms_Language_ID='',
Title='',
XML='',
search_text='',
File_XML= (SELECT TOP 1 File_XML FROM cms_Document_Contents d
INNER JOIN cms_Document_Sections e ON d.cms_Document_Id = e.cms_Document_Id WHERE d.cms_Language_ID=9 AND e.cms_Document_Section_ID=@.DocumentSectionId),
c.active,
c.sequence,
c.cms_Document_Section_ID,
c.cms_Section_ID,
c.cms_Document_Type_ID
FROM cms_Documents a
INNER JOIN cms_Document_Sections c ON a.cms_Document_ID=c.cms_Document_ID
WHERE c.cms_Document_Section_ID=@.DocumentSectionId
blindman|||Stop the SQL Server, exit the Service Manager, copy the data and log files (C:\Program Files\Microsoft SQL Server\MSSQL\Data\MyDB_Data.mdf, & C:\Program Files\Microsoft SQL Server\MSSQL\Data\MyDB_Log.ldf on my machine respectivley) to your destination server, on that machine you can import (attatch) the data and log files into SQL Server with the following command in the query analyzer (substituing MyDB and the 2 paths with your equivalents):
sp_attatch_db @.dbname = 'MyDB',
@.filename1 = 'c:\path\to\datafilename.mdf',
@.filename2 = 'c:\path\to\datafilename.mdf'
if that is successful id say your home free (refresh your database list), if not, post on this forum, they can help...
.^sUbMSg-\/.
see: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp for info on this stored procedure.
ps: f*ck that DTS export b*llocks im sticking with the raw data files.
The text, ntext, and image data types are invalid in this subquery or aggregate expression.
export copy move transfer transport duplicate mirror import mdf sql database db attach stored procedure retain keep error 2000 7 6.5 8 backup restore detatch
Showing posts with label win2k. Show all posts
Showing posts with label win2k. Show all posts
Thursday, March 29, 2012
Monday, March 19, 2012
Enterprise Manager runs slow on some computers
I have a network of WinXP SP1 machines who all connect to
SQL Server 2000 SP3 on a Win2k server. When running
enterprise manager, most of the computers take at least 4
minutes to expand the database tree. Working on databases
(retrieving properties etc) is also painfully slow. On
two computers, however, Enterprise Manager shows no
slowdown and work as I would expect. Can anyone assist me
in diagnosing the problem?I would guess that one of the snap ins on the slower machines might be
causing a problem, I had something similar happen to me only for me the
enterprise manager wouldn't open at all.
On one of the slower machines try opening the Microsoft Management Console
program (C:\windows\system32\mmc.exe) and click on file and add/remove snap
ins. CLick the Add button and then select the Microsoft SQL Enterprise
manager. Click Ok and then try to open the database tree to see if its any
quicker. If so you can then click save as and use this console file instead
of the enterprise manager. If not then I'm afraid i can;t help you.
Nick
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Check to ensure that the AutoClose properties of the databases are not set
in EM on the slow machines.
Andrew J. Kelly SQL MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Check for a file called SQL.LOG on the slow machines. If it's there and is
growing, you've got ODBC Tracing turned on.
Otherwise, run a network trace and compare the protocols being used from
the slow vs. fast.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Also, in EM, you can click on File|Options... and choose to delete the
history of changes to the console files. This can speed up performance as
well.
Jacco Schalkwijk
SQL Server MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
>I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Yes you fixed my prob-, SQL TRACING WAS TURNED ON.
I have a very fast computer and it still made E-P-M very slow alymost
unuseable... Found c:\sql.log file 2.5 GB's in size ha ha...
Turned Tracing off works very fast now. cool!
Hummm, Now to find out how it got turned on in the first place ? Who
did it did you ? why you little #&*&#?! get over here!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
SQL Server 2000 SP3 on a Win2k server. When running
enterprise manager, most of the computers take at least 4
minutes to expand the database tree. Working on databases
(retrieving properties etc) is also painfully slow. On
two computers, however, Enterprise Manager shows no
slowdown and work as I would expect. Can anyone assist me
in diagnosing the problem?I would guess that one of the snap ins on the slower machines might be
causing a problem, I had something similar happen to me only for me the
enterprise manager wouldn't open at all.
On one of the slower machines try opening the Microsoft Management Console
program (C:\windows\system32\mmc.exe) and click on file and add/remove snap
ins. CLick the Add button and then select the Microsoft SQL Enterprise
manager. Click Ok and then try to open the database tree to see if its any
quicker. If so you can then click save as and use this console file instead
of the enterprise manager. If not then I'm afraid i can;t help you.
Nick
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Check to ensure that the AutoClose properties of the databases are not set
in EM on the slow machines.
Andrew J. Kelly SQL MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Check for a file called SQL.LOG on the slow machines. If it's there and is
growing, you've got ODBC Tracing turned on.
Otherwise, run a network trace and compare the protocols being used from
the slow vs. fast.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Also, in EM, you can click on File|Options... and choose to delete the
history of changes to the console files. This can speed up performance as
well.
Jacco Schalkwijk
SQL Server MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
>I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Yes you fixed my prob-, SQL TRACING WAS TURNED ON.
I have a very fast computer and it still made E-P-M very slow alymost
unuseable... Found c:\sql.log file 2.5 GB's in size ha ha...
Turned Tracing off works very fast now. cool!
Hummm, Now to find out how it got turned on in the first place ? Who
did it did you ? why you little #&*&#?! get over here!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Enterprise Manager runs slow on some computers
I have a network of WinXP SP1 machines who all connect to
SQL Server 2000 SP3 on a Win2k server. When running
enterprise manager, most of the computers take at least 4
minutes to expand the database tree. Working on databases
(retrieving properties etc) is also painfully slow. On
two computers, however, Enterprise Manager shows no
slowdown and work as I would expect. Can anyone assist me
in diagnosing the problem?
I would guess that one of the snap ins on the slower machines might be
causing a problem, I had something similar happen to me only for me the
enterprise manager wouldn't open at all.
On one of the slower machines try opening the Microsoft Management Console
program (C:\windows\system32\mmc.exe) and click on file and add/remove snap
ins. CLick the Add button and then select the Microsoft SQL Enterprise
manager. Click Ok and then try to open the database tree to see if its any
quicker. If so you can then click save as and use this console file instead
of the enterprise manager. If not then I'm afraid i can;t help you.
Nick
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Check to ensure that the AutoClose properties of the databases are not set
in EM on the slow machines.
Andrew J. Kelly SQL MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Check for a file called SQL.LOG on the slow machines. If it's there and is
growing, you've got ODBC Tracing turned on.
Otherwise, run a network trace and compare the protocols being used from
the slow vs. fast.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Also, in EM, you can click on File|Options... and choose to delete the
history of changes to the console files. This can speed up performance as
well.
Jacco Schalkwijk
SQL Server MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
>I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Yes you fixed my prob-, SQL TRACING WAS TURNED ON.
I have a very fast computer and it still made E-P-M very slow alymost
unuseable... Found c:\sql.log file 2.5 GB's in size ha ha...
Turned Tracing off works very fast now. cool!
Hummm, Now to find out how it got turned on in the first place ? Who
did it did you ? why you little #&*&#?! get over here!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
SQL Server 2000 SP3 on a Win2k server. When running
enterprise manager, most of the computers take at least 4
minutes to expand the database tree. Working on databases
(retrieving properties etc) is also painfully slow. On
two computers, however, Enterprise Manager shows no
slowdown and work as I would expect. Can anyone assist me
in diagnosing the problem?
I would guess that one of the snap ins on the slower machines might be
causing a problem, I had something similar happen to me only for me the
enterprise manager wouldn't open at all.
On one of the slower machines try opening the Microsoft Management Console
program (C:\windows\system32\mmc.exe) and click on file and add/remove snap
ins. CLick the Add button and then select the Microsoft SQL Enterprise
manager. Click Ok and then try to open the database tree to see if its any
quicker. If so you can then click save as and use this console file instead
of the enterprise manager. If not then I'm afraid i can;t help you.
Nick
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Check to ensure that the AutoClose properties of the databases are not set
in EM on the slow machines.
Andrew J. Kelly SQL MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Check for a file called SQL.LOG on the slow machines. If it's there and is
growing, you've got ODBC Tracing turned on.
Otherwise, run a network trace and compare the protocols being used from
the slow vs. fast.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Also, in EM, you can click on File|Options... and choose to delete the
history of changes to the console files. This can speed up performance as
well.
Jacco Schalkwijk
SQL Server MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
>I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Yes you fixed my prob-, SQL TRACING WAS TURNED ON.
I have a very fast computer and it still made E-P-M very slow alymost
unuseable... Found c:\sql.log file 2.5 GB's in size ha ha...
Turned Tracing off works very fast now. cool!
Hummm, Now to find out how it got turned on in the first place ? Who
did it did you ? why you little #&*&#?! get over here!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Enterprise manager reporting Free Space
I 'm running sql server 2k, with service pak3a, Win2k with lastest service
pak. We have a database that shows as being 9gig, with 0.00 MB free when
looking at the properties of it in Enterprise manager. The hdisk where that
database resides has 45gig free, with no disk quotes. Also, the database is
set to auto grow by 10%, both the tran log and data file. I have no idea why
it's not seeing more the 0.00mb free...any thoughts or ideas would be
greatly appreciated..
-Bob
That reports the space free in the MDF file, not on the drive.
http://www.aspfaq.com/
(Reverse address to reply.)
"BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
news:BEAF570A-FE36-4BCA-8B16-A980D0621926@.microsoft.com...
> I 'm running sql server 2k, with service pak3a, Win2k with lastest service
> pak. We have a database that shows as being 9gig, with 0.00 MB free when
> looking at the properties of it in Enterprise manager. The hdisk where
that
> database resides has 45gig free, with no disk quotes. Also, the database
is
> set to auto grow by 10%, both the tran log and data file. I have no idea
why
> it's not seeing more the 0.00mb free...any thoughts or ideas would be
> greatly appreciated..
> -Bob
|||how can I increase that space...do i need to?
"Aaron [SQL Server MVP]" wrote:
> That reports the space free in the MDF file, not on the drive.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
> news:BEAF570A-FE36-4BCA-8B16-A980D0621926@.microsoft.com...
> that
> is
> why
>
>
|||If you have it set to autogrow, it will increase the space when it needs to.
http://www.aspfaq.com/
(Reverse address to reply.)
"BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
news:8C9B48B3-4737-4A2C-A21F-A7A9095154DC@.microsoft.com...[vbcol=seagreen]
> how can I increase that space...do i need to?
> "Aaron [SQL Server MVP]" wrote:
service[vbcol=seagreen]
when[vbcol=seagreen]
database[vbcol=seagreen]
idea[vbcol=seagreen]
pak. We have a database that shows as being 9gig, with 0.00 MB free when
looking at the properties of it in Enterprise manager. The hdisk where that
database resides has 45gig free, with no disk quotes. Also, the database is
set to auto grow by 10%, both the tran log and data file. I have no idea why
it's not seeing more the 0.00mb free...any thoughts or ideas would be
greatly appreciated..
-Bob
That reports the space free in the MDF file, not on the drive.
http://www.aspfaq.com/
(Reverse address to reply.)
"BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
news:BEAF570A-FE36-4BCA-8B16-A980D0621926@.microsoft.com...
> I 'm running sql server 2k, with service pak3a, Win2k with lastest service
> pak. We have a database that shows as being 9gig, with 0.00 MB free when
> looking at the properties of it in Enterprise manager. The hdisk where
that
> database resides has 45gig free, with no disk quotes. Also, the database
is
> set to auto grow by 10%, both the tran log and data file. I have no idea
why
> it's not seeing more the 0.00mb free...any thoughts or ideas would be
> greatly appreciated..
> -Bob
|||how can I increase that space...do i need to?
"Aaron [SQL Server MVP]" wrote:
> That reports the space free in the MDF file, not on the drive.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
> news:BEAF570A-FE36-4BCA-8B16-A980D0621926@.microsoft.com...
> that
> is
> why
>
>
|||If you have it set to autogrow, it will increase the space when it needs to.
http://www.aspfaq.com/
(Reverse address to reply.)
"BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
news:8C9B48B3-4737-4A2C-A21F-A7A9095154DC@.microsoft.com...[vbcol=seagreen]
> how can I increase that space...do i need to?
> "Aaron [SQL Server MVP]" wrote:
service[vbcol=seagreen]
when[vbcol=seagreen]
database[vbcol=seagreen]
idea[vbcol=seagreen]
Enterprise manager reporting Free Space
I 'm running sql server 2k, with service pak3a, Win2k with lastest service
pak. We have a database that shows as being 9gig, with 0.00 MB free when
looking at the properties of it in Enterprise manager. The hdisk where that
database resides has 45gig free, with no disk quotes. Also, the database is
set to auto grow by 10%, both the tran log and data file. I have no idea why
it's not seeing more the 0.00mb free...any thoughts or ideas would be
greatly appreciated..
-BobThat reports the space free in the MDF file, not on the drive.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
news:BEAF570A-FE36-4BCA-8B16-A980D0621926@.microsoft.com...
> I 'm running sql server 2k, with service pak3a, Win2k with lastest service
> pak. We have a database that shows as being 9gig, with 0.00 MB free when
> looking at the properties of it in Enterprise manager. The hdisk where
that
> database resides has 45gig free, with no disk quotes. Also, the database
is
> set to auto grow by 10%, both the tran log and data file. I have no idea
why
> it's not seeing more the 0.00mb free...any thoughts or ideas would be
> greatly appreciated..
> -Bob|||how can I increase that space...do i need to?
"Aaron [SQL Server MVP]" wrote:
> That reports the space free in the MDF file, not on the drive.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
> news:BEAF570A-FE36-4BCA-8B16-A980D0621926@.microsoft.com...
> > I 'm running sql server 2k, with service pak3a, Win2k with lastest service
> > pak. We have a database that shows as being 9gig, with 0.00 MB free when
> > looking at the properties of it in Enterprise manager. The hdisk where
> that
> > database resides has 45gig free, with no disk quotes. Also, the database
> is
> > set to auto grow by 10%, both the tran log and data file. I have no idea
> why
> > it's not seeing more the 0.00mb free...any thoughts or ideas would be
> > greatly appreciated..
> >
> > -Bob
>
>|||If you have it set to autogrow, it will increase the space when it needs to.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
news:8C9B48B3-4737-4A2C-A21F-A7A9095154DC@.microsoft.com...
> how can I increase that space...do i need to?
> "Aaron [SQL Server MVP]" wrote:
> > That reports the space free in the MDF file, not on the drive.
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
> >
> >
> > "BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
> > news:BEAF570A-FE36-4BCA-8B16-A980D0621926@.microsoft.com...
> > > I 'm running sql server 2k, with service pak3a, Win2k with lastest
service
> > > pak. We have a database that shows as being 9gig, with 0.00 MB free
when
> > > looking at the properties of it in Enterprise manager. The hdisk where
> > that
> > > database resides has 45gig free, with no disk quotes. Also, the
database
> > is
> > > set to auto grow by 10%, both the tran log and data file. I have no
idea
> > why
> > > it's not seeing more the 0.00mb free...any thoughts or ideas would be
> > > greatly appreciated..
> > >
> > > -Bob
> >
> >
> >
pak. We have a database that shows as being 9gig, with 0.00 MB free when
looking at the properties of it in Enterprise manager. The hdisk where that
database resides has 45gig free, with no disk quotes. Also, the database is
set to auto grow by 10%, both the tran log and data file. I have no idea why
it's not seeing more the 0.00mb free...any thoughts or ideas would be
greatly appreciated..
-BobThat reports the space free in the MDF file, not on the drive.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
news:BEAF570A-FE36-4BCA-8B16-A980D0621926@.microsoft.com...
> I 'm running sql server 2k, with service pak3a, Win2k with lastest service
> pak. We have a database that shows as being 9gig, with 0.00 MB free when
> looking at the properties of it in Enterprise manager. The hdisk where
that
> database resides has 45gig free, with no disk quotes. Also, the database
is
> set to auto grow by 10%, both the tran log and data file. I have no idea
why
> it's not seeing more the 0.00mb free...any thoughts or ideas would be
> greatly appreciated..
> -Bob|||how can I increase that space...do i need to?
"Aaron [SQL Server MVP]" wrote:
> That reports the space free in the MDF file, not on the drive.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
> news:BEAF570A-FE36-4BCA-8B16-A980D0621926@.microsoft.com...
> > I 'm running sql server 2k, with service pak3a, Win2k with lastest service
> > pak. We have a database that shows as being 9gig, with 0.00 MB free when
> > looking at the properties of it in Enterprise manager. The hdisk where
> that
> > database resides has 45gig free, with no disk quotes. Also, the database
> is
> > set to auto grow by 10%, both the tran log and data file. I have no idea
> why
> > it's not seeing more the 0.00mb free...any thoughts or ideas would be
> > greatly appreciated..
> >
> > -Bob
>
>|||If you have it set to autogrow, it will increase the space when it needs to.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
news:8C9B48B3-4737-4A2C-A21F-A7A9095154DC@.microsoft.com...
> how can I increase that space...do i need to?
> "Aaron [SQL Server MVP]" wrote:
> > That reports the space free in the MDF file, not on the drive.
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
> >
> >
> > "BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
> > news:BEAF570A-FE36-4BCA-8B16-A980D0621926@.microsoft.com...
> > > I 'm running sql server 2k, with service pak3a, Win2k with lastest
service
> > > pak. We have a database that shows as being 9gig, with 0.00 MB free
when
> > > looking at the properties of it in Enterprise manager. The hdisk where
> > that
> > > database resides has 45gig free, with no disk quotes. Also, the
database
> > is
> > > set to auto grow by 10%, both the tran log and data file. I have no
idea
> > why
> > > it's not seeing more the 0.00mb free...any thoughts or ideas would be
> > > greatly appreciated..
> > >
> > > -Bob
> >
> >
> >
Sunday, February 26, 2012
Enterprise Manager Databases folder shows "No items"
We're running a Win2k Adv Server MS Cluster using two servers with SQL
instances called SQL1 and SQL2 running on them. For some reason, we can't
manage SQL2 via Enterprise Manager recently since the databases folder is now
empty. The databases are there and I can see them via Query Analyzer, but I
just can't manage them via EM. "Management" folder is also empty, but if I
refresh (over and over) I sometimes can access the "SQL Server Agent" items.
Only changes that were made to the servers was to install some security
patches, but none that related to SQL server. Other SQL servers with the
same patches work fine. SQL1 instance can be managed with EM just fine.
I suspect something is wrong with SQL2 instance, but don't know what. It's
not related to the servers since I can move the instance between cluster
nodes and EM still cannot see databases on SQL2. SQL1 moves between nodes
fine and it's databases can be seen via EM.
Not sure if this is a clue, but when I right click on "Databases" and select
"New database", I get this error:
Microsoft SQL-DMO (ODBC SQLState: 22003)
Error 220: Arithmetic overflow error for that data type smallint, value=32826.
Arithmetic overflow error for data type smallint, value=32826.
The statement has been terminated.
I click OK, then I get the standard database properties dialog to create a
database...
Thanks in advance to any help or suggestions.
Regards,
-Daniel
My guess is a problem with DMO. Perhaps re-applying the SQL Server service pack will fix it?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Daniel" <Daniel@.tamc@.discussions.microsoft.com> wrote in message
news:0CB90BA3-08E0-4FA4-9177-6942CDC083BE@.microsoft.com...
> We're running a Win2k Adv Server MS Cluster using two servers with SQL
> instances called SQL1 and SQL2 running on them. For some reason, we can't
> manage SQL2 via Enterprise Manager recently since the databases folder is now
> empty. The databases are there and I can see them via Query Analyzer, but I
> just can't manage them via EM. "Management" folder is also empty, but if I
> refresh (over and over) I sometimes can access the "SQL Server Agent" items.
> Only changes that were made to the servers was to install some security
> patches, but none that related to SQL server. Other SQL servers with the
> same patches work fine. SQL1 instance can be managed with EM just fine.
> I suspect something is wrong with SQL2 instance, but don't know what. It's
> not related to the servers since I can move the instance between cluster
> nodes and EM still cannot see databases on SQL2. SQL1 moves between nodes
> fine and it's databases can be seen via EM.
> Not sure if this is a clue, but when I right click on "Databases" and select
> "New database", I get this error:
> Microsoft SQL-DMO (ODBC SQLState: 22003)
> Error 220: Arithmetic overflow error for that data type smallint, value=32826.
> Arithmetic overflow error for data type smallint, value=32826.
> The statement has been terminated.
> I click OK, then I get the standard database properties dialog to create a
> database...
> Thanks in advance to any help or suggestions.
> Regards,
> -Daniel
>
|||I am seeing these exact symptoms. Cluster, 1 server is showing "No items" in the database folder. Please advise.
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||I just ran across this problem today, and what I had to do was drop any databases that weren't in use (offline). I hope this helps anyone else googling for this problem!
-- hbz|||for googlers
no need to drop anything - it's enough to restart that databases whose status causing overflow errors
USE master
GO
DECLARE @.db_name varchar(500)
DECLARE dbn_cursor CURSOR FOR
SELECT [name] FROM sysdatabases;
OPEN dbn_cursor
FETCH NEXT FROM dbn_cursor
INTO @.db_name
WHILE @.@.FETCH_STATUS = 0
BEGIN
select * from sysdatabases where name = @.db_name
IF @.@.ERROR <> 0
BEGIN
declare @.off int
print 'Restarting database '+@.db_name
exec @.off = sp_dboption @.db_name, 'offline', 'TRUE'
IF @.off <> 0
print 'Taking offline failed! Need manual workaround!'
else
begin
declare @.on int
exec @.on = sp_dboption @.db_name, 'offline', 'FALSE'
IF @.on <> 0
print 'Bringing online failed! Need manual workaround!'
else
print 'Restart successfull!'
end
END
FETCH NEXT FROM dbn_cursor
INTO @.db_name
END
CLOSE dbn_cursor
DEALLOCATE dbn_cursor
GO|||I had exactly the same issue, 2x clustered SQL 2000 SP3 boxen, "no items" in
EM DB view, should be 50 or so. Failed over to other node, still no joy.
ran the script & it worked. (edited it to ID the database(s) having problems
first, found it was an old one, then ran full script to restart said DB)
Thank you Alan.
Cheers
Tim
|||maybe you need to re-attach them?
I'd use query analzer and check out master.dbo.sysdatabases and see if that
tells you anything
"Tim" <tim.cox@.noterinaceous.com> wrote in message
news:d8e3b0fef0a846079c0e261264455587@.ureader.com. ..
> I had exactly the same issue, 2x clustered SQL 2000 SP3 boxen, "no items"
in
> EM DB view, should be 50 or so. Failed over to other node, still no joy.
> ran the script & it worked. (edited it to ID the database(s) having
problems
> first, found it was an old one, then ran full script to restart said DB)
> Thank you Alan.
> Cheers
> Tim
instances called SQL1 and SQL2 running on them. For some reason, we can't
manage SQL2 via Enterprise Manager recently since the databases folder is now
empty. The databases are there and I can see them via Query Analyzer, but I
just can't manage them via EM. "Management" folder is also empty, but if I
refresh (over and over) I sometimes can access the "SQL Server Agent" items.
Only changes that were made to the servers was to install some security
patches, but none that related to SQL server. Other SQL servers with the
same patches work fine. SQL1 instance can be managed with EM just fine.
I suspect something is wrong with SQL2 instance, but don't know what. It's
not related to the servers since I can move the instance between cluster
nodes and EM still cannot see databases on SQL2. SQL1 moves between nodes
fine and it's databases can be seen via EM.
Not sure if this is a clue, but when I right click on "Databases" and select
"New database", I get this error:
Microsoft SQL-DMO (ODBC SQLState: 22003)
Error 220: Arithmetic overflow error for that data type smallint, value=32826.
Arithmetic overflow error for data type smallint, value=32826.
The statement has been terminated.
I click OK, then I get the standard database properties dialog to create a
database...
Thanks in advance to any help or suggestions.
Regards,
-Daniel
My guess is a problem with DMO. Perhaps re-applying the SQL Server service pack will fix it?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Daniel" <Daniel@.tamc@.discussions.microsoft.com> wrote in message
news:0CB90BA3-08E0-4FA4-9177-6942CDC083BE@.microsoft.com...
> We're running a Win2k Adv Server MS Cluster using two servers with SQL
> instances called SQL1 and SQL2 running on them. For some reason, we can't
> manage SQL2 via Enterprise Manager recently since the databases folder is now
> empty. The databases are there and I can see them via Query Analyzer, but I
> just can't manage them via EM. "Management" folder is also empty, but if I
> refresh (over and over) I sometimes can access the "SQL Server Agent" items.
> Only changes that were made to the servers was to install some security
> patches, but none that related to SQL server. Other SQL servers with the
> same patches work fine. SQL1 instance can be managed with EM just fine.
> I suspect something is wrong with SQL2 instance, but don't know what. It's
> not related to the servers since I can move the instance between cluster
> nodes and EM still cannot see databases on SQL2. SQL1 moves between nodes
> fine and it's databases can be seen via EM.
> Not sure if this is a clue, but when I right click on "Databases" and select
> "New database", I get this error:
> Microsoft SQL-DMO (ODBC SQLState: 22003)
> Error 220: Arithmetic overflow error for that data type smallint, value=32826.
> Arithmetic overflow error for data type smallint, value=32826.
> The statement has been terminated.
> I click OK, then I get the standard database properties dialog to create a
> database...
> Thanks in advance to any help or suggestions.
> Regards,
> -Daniel
>
|||I am seeing these exact symptoms. Cluster, 1 server is showing "No items" in the database folder. Please advise.
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||I just ran across this problem today, and what I had to do was drop any databases that weren't in use (offline). I hope this helps anyone else googling for this problem!
-- hbz|||for googlers
no need to drop anything - it's enough to restart that databases whose status causing overflow errors
USE master
GO
DECLARE @.db_name varchar(500)
DECLARE dbn_cursor CURSOR FOR
SELECT [name] FROM sysdatabases;
OPEN dbn_cursor
FETCH NEXT FROM dbn_cursor
INTO @.db_name
WHILE @.@.FETCH_STATUS = 0
BEGIN
select * from sysdatabases where name = @.db_name
IF @.@.ERROR <> 0
BEGIN
declare @.off int
print 'Restarting database '+@.db_name
exec @.off = sp_dboption @.db_name, 'offline', 'TRUE'
IF @.off <> 0
print 'Taking offline failed! Need manual workaround!'
else
begin
declare @.on int
exec @.on = sp_dboption @.db_name, 'offline', 'FALSE'
IF @.on <> 0
print 'Bringing online failed! Need manual workaround!'
else
print 'Restart successfull!'
end
END
FETCH NEXT FROM dbn_cursor
INTO @.db_name
END
CLOSE dbn_cursor
DEALLOCATE dbn_cursor
GO|||I had exactly the same issue, 2x clustered SQL 2000 SP3 boxen, "no items" in
EM DB view, should be 50 or so. Failed over to other node, still no joy.
ran the script & it worked. (edited it to ID the database(s) having problems
first, found it was an old one, then ran full script to restart said DB)
Thank you Alan.
Cheers
Tim
|||maybe you need to re-attach them?
I'd use query analzer and check out master.dbo.sysdatabases and see if that
tells you anything
"Tim" <tim.cox@.noterinaceous.com> wrote in message
news:d8e3b0fef0a846079c0e261264455587@.ureader.com. ..
> I had exactly the same issue, 2x clustered SQL 2000 SP3 boxen, "no items"
in
> EM DB view, should be 50 or so. Failed over to other node, still no joy.
> ran the script & it worked. (edited it to ID the database(s) having
problems
> first, found it was an old one, then ran full script to restart said DB)
> Thank you Alan.
> Cheers
> Tim
Enterprise Manager connection to Local server very sloooow.
Hi,
I'm having a problem connecting to a local copy of SQL server 2000 using
enterprise manager (on Win2k). Doing anything, connecting, refreshing
list of tables etc. takes a very long time (>10secs) slower even than
remote connections.
Also, the enterprise manager itself becomes doggedly slow - eg. tringing
to move a window across the screen is difficult becuase it is so
stuttery. I have checked task manager, and it's not using much CPU time
though.
One other clue is that when you use something like the DTS wizard, the
local server is not explicitly displayed as one of the available servers.
This has only started happening recently. Any ideas on what is going on?
Thanks!Check to see if you have the Auto-Close option turned on any of your databases.
and check to see if OBDC tracing is turned on.|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your databases.
> and check to see if OBDC tracing is turned on.
>|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your databases.
> and check to see if OBDC tracing is turned on.
>|||Sosh123 wrote:
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
>> Check to see if you have the Auto-Close option turned on any of your
>> databases. and check to see if OBDC tracing is turned on.
Did you check all your databases for Auto-Close?
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Also check to make sure that none of the network components between you and
the server have their network connections set to Auto-negotiate, especially
through a switch. The protocol is not standardize and oftentimes will set
everything to 10 Mb, Half-duplex.
Also check your SQLEM Options to NOT reconnect to last connection on
relauch.
Sincerely,
Anthony Thomas
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23BhAFC7ZFHA.3620@.TK2MSFTNGP09.phx.gbl...
Sosh123 wrote:
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
>> Check to see if you have the Auto-Close option turned on any of your
>> databases. and check to see if OBDC tracing is turned on.
Did you check all your databases for Auto-Close?
--
David Gugick
Quest Software
www.imceda.com
www.quest.com
I'm having a problem connecting to a local copy of SQL server 2000 using
enterprise manager (on Win2k). Doing anything, connecting, refreshing
list of tables etc. takes a very long time (>10secs) slower even than
remote connections.
Also, the enterprise manager itself becomes doggedly slow - eg. tringing
to move a window across the screen is difficult becuase it is so
stuttery. I have checked task manager, and it's not using much CPU time
though.
One other clue is that when you use something like the DTS wizard, the
local server is not explicitly displayed as one of the available servers.
This has only started happening recently. Any ideas on what is going on?
Thanks!Check to see if you have the Auto-Close option turned on any of your databases.
and check to see if OBDC tracing is turned on.|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your databases.
> and check to see if OBDC tracing is turned on.
>|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your databases.
> and check to see if OBDC tracing is turned on.
>|||Sosh123 wrote:
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
>> Check to see if you have the Auto-Close option turned on any of your
>> databases. and check to see if OBDC tracing is turned on.
Did you check all your databases for Auto-Close?
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Also check to make sure that none of the network components between you and
the server have their network connections set to Auto-negotiate, especially
through a switch. The protocol is not standardize and oftentimes will set
everything to 10 Mb, Half-duplex.
Also check your SQLEM Options to NOT reconnect to last connection on
relauch.
Sincerely,
Anthony Thomas
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23BhAFC7ZFHA.3620@.TK2MSFTNGP09.phx.gbl...
Sosh123 wrote:
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
>> Check to see if you have the Auto-Close option turned on any of your
>> databases. and check to see if OBDC tracing is turned on.
Did you check all your databases for Auto-Close?
--
David Gugick
Quest Software
www.imceda.com
www.quest.com
Enterprise Manager connection to Local server very sloooow.
Hi,
I'm having a problem connecting to a local copy of SQL server 2000 using
enterprise manager (on Win2k). Doing anything, connecting, refreshing
list of tables etc. takes a very long time (>10secs) slower even than
remote connections.
Also, the enterprise manager itself becomes doggedly slow - eg. tringing
to move a window across the screen is difficult becuase it is so
stuttery. I have checked task manager, and it's not using much CPU time
though.
One other clue is that when you use something like the DTS wizard, the
local server is not explicitly displayed as one of the available servers.
This has only started happening recently. Any ideas on what is going on?
Thanks!
Check to see if you have the Auto-Close option turned on any of your databases.
and check to see if OBDC tracing is turned on.
|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your databases.
> and check to see if OBDC tracing is turned on.
>
|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your databases.
> and check to see if OBDC tracing is turned on.
>
|||Sosh123 wrote:[vbcol=seagreen]
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
Did you check all your databases for Auto-Close?
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Also check to make sure that none of the network components between you and
the server have their network connections set to Auto-negotiate, especially
through a switch. The protocol is not standardize and oftentimes will set
everything to 10 Mb, Half-duplex.
Also check your SQLEM Options to NOT reconnect to last connection on
relauch.
Sincerely,
Anthony Thomas
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23BhAFC7ZFHA.3620@.TK2MSFTNGP09.phx.gbl...
Sosh123 wrote:[vbcol=seagreen]
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
Did you check all your databases for Auto-Close?
David Gugick
Quest Software
www.imceda.com
www.quest.com
I'm having a problem connecting to a local copy of SQL server 2000 using
enterprise manager (on Win2k). Doing anything, connecting, refreshing
list of tables etc. takes a very long time (>10secs) slower even than
remote connections.
Also, the enterprise manager itself becomes doggedly slow - eg. tringing
to move a window across the screen is difficult becuase it is so
stuttery. I have checked task manager, and it's not using much CPU time
though.
One other clue is that when you use something like the DTS wizard, the
local server is not explicitly displayed as one of the available servers.
This has only started happening recently. Any ideas on what is going on?
Thanks!
Check to see if you have the Auto-Close option turned on any of your databases.
and check to see if OBDC tracing is turned on.
|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your databases.
> and check to see if OBDC tracing is turned on.
>
|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your databases.
> and check to see if OBDC tracing is turned on.
>
|||Sosh123 wrote:[vbcol=seagreen]
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
Did you check all your databases for Auto-Close?
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Also check to make sure that none of the network components between you and
the server have their network connections set to Auto-negotiate, especially
through a switch. The protocol is not standardize and oftentimes will set
everything to 10 Mb, Half-duplex.
Also check your SQLEM Options to NOT reconnect to last connection on
relauch.
Sincerely,
Anthony Thomas
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23BhAFC7ZFHA.3620@.TK2MSFTNGP09.phx.gbl...
Sosh123 wrote:[vbcol=seagreen]
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
Did you check all your databases for Auto-Close?
David Gugick
Quest Software
www.imceda.com
www.quest.com
Enterprise Manager connection to Local server very sloooow.
Hi,
I'm having a problem connecting to a local copy of SQL server 2000 using
enterprise manager (on Win2k). Doing anything, connecting, refreshing
list of tables etc. takes a very long time (>10secs) slower even than
remote connections.
Also, the enterprise manager itself becomes doggedly slow - eg. tringing
to move a window across the screen is difficult becuase it is so
stuttery. I have checked task manager, and it's not using much CPU time
though.
One other clue is that when you use something like the DTS wizard, the
local server is not explicitly displayed as one of the available servers.
This has only started happening recently. Any ideas on what is going on?
Thanks!Check to see if you have the Auto-Close option turned on any of your databas
es.
and check to see if OBDC tracing is turned on.|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your datab
ases.
> and check to see if OBDC tracing is turned on.
>|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your datab
ases.
> and check to see if OBDC tracing is turned on.
>|||Sosh123 wrote:[vbcol=seagreen]
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
>
Did you check all your databases for Auto-Close?
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Also check to make sure that none of the network components between you and
the server have their network connections set to Auto-negotiate, especially
through a switch. The protocol is not standardize and oftentimes will set
everything to 10 Mb, Half-duplex.
Also check your SQLEM Options to NOT reconnect to last connection on
relauch.
Sincerely,
Anthony Thomas
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23BhAFC7ZFHA.3620@.TK2MSFTNGP09.phx.gbl...
Sosh123 wrote:[vbcol=seagreen]
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
>
Did you check all your databases for Auto-Close?
David Gugick
Quest Software
www.imceda.com
www.quest.com
I'm having a problem connecting to a local copy of SQL server 2000 using
enterprise manager (on Win2k). Doing anything, connecting, refreshing
list of tables etc. takes a very long time (>10secs) slower even than
remote connections.
Also, the enterprise manager itself becomes doggedly slow - eg. tringing
to move a window across the screen is difficult becuase it is so
stuttery. I have checked task manager, and it's not using much CPU time
though.
One other clue is that when you use something like the DTS wizard, the
local server is not explicitly displayed as one of the available servers.
This has only started happening recently. Any ideas on what is going on?
Thanks!Check to see if you have the Auto-Close option turned on any of your databas
es.
and check to see if OBDC tracing is turned on.|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your datab
ases.
> and check to see if OBDC tracing is turned on.
>|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your datab
ases.
> and check to see if OBDC tracing is turned on.
>|||Sosh123 wrote:[vbcol=seagreen]
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
>
Did you check all your databases for Auto-Close?
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Also check to make sure that none of the network components between you and
the server have their network connections set to Auto-negotiate, especially
through a switch. The protocol is not standardize and oftentimes will set
everything to 10 Mb, Half-duplex.
Also check your SQLEM Options to NOT reconnect to last connection on
relauch.
Sincerely,
Anthony Thomas
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23BhAFC7ZFHA.3620@.TK2MSFTNGP09.phx.gbl...
Sosh123 wrote:[vbcol=seagreen]
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
>
Did you check all your databases for Auto-Close?
David Gugick
Quest Software
www.imceda.com
www.quest.com
Friday, February 17, 2012
Enterprise Manager - Design Table
Hi all,
I've recently migrated to XP from win2K, and my new instalation of Enterprise Manager is behaving differently.
When I open the Design Table dialogue in Enterprise Manager, the toolbar appears in the parent MMC window. Took me a while to find it. Anyway, when I've made the changes, I click on the Script Changes button, and ... nothing happens.
Please help.
Chris
Chris,
I'd recommend re-installing SQL Server. Hopefully you are just using the toolset so it won't take long. If you are using the whole bundle you could take a copy of ALL your .mdf and .ldf files to save having to backup and restore.
Tim
I've recently migrated to XP from win2K, and my new instalation of Enterprise Manager is behaving differently.
When I open the Design Table dialogue in Enterprise Manager, the toolbar appears in the parent MMC window. Took me a while to find it. Anyway, when I've made the changes, I click on the Script Changes button, and ... nothing happens.
Please help.
Chris
Chris,
I'd recommend re-installing SQL Server. Hopefully you are just using the toolset so it won't take long. If you are using the whole bundle you could take a copy of ALL your .mdf and .ldf files to save having to backup and restore.
Tim
Enterprise Manager - Design Table
Hi all,
I've recently migrated to XP from win2K, and my new instalation of Enterpris
e Manager is behaving differently.
When I open the Design Table dialogue in Enterprise Manager, the toolbar app
ears in the parent MMC window. Took me a while to find it. Anyway, when I've
made the changes, I click on the Script Changes button, and ... nothing hap
pens.
Please help.
ChrisChris,
I'd recommend re-installing SQL Server. Hopefully you are just using the to
olset so it won't take long. If you are using the whole bundle you could ta
ke a copy of ALL your .mdf and .ldf files to save having to backup and resto
re.
Tim
I've recently migrated to XP from win2K, and my new instalation of Enterpris
e Manager is behaving differently.
When I open the Design Table dialogue in Enterprise Manager, the toolbar app
ears in the parent MMC window. Took me a while to find it. Anyway, when I've
made the changes, I click on the Script Changes button, and ... nothing hap
pens.
Please help.
ChrisChris,
I'd recommend re-installing SQL Server. Hopefully you are just using the to
olset so it won't take long. If you are using the whole bundle you could ta
ke a copy of ALL your .mdf and .ldf files to save having to backup and resto
re.
Tim
Wednesday, February 15, 2012
Enterprise Edition
Please help.
I have a SQL2K EE SP 3 runing on WIN2k SP4 I uninstall
and renistall a Standard version of SQL 2K. However it
does not allow restore of previous system databases. What
can I do to overcome this. please?.
Urgent
Regards
Timi.Timi,
Did you apply SP3 to your Standard Edition?
Russell Fields
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:291701c3fc9c$ff121a20$a001280a@.phx.gbl...
> Please help.
> I have a SQL2K EE SP 3 runing on WIN2k SP4 I uninstall
> and renistall a Standard version of SQL 2K. However it
> does not allow restore of previous system databases. What
> can I do to overcome this. please?.
> Urgent
> Regards
> Timi.|||Could you be running into this problem:
264474 PRB: System Database Backups Cannot be Restored on a Different Build
http://support.microsoft.com/?id=264474
Rand
This posting is provided "as is" with no warranties and confers no rights.
I have a SQL2K EE SP 3 runing on WIN2k SP4 I uninstall
and renistall a Standard version of SQL 2K. However it
does not allow restore of previous system databases. What
can I do to overcome this. please?.
Urgent
Regards
Timi.Timi,
Did you apply SP3 to your Standard Edition?
Russell Fields
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:291701c3fc9c$ff121a20$a001280a@.phx.gbl...
> Please help.
> I have a SQL2K EE SP 3 runing on WIN2k SP4 I uninstall
> and renistall a Standard version of SQL 2K. However it
> does not allow restore of previous system databases. What
> can I do to overcome this. please?.
> Urgent
> Regards
> Timi.|||Could you be running into this problem:
264474 PRB: System Database Backups Cannot be Restored on a Different Build
http://support.microsoft.com/?id=264474
Rand
This posting is provided "as is" with no warranties and confers no rights.
Enterprise Edition
Please help.
I have a SQL2K EE SP 3 runing on WIN2k SP4 I uninstall
and renistall a Standard version of SQL 2K. However it
does not allow restore of previous system databases. What
can I do to overcome this. please?.
Urgent
Regards
Timi.Timi,
Did you apply SP3 to your Standard Edition?
Russell Fields
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:291701c3fc9c$ff121a20$a001280a@.phx.gbl...
> Please help.
> I have a SQL2K EE SP 3 runing on WIN2k SP4 I uninstall
> and renistall a Standard version of SQL 2K. However it
> does not allow restore of previous system databases. What
> can I do to overcome this. please?.
> Urgent
> Regards
> Timi.|||Could you be running into this problem:
264474 PRB: System Database Backups Cannot be Restored on a Different Build
http://support.microsoft.com/?id=264474
Rand
This posting is provided "as is" with no warranties and confers no rights.
I have a SQL2K EE SP 3 runing on WIN2k SP4 I uninstall
and renistall a Standard version of SQL 2K. However it
does not allow restore of previous system databases. What
can I do to overcome this. please?.
Urgent
Regards
Timi.Timi,
Did you apply SP3 to your Standard Edition?
Russell Fields
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:291701c3fc9c$ff121a20$a001280a@.phx.gbl...
> Please help.
> I have a SQL2K EE SP 3 runing on WIN2k SP4 I uninstall
> and renistall a Standard version of SQL 2K. However it
> does not allow restore of previous system databases. What
> can I do to overcome this. please?.
> Urgent
> Regards
> Timi.|||Could you be running into this problem:
264474 PRB: System Database Backups Cannot be Restored on a Different Build
http://support.microsoft.com/?id=264474
Rand
This posting is provided "as is" with no warranties and confers no rights.
Subscribe to:
Posts (Atom)