EnumErrorlogs using SQLDMO

I am wanting to use the EnumErrorlogs method of the SQLServer object to
identify which of the error logs have been written to in a specified period.
I also need to be able to deploy this to any of our SQL Servers which could
all be running with different locales.
The Date column in the QueryResults output shows this but not in the date
format that I expected. My server is set to English(Australian), my default
language for my login in SQL Server is British English ... i.e. everything is
configured to return dates in the D/M/Y format. However, the date string
returned from EnumErrorlogs is in a M/D/Y format which then messes up the
remainder of my processing.
Is the result ALWAYS returned in M/D/Y ? If so then I could at least code
for that, but if it is possible for it to be in the D/M/Y format then I need
to know where this is set so that I can test for it before continuing to
process the logs.
Can anyone direct me to information about this?
I was hoping it was something to do with the current holder of the ashes (ie
you could have waited about a year for it to fix itself),
but I'm seeing the same here in the UK on totally UK Server. The description
is a bit vague in BOL , going to try a few things.
cheers,
Andy.
"MartinC" <MartinC@.discussions.microsoft.com> wrote in message
news:79DF19A6-89D7-4464-92BF-EC7F6E6B78BB@.microsoft.com...
>I am wanting to use the EnumErrorlogs method of the SQLServer object to
> identify which of the error logs have been written to in a specified
> period.
> I also need to be able to deploy this to any of our SQL Servers which
> could
> all be running with different locales.
> The Date column in the QueryResults output shows this but not in the date
> format that I expected. My server is set to English(Australian), my
> default
> language for my login in SQL Server is British English ... i.e. everything
> is
> configured to return dates in the D/M/Y format. However, the date
> string
> returned from EnumErrorlogs is in a M/D/Y format which then messes up the
> remainder of my processing.
> Is the result ALWAYS returned in M/D/Y ? If so then I could at least
> code
> for that, but if it is possible for it to be in the D/M/Y format then I
> need
> to know where this is set so that I can test for it before continuing to
> process the logs.
> Can anyone direct me to information about this?
|||tried
- Service Account as interactive user with Brit English / UK locale
- changing / reapplying default to UK DD/MM/YY and reboot
giving up, attached is a noddy func to fix
bloody septics :-)
cheers,
Andy.
"Andy Ball" <ng@.spamno77greenfell.com> wrote in message
news:ua3F10v%23FHA.1028@.TK2MSFTNGP11.phx.gbl...
>I was hoping it was something to do with the current holder of the ashes
>(ie
> you could have waited about a year for it to fix itself),
> but I'm seeing the same here in the UK on totally UK Server. The
> description
> is a bit vague in BOL , going to try a few things.
> cheers,
> Andy.
>
> "MartinC" <MartinC@.discussions.microsoft.com> wrote in message
> news:79DF19A6-89D7-4464-92BF-EC7F6E6B78BB@.microsoft.com...
>
begin 666 ConvertErrorlogDate.txt
M( T*)R!A<R!E<G)O<FQO9R!I;B!M+V0O>2!F;W)M870@.:6X@.16YU ;45R<F]R
M3&]G<PT*1G5N8W1I;VX@.0V]N=F5R=$5R<F]R3&]G1&%T92A%<G)O<DQO9T1A
M=&4I#0H)0V]N=F5R=$5R<F]R3&]G1&%T92 ](&-3='(H36ED*$5R<F]R3&]G
M1&%T92PT+#(I("L@.(B\B("L@.;6ED*$5R<F]R3&]G1&%T92P@.,2PR*2 K("(O
J(B K(&UI9"A%<G)O<DQO9T1A=&4L(#<L,C I*0T*16YD($9U;F-T:6]N
`
end

Enterprise SQL move to Standard

Is it possible to follow the steps of moving ALL db's from an Enterprise SQL
Server to a Standard SQL Server?
We would like to just stop the SQL services and move the DB's across, rename
the server to match the old server and start the new SQL server.
Will this work or will it break since we are going from Enterprise to
Standard?
Paul Bergson
See if this helps:
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default...b;en-us;314546
AMB
"Paul Bergson" wrote:

> Is it possible to follow the steps of moving ALL db's from an Enterprise SQL
> Server to a Standard SQL Server?
> We would like to just stop the SQL services and move the DB's across, rename
> the server to match the old server and start the new SQL server.
> Will this work or will it break since we are going from Enterprise to
> Standard?
> --
> Paul Bergson
>
>
|||I have seen this. I want to know if I can move between Enterprise and
standard.
The bad thing about these newgroups is once someone answers in a thread a
lot of people no longer see them. So I will probably have to repost.
Paul Bergson MCT, MCSE, MCSA, CNE, CNA, CCA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:F21A54AA-F591-4F4D-894B-806F1C9061C9@.microsoft.com...[vbcol=seagreen]
> See if this helps:
> HOW TO: Move Databases Between Computers That Are Running SQL Server
> http://support.microsoft.com/default...b;en-us;314546
>
> AMB
>
> "Paul Bergson" wrote:
SQL[vbcol=seagreen]
rename[vbcol=seagreen]
|||I think there is not a problem moving dbs between editions. At least there is
not a single comment in both KB articles, the one I posted and this one.
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/kb/224071/EN-US/
I have done it before (moving user dbs) between servers with diff edition,
and have not got any problem till now.
AMB
"Paul Bergson" wrote:

> I have seen this. I want to know if I can move between Enterprise and
> standard.
> The bad thing about these newgroups is once someone answers in a thread a
> lot of people no longer see them. So I will probably have to repost.
> --
> Paul Bergson MCT, MCSE, MCSA, CNE, CNA, CCA
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
> news:F21A54AA-F591-4F4D-894B-806F1C9061C9@.microsoft.com...
> SQL
> rename
>
>
|||Shouldn't be a problem, since the real difference in the editions is things
like clustering support, log shipping, cpu and memory specs, etc. Its not
like DBCC Indexdefrag is going to be different in one edition vs. the
other...
Of course...you should be testing this in your lab anyway to confirm :-)
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:ua7SFT8VFHA.3176@.TK2MSFTNGP12.phx.gbl...
> Is it possible to follow the steps of moving ALL db's from an Enterprise
> SQL
> Server to a Standard SQL Server?
> We would like to just stop the SQL services and move the DB's across,
> rename
> the server to match the old server and start the new SQL server.
> Will this work or will it break since we are going from Enterprise to
> Standard?
> --
> Paul Bergson
>
|||Ok
Thanks
Paul Bergson
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:#4y4ru8VFHA.1384@.TK2MSFTNGP09.phx.gbl...
> Shouldn't be a problem, since the real difference in the editions is
things
> like clustering support, log shipping, cpu and memory specs, etc. Its not
> like DBCC Indexdefrag is going to be different in one edition vs. the
> other...
> Of course...you should be testing this in your lab anyway to confirm :-)
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
> news:ua7SFT8VFHA.3176@.TK2MSFTNGP12.phx.gbl...
>
|||Ok
Thanks
Paul Bergson
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:09828E93-517B-47FE-8D3E-FE4017A12C1C@.microsoft.com...
> I think there is not a problem moving dbs between editions. At least there
is[vbcol=seagreen]
> not a single comment in both KB articles, the one I posted and this one.
> Moving SQL Server databases to a new location with Detach/Attach
> http://support.microsoft.com/kb/224071/EN-US/
> I have done it before (moving user dbs) between servers with diff edition,
> and have not got any problem till now.
>
> AMB
> "Paul Bergson" wrote:
a[vbcol=seagreen]
rights.[vbcol=seagreen]
message[vbcol=seagreen]
Enterprise[vbcol=seagreen]
across,[vbcol=seagreen]
to[vbcol=seagreen]
sql

Enterprise SQL move to Standard

Is it possible to follow the steps of moving ALL db's from an Enterprise SQL
Server to a Standard SQL Server?
We would like to just stop the SQL services and move the DB's across, rename
the server to match the old server and start the new SQL server.
Will this work or will it break since we are going from Enterprise to
Standard?
Paul BergsonSee if this helps:
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/defaul...kb;en-us;314546
AMB
"Paul Bergson" wrote:

> Is it possible to follow the steps of moving ALL db's from an Enterprise S
QL
> Server to a Standard SQL Server?
> We would like to just stop the SQL services and move the DB's across, rena
me
> the server to match the old server and start the new SQL server.
> Will this work or will it break since we are going from Enterprise to
> Standard?
> --
> Paul Bergson
>
>|||I have seen this. I want to know if I can move between Enterprise and
standard.
The bad thing about these newgroups is once someone answers in a thread a
lot of people no longer see them. So I will probably have to repost.
Paul Bergson MCT, MCSE, MCSA, CNE, CNA, CCA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:F21A54AA-F591-4F4D-894B-806F1C9061C9@.microsoft.com...[vbcol=seagreen]
> See if this helps:
> HOW TO: Move Databases Between Computers That Are Running SQL Server
> http://support.microsoft.com/defaul...kb;en-us;314546
>
> AMB
>
> "Paul Bergson" wrote:
>
SQL[vbcol=seagreen]
rename[vbcol=seagreen]|||I think there is not a problem moving dbs between editions. At least there i
s
not a single comment in both KB articles, the one I posted and this one.
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/kb/224071/EN-US/
I have done it before (moving user dbs) between servers with diff edition,
and have not got any problem till now.
AMB
"Paul Bergson" wrote:

> I have seen this. I want to know if I can move between Enterprise and
> standard.
> The bad thing about these newgroups is once someone answers in a thread a
> lot of people no longer see them. So I will probably have to repost.
> --
> Paul Bergson MCT, MCSE, MCSA, CNE, CNA, CCA
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in messag
e
> news:F21A54AA-F591-4F4D-894B-806F1C9061C9@.microsoft.com...
> SQL
> rename
>
>|||Shouldn't be a problem, since the real difference in the editions is things
like clustering support, log shipping, cpu and memory specs, etc. Its not
like DBCC Indexdefrag is going to be different in one edition vs. the
other...
Of course...you should be testing this in your lab anyway to confirm :-)
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:ua7SFT8VFHA.3176@.TK2MSFTNGP12.phx.gbl...
> Is it possible to follow the steps of moving ALL db's from an Enterprise
> SQL
> Server to a Standard SQL Server?
> We would like to just stop the SQL services and move the DB's across,
> rename
> the server to match the old server and start the new SQL server.
> Will this work or will it break since we are going from Enterprise to
> Standard?
> --
> Paul Bergson
>|||Ok
Thanks
Paul Bergson
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:#4y4ru8VFHA.1384@.TK2MSFTNGP09.phx.gbl...
> Shouldn't be a problem, since the real difference in the editions is
things
> like clustering support, log shipping, cpu and memory specs, etc. Its not
> like DBCC Indexdefrag is going to be different in one edition vs. the
> other...
> Of course...you should be testing this in your lab anyway to confirm :-)
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
> news:ua7SFT8VFHA.3176@.TK2MSFTNGP12.phx.gbl...
>|||Ok
Thanks
Paul Bergson
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:09828E93-517B-47FE-8D3E-FE4017A12C1C@.microsoft.com...
> I think there is not a problem moving dbs between editions. At least there
is[vbcol=seagreen]
> not a single comment in both KB articles, the one I posted and this one.
> Moving SQL Server databases to a new location with Detach/Attach
> http://support.microsoft.com/kb/224071/EN-US/
> I have done it before (moving user dbs) between servers with diff edition,
> and have not got any problem till now.
>
> AMB
> "Paul Bergson" wrote:
>
a[vbcol=seagreen]
rights.[vbcol=seagreen]
message[vbcol=seagreen]
Enterprise[vbcol=seagreen]
across,[vbcol=seagreen]
to[vbcol=seagreen]

Enterprise Manger Error

I am getting an error:
MMC cannot open the file C:\program files\Miscorosft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
This may be because the file does not exist, is not an MMC console, or was
creted by a later version of MMC. This may also by because you do not have
sufficient access rights to the file.
I've tried uninstalling/reinstalling reapplying SP3a etc. with no luck.
I did find that renaming the file to anything else will allow it to work.
Which makes for an easy enough work around but was wondering if anybody knew
what is going on?
TIA
Hi
Have you tried running MMC and opening the file from there?
Check the file permissions.
If you have EM on another machine you may want to try copying the file.
Alternatively may want to extract the MSC file from the original CD.
John
"Ken Rinaman" <go@.away.net> wrote in message
news:%23sPCyhiUEHA.2972@.TK2MSFTNGP12.phx.gbl...
> I am getting an error:
> MMC cannot open the file C:\program files\Miscorosft SQL
> Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
> This may be because the file does not exist, is not an MMC console, or was
> creted by a later version of MMC. This may also by because you do not have
> sufficient access rights to the file.
> I've tried uninstalling/reinstalling reapplying SP3a etc. with no luck.
> I did find that renaming the file to anything else will allow it to work.
> Which makes for an easy enough work around but was wondering if anybody
knew
> what is going on?
> TIA
>
|||
> Have you tried running MMC and opening the file from there?
Yes, same error.

> Check the file permissions.
I have the ability to rename, delete, etc.

> If you have EM on another machine you may want to try copying the file.
> Alternatively may want to extract the MSC file from the original CD.
I did pull the file from the CD which is how I discovered changing the name
fixes the problem. On the CD the file is called SQLEM.msc if I copy that
file to my computer it runs fine. However if I rename it to SQL Server
Enterprise Manger.msc it no longer runs.
sql

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 performance

Hello,
When I use EM to examine a local db in SQLServer, it takes 1 - 3 minutes to
display the stored procedures (for example).
I just clicked on the "Tables" node in the treeview, and it took over a
minute to list the tables.
Is there any way to improve the performance? As it stands, it borders on
the unusable...
Thanks for any suggestions.
Check the properties of your database. Is autoclose turned on?
By the way, you can find out lots of information via Query Analyzer. It can
do almost everything that Enterprise Manager does -- often it can do it
faster.
you can execute stored procedures to find out information
exec sp_tables
exec sp_stored_procedures
or you can execute queries
SELECT * FROM INFORMATION_SCHEMA.TABLES /*WHERE ...*/
SELECT * FROM INFORMATION_SCHEMA.COLUMNS /*WHERE ...*/
use northwind
go
exec sp_tables
go
exec sp_columns 'Orders'
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'Orders'
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Orders'
Keith
"Developer" <wanderer@.mapinfo.nope.com> wrote in message
news:uXmNY7bwEHA.3716@.TK2MSFTNGP15.phx.gbl...
> Hello,
> When I use EM to examine a local db in SQLServer, it takes 1 - 3 minutes
to
> display the stored procedures (for example).
> I just clicked on the "Tables" node in the treeview, and it took over a
> minute to list the tables.
> Is there any way to improve the performance? As it stands, it borders on
> the unusable...
> Thanks for any suggestions.
>
|||Thanks for the reply. I'll try Query Analyzer.
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:uwwAbcewEHA.1988@.TK2MSFTNGP12.phx.gbl...
> Check the properties of your database. Is autoclose turned on?
> By the way, you can find out lots of information via Query Analyzer. It
can[vbcol=seagreen]
> do almost everything that Enterprise Manager does -- often it can do it
> faster.
> you can execute stored procedures to find out information
> exec sp_tables
> exec sp_stored_procedures
> or you can execute queries
> SELECT * FROM INFORMATION_SCHEMA.TABLES /*WHERE ...*/
> SELECT * FROM INFORMATION_SCHEMA.COLUMNS /*WHERE ...*/
>
> use northwind
> go
> exec sp_tables
> go
> exec sp_columns 'Orders'
> SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'Orders'
> SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Orders'
> --
> Keith
>
> "Developer" <wanderer@.mapinfo.nope.com> wrote in message
> news:uXmNY7bwEHA.3716@.TK2MSFTNGP15.phx.gbl...
> to
on
>
|||Hi,
Have you found any valueable information in Query Analyzer? If you have
many tables, it might really be time-consuming.
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||QA will be sufficient.
""Michael Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:XQ5gLYwwEHA.2916@.cpmsftngxa10.phx.gbl...
> Hi,
> Have you found any valueable information in Query Analyzer? If you have
> many tables, it might really be time-consuming.
> I wanted to post a quick note to see if you would like additional
> assistance or information regarding this particular issue. We appreciate
> your patience and look forward to hearing from you!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||This is ridiculous -- I just waited 4 minutes for EM to open the property
sheet for a local database.
P4, 2.8 gig, 1 gig o' ram and a big hard disk.
There must be some sort of tuning of SQLServer (or EM) available to make it
respond like a modern application.
"Developer" <wanderer@.mapinfo.nope.com> wrote in message
news:uXmNY7bwEHA.3716@.TK2MSFTNGP15.phx.gbl...
> Hello,
> When I use EM to examine a local db in SQLServer, it takes 1 - 3 minutes
to
> display the stored procedures (for example).
> I just clicked on the "Tables" node in the treeview, and it took over a
> minute to list the tables.
> Is there any way to improve the performance? As it stands, it borders on
> the unusable...
> Thanks for any suggestions.
>
|||Hi,
I understood that it must be frustrating!
Would you please use Profiler to trace the process when SQL Server
Enterprise Manager was opening? Send the Profiler Logs directly to me
v-mingqc@.online.microsoft.com (please remove 'online' as it's only for
SPAM). I would like to make further investigate.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hi,
Thanks for sending me the Profiler Trace!
1. I find the statement exec sp_dboption N'CareInsite', N'autoclose',
N'true' in the trace, so that please make sure AUTO_CLOSE option for the
database was set to false(Not Selected)
2. Check if ODBC Trace is turned off, using ODBCAD32.EXE and see Tracing tab
BTW, you are using SQL Server 2000 SP3?
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||1. I have unchecked "Auto close" on the Options tab in the property sheet
for my db.
2. It appears ODBC tracing was on; I clicked the "Stop Tracing Now" button
on the Tracing tab of "ODBC Data Source Administrator".
"About SQL Server Service Manager" says it is version 8.00.760. I believe
it is SQL Server 2000 SP3.
Thanks for following up...
""Michael Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:ta%23zQ%23IyEHA.3388@.cpmsftngxa10.phx.gbl...
> Hi,
> Thanks for sending me the Profiler Trace!
> 1. I find the statement exec sp_dboption N'CareInsite', N'autoclose',
> N'true' in the trace, so that please make sure AUTO_CLOSE option for the
> database was set to false(Not Selected)
> 2. Check if ODBC Trace is turned off, using ODBCAD32.EXE and see Tracing
tab
> BTW, you are using SQL Server 2000 SP3?
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||I suspect that turning off ODBC tracing made the difference; EM and Query
Analyzer are responsive and useful.
Thanks.
""Michael Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:ta%23zQ%23IyEHA.3388@.cpmsftngxa10.phx.gbl...
> Hi,
> Thanks for sending me the Profiler Trace!
> 1. I find the statement exec sp_dboption N'CareInsite', N'autoclose',
> N'true' in the trace, so that please make sure AUTO_CLOSE option for the
> database was set to false(Not Selected)
> 2. Check if ODBC Trace is turned off, using ODBCAD32.EXE and see Tracing
tab
> BTW, you are using SQL Server 2000 SP3?
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>

Enterprise Manager performance

Not sure what category this belongs to, so sqlserver.server it is...
Anyway, I am experiencing signficant performance problems using SS2K
Enterprise Manager. Any action, including something as simple as expanding
the list of databases on a server takes takes an incredibly long time.
Some examples...
1. Expanding the database folder to show the databases on a server takes
upwards of 2 minutes to complete
2. Saving a DTS package takes upwards of 2 minutes
3. Opening up a DTS package, and then double clicking on a Transform Data
Task can take upwards of 5 minutes.
I am the only one in our group that is having these problems, and our dba is
at a loss. Any suggestions?
I am running WinXP SP1
What method are you using to connect to your SQL Server? TCP/IP, Named
Pipes, Shared Memory?
Perhaps you need to enable TCP/IP and connect that way...
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Glenn Coello" <Glenn Coello@.discussions.microsoft.com> wrote in message
news:99E9B96E-B46C-41CE-9D32-ED045594F0C2@.microsoft.com...
> Not sure what category this belongs to, so sqlserver.server it is...
> Anyway, I am experiencing signficant performance problems using SS2K
> Enterprise Manager. Any action, including something as simple as
> expanding
> the list of databases on a server takes takes an incredibly long time.
> Some examples...
> 1. Expanding the database folder to show the databases on a server takes
> upwards of 2 minutes to complete
> 2. Saving a DTS package takes upwards of 2 minutes
> 3. Opening up a DTS package, and then double clicking on a Transform Data
> Task can take upwards of 5 minutes.
> I am the only one in our group that is having these problems, and our dba
> is
> at a loss. Any suggestions?
> I am running WinXP SP1
|||This is a dumb question, but how do I tell? I added all of my servers via
the New SQL Server registration in Enterprise Manager. I don't get asked a
connection method, and there is no option to adjust that within any of my
Properties menus.
"Warren Brunk" wrote:

> What method are you using to connect to your SQL Server? TCP/IP, Named
> Pipes, Shared Memory?
> Perhaps you need to enable TCP/IP and connect that way...
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> */
>
> "Glenn Coello" <Glenn Coello@.discussions.microsoft.com> wrote in message
> news:99E9B96E-B46C-41CE-9D32-ED045594F0C2@.microsoft.com...
>
>
|||SQL 2005
http://msdn2.microsoft.com/en-us/library/ms190611.aspx
SQL 2000
http://www.verio.com/support/documen...fm?doc_id=4027
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Glenn Coello" <GlennCoello@.discussions.microsoft.com> wrote in message
news:F2CEF464-DA3F-42A5-850C-93573DD5FA96@.microsoft.com...[vbcol=seagreen]
> This is a dumb question, but how do I tell? I added all of my servers via
> the New SQL Server registration in Enterprise Manager. I don't get asked
> a
> connection method, and there is no option to adjust that within any of my
> Properties menus.
> "Warren Brunk" wrote:
|||Since you said you were using SQL Server 2000 and the EM, do the following:
Start -> All Programs -> SQL Server -> Client Network Utility -> General tab
You will want to check this on both the client and the server to see which
protocols are enabled on each.
At least this will get you the protocols enabled - I don't know about fixing
the solution to your problem however, sorry. This is one place to start, as
Warren mentioned.
"Glenn Coello" <GlennCoello@.discussions.microsoft.com> wrote in message
news:F2CEF464-DA3F-42A5-850C-93573DD5FA96@.microsoft.com...[vbcol=seagreen]
> This is a dumb question, but how do I tell? I added all of my servers via
> the New SQL Server registration in Enterprise Manager. I don't get asked
> a
> connection method, and there is no option to adjust that within any of my
> Properties menus.
> "Warren Brunk" wrote:

Enterprise Manager performance

Not sure what category this belongs to, so sqlserver.server it is...
Anyway, I am experiencing signficant performance problems using SS2K
Enterprise Manager. Any action, including something as simple as expanding
the list of databases on a server takes takes an incredibly long time.
Some examples...
1. Expanding the database folder to show the databases on a server takes
upwards of 2 minutes to complete
2. Saving a DTS package takes upwards of 2 minutes
3. Opening up a DTS package, and then double clicking on a Transform Data
Task can take upwards of 5 minutes.
I am the only one in our group that is having these problems, and our dba is
at a loss. Any suggestions?
I am running WinXP SP1What method are you using to connect to your SQL Server? TCP/IP, Named
Pipes, Shared Memory?
Perhaps you need to enable TCP/IP and connect that way...
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Glenn Coello" <Glenn Coello@.discussions.microsoft.com> wrote in message
news:99E9B96E-B46C-41CE-9D32-ED045594F0C2@.microsoft.com...
> Not sure what category this belongs to, so sqlserver.server it is...
> Anyway, I am experiencing signficant performance problems using SS2K
> Enterprise Manager. Any action, including something as simple as
> expanding
> the list of databases on a server takes takes an incredibly long time.
> Some examples...
> 1. Expanding the database folder to show the databases on a server takes
> upwards of 2 minutes to complete
> 2. Saving a DTS package takes upwards of 2 minutes
> 3. Opening up a DTS package, and then double clicking on a Transform Data
> Task can take upwards of 5 minutes.
> I am the only one in our group that is having these problems, and our dba
> is
> at a loss. Any suggestions?
> I am running WinXP SP1|||This is a dumb question, but how do I tell? I added all of my servers via
the New SQL Server registration in Enterprise Manager. I don't get asked a
connection method, and there is no option to adjust that within any of my
Properties menus.
"Warren Brunk" wrote:

> What method are you using to connect to your SQL Server? TCP/IP, Named
> Pipes, Shared Memory?
> Perhaps you need to enable TCP/IP and connect that way...
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> */
>
> "Glenn Coello" <Glenn Coello@.discussions.microsoft.com> wrote in message
> news:99E9B96E-B46C-41CE-9D32-ED045594F0C2@.microsoft.com...
>
>|||SQL 2005
http://msdn2.microsoft.com/en-us/library/ms190611.aspx
SQL 2000
http://www.verio.com/support/docume...cfm?doc_id=4027
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Glenn Coello" <GlennCoello@.discussions.microsoft.com> wrote in message
news:F2CEF464-DA3F-42A5-850C-93573DD5FA96@.microsoft.com...[vbcol=seagreen]
> This is a dumb question, but how do I tell? I added all of my servers via
> the New SQL Server registration in Enterprise Manager. I don't get asked
> a
> connection method, and there is no option to adjust that within any of my
> Properties menus.
> "Warren Brunk" wrote:
>|||Since you said you were using SQL Server 2000 and the EM, do the following:
Start -> All Programs -> SQL Server -> Client Network Utility -> General tab
You will want to check this on both the client and the server to see which
protocols are enabled on each.
At least this will get you the protocols enabled - I don't know about fixing
the solution to your problem however, sorry. This is one place to start, as
Warren mentioned.
"Glenn Coello" <GlennCoello@.discussions.microsoft.com> wrote in message
news:F2CEF464-DA3F-42A5-850C-93573DD5FA96@.microsoft.com...[vbcol=seagreen]
> This is a dumb question, but how do I tell? I added all of my servers via
> the New SQL Server registration in Enterprise Manager. I don't get asked
> a
> connection method, and there is no option to adjust that within any of my
> Properties menus.
> "Warren Brunk" wrote:
>

Enterprise Manager performance

Not sure what category this belongs to, so sqlserver.server it is...
Anyway, I am experiencing signficant performance problems using SS2K
Enterprise Manager. Any action, including something as simple as expanding
the list of databases on a server takes takes an incredibly long time.
Some examples...
1. Expanding the database folder to show the databases on a server takes
upwards of 2 minutes to complete
2. Saving a DTS package takes upwards of 2 minutes
3. Opening up a DTS package, and then double clicking on a Transform Data
Task can take upwards of 5 minutes.
I am the only one in our group that is having these problems, and our dba is
at a loss. Any suggestions?
I am running WinXP SP1What method are you using to connect to your SQL Server? TCP/IP, Named
Pipes, Shared Memory?
Perhaps you need to enable TCP/IP and connect that way...
--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Glenn Coello" <Glenn Coello@.discussions.microsoft.com> wrote in message
news:99E9B96E-B46C-41CE-9D32-ED045594F0C2@.microsoft.com...
> Not sure what category this belongs to, so sqlserver.server it is...
> Anyway, I am experiencing signficant performance problems using SS2K
> Enterprise Manager. Any action, including something as simple as
> expanding
> the list of databases on a server takes takes an incredibly long time.
> Some examples...
> 1. Expanding the database folder to show the databases on a server takes
> upwards of 2 minutes to complete
> 2. Saving a DTS package takes upwards of 2 minutes
> 3. Opening up a DTS package, and then double clicking on a Transform Data
> Task can take upwards of 5 minutes.
> I am the only one in our group that is having these problems, and our dba
> is
> at a loss. Any suggestions?
> I am running WinXP SP1|||This is a dumb question, but how do I tell? I added all of my servers via
the New SQL Server registration in Enterprise Manager. I don't get asked a
connection method, and there is no option to adjust that within any of my
Properties menus.
"Warren Brunk" wrote:
> What method are you using to connect to your SQL Server? TCP/IP, Named
> Pipes, Shared Memory?
> Perhaps you need to enable TCP/IP and connect that way...
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> */
>
> "Glenn Coello" <Glenn Coello@.discussions.microsoft.com> wrote in message
> news:99E9B96E-B46C-41CE-9D32-ED045594F0C2@.microsoft.com...
> > Not sure what category this belongs to, so sqlserver.server it is...
> >
> > Anyway, I am experiencing signficant performance problems using SS2K
> > Enterprise Manager. Any action, including something as simple as
> > expanding
> > the list of databases on a server takes takes an incredibly long time.
> >
> > Some examples...
> >
> > 1. Expanding the database folder to show the databases on a server takes
> > upwards of 2 minutes to complete
> >
> > 2. Saving a DTS package takes upwards of 2 minutes
> >
> > 3. Opening up a DTS package, and then double clicking on a Transform Data
> > Task can take upwards of 5 minutes.
> >
> > I am the only one in our group that is having these problems, and our dba
> > is
> > at a loss. Any suggestions?
> >
> > I am running WinXP SP1
>
>|||SQL 2005
http://msdn2.microsoft.com/en-us/library/ms190611.aspx
SQL 2000
http://www.verio.com/support/documents/view_article.cfm?doc_id=4027
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Glenn Coello" <GlennCoello@.discussions.microsoft.com> wrote in message
news:F2CEF464-DA3F-42A5-850C-93573DD5FA96@.microsoft.com...
> This is a dumb question, but how do I tell? I added all of my servers via
> the New SQL Server registration in Enterprise Manager. I don't get asked
> a
> connection method, and there is no option to adjust that within any of my
> Properties menus.
> "Warren Brunk" wrote:
>> What method are you using to connect to your SQL Server? TCP/IP, Named
>> Pipes, Shared Memory?
>> Perhaps you need to enable TCP/IP and connect that way...
>> --
>> /*
>> Warren Brunk - MCITP - SQL 2005, MCDBA
>> www.techintsolutions.com
>> */
>>
>> "Glenn Coello" <Glenn Coello@.discussions.microsoft.com> wrote in message
>> news:99E9B96E-B46C-41CE-9D32-ED045594F0C2@.microsoft.com...
>> > Not sure what category this belongs to, so sqlserver.server it is...
>> >
>> > Anyway, I am experiencing signficant performance problems using SS2K
>> > Enterprise Manager. Any action, including something as simple as
>> > expanding
>> > the list of databases on a server takes takes an incredibly long time.
>> >
>> > Some examples...
>> >
>> > 1. Expanding the database folder to show the databases on a server
>> > takes
>> > upwards of 2 minutes to complete
>> >
>> > 2. Saving a DTS package takes upwards of 2 minutes
>> >
>> > 3. Opening up a DTS package, and then double clicking on a Transform
>> > Data
>> > Task can take upwards of 5 minutes.
>> >
>> > I am the only one in our group that is having these problems, and our
>> > dba
>> > is
>> > at a loss. Any suggestions?
>> >
>> > I am running WinXP SP1
>>|||Since you said you were using SQL Server 2000 and the EM, do the following:
Start -> All Programs -> SQL Server -> Client Network Utility -> General tab
You will want to check this on both the client and the server to see which
protocols are enabled on each.
At least this will get you the protocols enabled - I don't know about fixing
the solution to your problem however, sorry. This is one place to start, as
Warren mentioned.
"Glenn Coello" <GlennCoello@.discussions.microsoft.com> wrote in message
news:F2CEF464-DA3F-42A5-850C-93573DD5FA96@.microsoft.com...
> This is a dumb question, but how do I tell? I added all of my servers via
> the New SQL Server registration in Enterprise Manager. I don't get asked
> a
> connection method, and there is no option to adjust that within any of my
> Properties menus.
> "Warren Brunk" wrote:
>> What method are you using to connect to your SQL Server? TCP/IP, Named
>> Pipes, Shared Memory?
>> Perhaps you need to enable TCP/IP and connect that way...
>> --
>> /*
>> Warren Brunk - MCITP - SQL 2005, MCDBA
>> www.techintsolutions.com
>> */
>>
>> "Glenn Coello" <Glenn Coello@.discussions.microsoft.com> wrote in message
>> news:99E9B96E-B46C-41CE-9D32-ED045594F0C2@.microsoft.com...
>> > Not sure what category this belongs to, so sqlserver.server it is...
>> >
>> > Anyway, I am experiencing signficant performance problems using SS2K
>> > Enterprise Manager. Any action, including something as simple as
>> > expanding
>> > the list of databases on a server takes takes an incredibly long time.
>> >
>> > Some examples...
>> >
>> > 1. Expanding the database folder to show the databases on a server
>> > takes
>> > upwards of 2 minutes to complete
>> >
>> > 2. Saving a DTS package takes upwards of 2 minutes
>> >
>> > 3. Opening up a DTS package, and then double clicking on a Transform
>> > Data
>> > Task can take upwards of 5 minutes.
>> >
>> > I am the only one in our group that is having these problems, and our
>> > dba
>> > is
>> > at a loss. Any suggestions?
>> >
>> > I am running WinXP SP1
>>

Enterprise Manager Error Pls Help

Hi All,
Sqlserver 7.
From the Enterprise Manager when i right click on a table
and select
Return all row. I am getting the below error
An unexpected error happened during this operation.
[Query]- Query Designer encountered a Query error:
Unspecified error
When i use Query Analyser i am able to retrive the Data
Pls help Its Urgent
TIA
HaseebIf the drive that holds the temp directory is running low on space this
error can be generated. Enterprise manager creates temporary files when it
returns all rows.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Enterprise Manager Error Pls Help

Hi All,
Sqlserver 7.

From the Enterprise Manager when i right click on a table and select
Return all row. I am getting the below error

An unexpected error happened during this operation.
[Query]- Query Designer encountered a Query error: Unspecified error

When i use Query Analyser i am able to retrive the Data
Pls help Its Urgent

TIA
AdilDid you start and stop EM

Why is this urgent btw?

EM is quirky...if you deleted an object it might still be referencing it...

Don't use EM to query data in the first place...|||Hi,

I didnt stop and start EM
Most of the programmer are using the EM and complaining. And non of the objects are deleted. It is happening with all the Tables
Pls help me out

Originally posted by Brett Kaiser
Did you start and stop EM

Why is this urgent btw?

EM is quirky...if you deleted an object it might still be referencing it...

Don't use EM to query data in the first place...

Enterprise Manager Error Pls Help

Hi All,
Sqlserver 7.
From the Enterprise Manager when i right click on a table
and select
Return all row. I am getting the below error
An unexpected error happened during this operation.
[Query]- Query Designer encountered a Query error:
Unspecified error
When i use Query Analyser i am able to retrive the Data
Pls help Its Urgent
TIA
HaseebIf the drive that holds the temp directory is running low on space this
error can be generated. Enterprise manager creates temporary files when it
returns all rows.
Rand
This posting is provided "as is" with no warranties and confers no rights.

enterprise manager entries

where does sqlserver store the enterprise manager server registration entries
in the registry?Per default:
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bharath" <Bharath@.discussions.microsoft.com> wrote in message
news:E296F5A6-F532-49DB-852C-2755B266C9B0@.microsoft.com...
> where does sqlserver store the enterprise manager server registration entries
> in the registry?

enterprise manager entries

where does sqlserver store the enterprise manager server registration entries
in the registry?
Per default:
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bharath" <Bharath@.discussions.microsoft.com> wrote in message
news:E296F5A6-F532-49DB-852C-2755B266C9B0@.microsoft.com...
> where does sqlserver store the enterprise manager server registration entries
> in the registry?

enterprise manager entries

where does sqlserver store the enterprise manager server registration entrie
s
in the registry?Per default:
HKEY_CURRENT_USER\Software\Microsoft\Mic
rosoft SQL Server\80\Tools\SQLEW\Reg
istered Servers X
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bharath" <Bharath@.discussions.microsoft.com> wrote in message
news:E296F5A6-F532-49DB-852C-2755B266C9B0@.microsoft.com...
> where does sqlserver store the enterprise manager server registration entr
ies
> in the registry?

enterprise manager cost?

I need to put enterprise mgr on a desktop at my office to administer a sql
server database that I am renting from a hosting service. The server is
shared at the hosting site and I pay only the monthly 39.00 for that right.
Do I have to buy enterprise manager to be legal. If so any idea how much it
would cost for a single processor, one user desktop computer?
thanks, leon
This one is tricky. For properly licensed copies of SQL Server
installations, which I am assuming your host has done on your behalf, there
is no additional charge for the installation nor use of the client-side
tools. However, it is unlikely that you will have port 1433 outbound open
on your company's firewall nor will the host likely have port 1433 inbound
opened to the SQL Server installation.
Normally, the host will provide terminal server sessions, in which case you
would use the remote installation of the client tools.
Sincerely,
Anthony Thomas

"enterprise manager cost?" <enterprise manager
cost?@.discussions.microsoft.com> wrote in message
news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> I need to put enterprise mgr on a desktop at my office to administer a sql
> server database that I am renting from a hosting service. The server is
> shared at the hosting site and I pay only the monthly 39.00 for that
right.
> Do I have to buy enterprise manager to be legal. If so any idea how much
it
> would cost for a single processor, one user desktop computer?
> thanks, leon
|||Thanks for responding,
I orginally thought they would allow me to access through ts also but said I
would just be allowed to access that particular database which makes sense if
there are other people's databases on the server they wouldn't want to give
me access to the whole server.
I think I am just going to be given a domain.server name and once hooked up
only that database would appear because that is all I would have rights to.
I also don't think they are going to give me access to their copy of
Enterprise manager from there disk I will just be expected to provide it.
I found one company that offers an product to access from www.teratrax.com
but I am used to sql server tools and need the dts packages.
"AnthonyThomas" wrote:

> This one is tricky. For properly licensed copies of SQL Server
> installations, which I am assuming your host has done on your behalf, there
> is no additional charge for the installation nor use of the client-side
> tools. However, it is unlikely that you will have port 1433 outbound open
> on your company's firewall nor will the host likely have port 1433 inbound
> opened to the SQL Server installation.
> Normally, the host will provide terminal server sessions, in which case you
> would use the remote installation of the client tools.
> Sincerely,
>
> Anthony Thomas
>
> --
> "enterprise manager cost?" <enterprise manager
> cost?@.discussions.microsoft.com> wrote in message
> news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> right.
> it
>
>
|||You could purchase the developers edition for around $50 -
you'd have all the client tools that way. Other options are
here: http://www.aspfaq.com/show.asp?id=2442
-Sue
On Thu, 11 Nov 2004 13:10:01 -0800, "LLittle"
<LLittle@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Thanks for responding,
>I orginally thought they would allow me to access through ts also but said I
>would just be allowed to access that particular database which makes sense if
>there are other people's databases on the server they wouldn't want to give
>me access to the whole server.
>I think I am just going to be given a domain.server name and once hooked up
>only that database would appear because that is all I would have rights to.
>I also don't think they are going to give me access to their copy of
>Enterprise manager from there disk I will just be expected to provide it.
>I found one company that offers an product to access from www.teratrax.com
>but I am used to sql server tools and need the dts packages.
>
>
>"AnthonyThomas" wrote:
|||Sue Hoegemeier wrote:
> You could purchase the developers edition for around $50 -
> you'd have all the client tools that way. Other options are
> here: http://www.aspfaq.com/show.asp?id=2442
> -Sue
That wouldn't work legally.
You can use the SQL Server Web Administrator from MS without any
licensing requirements. I don't know that the ASP license for SQL Server
(what the ISP probably has) allows distribution of client tools. The web
data administrator should allow you to administer SQL Server from your
web browser.
http://www.microsoft.com/downloads/d...displaylang=en
David Gugick
Imceda Software
www.imceda.com
|||Depends on how it's licensed. I never heard of the ASP
license for SQL Server though - don't think there is such a
thing. See the link referenced for options - there are some
licensing explanations for the different options.
-Sue
On Thu, 11 Nov 2004 23:13:01 -0500, "David Gugick"
<davidg-nospam@.imceda.com> wrote:

>Sue Hoegemeier wrote:
>That wouldn't work legally.
>You can use the SQL Server Web Administrator from MS without any
>licensing requirements. I don't know that the ASP license for SQL Server
>(what the ISP probably has) allows distribution of client tools. The web
>data administrator should allow you to administer SQL Server from your
>web browser.
>http://www.microsoft.com/downloads/d...displaylang=en
|||See the end of Brian's article for a note about using SQL Server in an
ASP environment:
http://www.developer.com/tech/article.php/630451
From Microsoft:
http://www.microsoft.com/serviceprov.../licensing.asp
David Gugick
Imceda Software
www.imceda.com

enterprise manager cost?

I need to put enterprise mgr on a desktop at my office to administer a sql
server database that I am renting from a hosting service. The server is
shared at the hosting site and I pay only the monthly 39.00 for that right.
Do I have to buy enterprise manager to be legal. If so any idea how much it
would cost for a single processor, one user desktop computer?
thanks, leonThis one is tricky. For properly licensed copies of SQL Server
installations, which I am assuming your host has done on your behalf, there
is no additional charge for the installation nor use of the client-side
tools. However, it is unlikely that you will have port 1433 outbound open
on your company's firewall nor will the host likely have port 1433 inbound
opened to the SQL Server installation.
Normally, the host will provide terminal server sessions, in which case you
would use the remote installation of the client tools.
Sincerely,
Anthony Thomas
"enterprise manager cost?" <enterprise manager
cost?@.discussions.microsoft.com> wrote in message
news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> I need to put enterprise mgr on a desktop at my office to administer a sql
> server database that I am renting from a hosting service. The server is
> shared at the hosting site and I pay only the monthly 39.00 for that
right.
> Do I have to buy enterprise manager to be legal. If so any idea how much
it
> would cost for a single processor, one user desktop computer?
> thanks, leon|||Thanks for responding,
I orginally thought they would allow me to access through ts also but said I
would just be allowed to access that particular database which makes sense i
f
there are other people's databases on the server they wouldn't want to give
me access to the whole server.
I think I am just going to be given a domain.server name and once hooked up
only that database would appear because that is all I would have rights to.
I also don't think they are going to give me access to their copy of
Enterprise manager from there disk I will just be expected to provide it.
I found one company that offers an product to access from www.teratrax.com
but I am used to sql server tools and need the dts packages.
"AnthonyThomas" wrote:

> This one is tricky. For properly licensed copies of SQL Server
> installations, which I am assuming your host has done on your behalf, ther
e
> is no additional charge for the installation nor use of the client-side
> tools. However, it is unlikely that you will have port 1433 outbound open
> on your company's firewall nor will the host likely have port 1433 inbound
> opened to the SQL Server installation.
> Normally, the host will provide terminal server sessions, in which case yo
u
> would use the remote installation of the client tools.
> Sincerely,
>
> Anthony Thomas
>
> --
> "enterprise manager cost?" <enterprise manager
> cost?@.discussions.microsoft.com> wrote in message
> news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> right.
> it
>
>|||You could purchase the developers edition for around $50 -
you'd have all the client tools that way. Other options are
here: http://www.aspfaq.com/show.asp?id=2442
-Sue
On Thu, 11 Nov 2004 13:10:01 -0800, "LLittle"
<LLittle@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Thanks for responding,
>I orginally thought they would allow me to access through ts also but said
I
>would just be allowed to access that particular database which makes sense
if
>there are other people's databases on the server they wouldn't want to give
>me access to the whole server.
>I think I am just going to be given a domain.server name and once hooked up
>only that database would appear because that is all I would have rights to.
>I also don't think they are going to give me access to their copy of
>Enterprise manager from there disk I will just be expected to provide it.
>I found one company that offers an product to access from www.teratrax.com
>but I am used to sql server tools and need the dts packages.
>
>
>"AnthonyThomas" wrote:
>|||Sue Hoegemeier wrote:
> You could purchase the developers edition for around $50 -
> you'd have all the client tools that way. Other options are
> here: http://www.aspfaq.com/show.asp?id=2442
> -Sue
That wouldn't work legally.
You can use the SQL Server Web Administrator from MS without any
licensing requirements. I don't know that the ASP license for SQL Server
(what the ISP probably has) allows distribution of client tools. The web
data administrator should allow you to administer SQL Server from your
web browser.
http://www.microsoft.com/downloads/...&displaylang=en
David Gugick
Imceda Software
www.imceda.com|||Depends on how it's licensed. I never heard of the ASP
license for SQL Server though - don't think there is such a
thing. See the link referenced for options - there are some
licensing explanations for the different options.
-Sue
On Thu, 11 Nov 2004 23:13:01 -0500, "David Gugick"
<davidg-nospam@.imceda.com> wrote:

>Sue Hoegemeier wrote:
>That wouldn't work legally.
>You can use the SQL Server Web Administrator from MS without any
>licensing requirements. I don't know that the ASP license for SQL Server
>(what the ISP probably has) allows distribution of client tools. The web
>data administrator should allow you to administer SQL Server from your
>web browser.
>http://www.microsoft.com/downloads/...&displaylang=en|||See the end of Brian's article for a note about using SQL Server in an
ASP environment:
http://www.developer.com/tech/article.php/630451
From Microsoft:
http://www.microsoft.com/servicepro...g/licensing.asp
David Gugick
Imceda Software
www.imceda.com

Enterprise Manager appears to slow my dial up connection

I am using a dial up connection to the Internet and to an online SQL
Server database.

I have a problem in that when I use Enterprise Manager to access even
my local server , or even, it appears, when it is just open with no
connection to any SQL Server, I experience very slow data transfer
over my normal dial up connection.

I am reasonably sure it is Enterprise Manager causing the problem as
when I close it and redial I have an acceptable rate of data transfer
using my dial up connection.

Can anyone:

a. support my conclusion that Enterprise Manager is the probable
cause of the slow connection.

b. suggest a solution

Best wishes, John MorganJohn Morgan (jfm@.XXwoodlander.co.uk) writes:
> I am using a dial up connection to the Internet and to an online SQL
> Server database.
> I have a problem in that when I use Enterprise Manager to access even
> my local server , or even, it appears, when it is just open with no
> connection to any SQL Server, I experience very slow data transfer
> over my normal dial up connection.
> I am reasonably sure it is Enterprise Manager causing the problem as
> when I close it and redial I have an acceptable rate of data transfer
> using my dial up connection.
> Can anyone:
> a. support my conclusion that Enterprise Manager is the probable
> cause of the slow connection.
> b. suggest a solution

I don't have a configuration that I easily can test from, but I have a
guess that you could try: for all your remote servers, right-click and
pick Edit SQL Server Registration Properties and uncheck "Display server
state in console".

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

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.