EMail subscription fails with LOGON FAILED

I am setting up SQL Reporting enterprise. I can't get email subscriptions to
work. SQL Reporting enterprise is installed and the report works fine when
generated. The security is setup to use a windows account and store
credentials on server. This account has the SA role within SQL and the
database where data is being pulled from. Platform is Win2003 - fully
patched with Reporting service pack 1
There is nothing in the event logs indicating any type of failure.
The SMTP server is setup as remote SMTP server and I've verified the config
file to ensure it is setup correctly. Since I'm getting a logon failure -
I'm not sure its really an email issue at this point. Specifically, the
config file is set up as:
<SMTPServer>172.24.1.25</SMTPServer>
<SMTPServerPort>25</SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate>0</SMTPAuthenticate>
<From>SQLREP@.correctdomain.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
At this time out out of ideas - can anyone suggest where to look?What is the login failure you're recieving? Is it in the report server log
file when you try to perform the delivery?
If so the report server service account may not have rights to push email to
your SMTP server. You might need to drop them to the file system and use a
local SMTP server to pass them along to your outbound SMTP server.
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bill" <Bill@.discussions.microsoft.com> wrote in message
news:60EAFC5B-9844-40DD-AE82-86A766D719E2@.microsoft.com...
>I am setting up SQL Reporting enterprise. I can't get email subscriptions
>to
> work. SQL Reporting enterprise is installed and the report works fine
> when
> generated. The security is setup to use a windows account and store
> credentials on server. This account has the SA role within SQL and the
> database where data is being pulled from. Platform is Win2003 - fully
> patched with Reporting service pack 1
> There is nothing in the event logs indicating any type of failure.
> The SMTP server is setup as remote SMTP server and I've verified the
> config
> file to ensure it is setup correctly. Since I'm getting a logon failure -
> I'm not sure its really an email issue at this point. Specifically, the
> config file is set up as:
> <SMTPServer>172.24.1.25</SMTPServer>
> <SMTPServerPort>25</SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate>0</SMTPAuthenticate>
> <From>SQLREP@.correctdomain.com</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> At this time out out of ideas - can anyone suggest where to look?
>|||Thank you for the post. The logon failed is being shown in the web interface
under subscriptions.
The reportserverservice does show a login failure - although I can't imagine
why. I've setup the job with several credentials and all fail. (Including
Domain Admin role) The Reporting service is currently running as a network
service but I have also run it will a privledge domain account. Same error.
I am able to send to the SMTP server from this server without authentication.
I'm still stumped!
From the log file:
ReportingServicesService!dbpolling!6f0!2/10/2005-08:43:09::
NotificationPolling processing item 052e0da7-4e8f-4804-84fb-76bb1b373d62
ReportingServicesService!library!6f0!02/10/2005-08:43:09:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!6f0!02/10/2005-08:43:10:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon
failed., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon
failed. --> System.Runtime.InteropServices.COMException (0x8007052E): Logon
failure: unknown user name or bad password.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName,
String pDomain, String pPassword, Boolean bTryRemote, IntPtr& pImpToken)
at
Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(String userName, String userPwd, String domain)
-- End of inner exception stack trace --
ReportingServicesService!notification!6f0!02/10/2005-08:43:10:: e ERROR:
Error occured processing notification. Logon failed.
ReportingServicesService!notification!6f0!02/10/2005-08:43:10:: Notification
052e0da7-4e8f-4804-84fb-76bb1b373d62 completed. Success: False, Status:
Logon failed., DeliveryExtension: Report Server Email, Report: Expired
Enhancements, Attempt 0
ReportingServicesService!dbpolling!6f0!02/10/2005-08:43:10::
NotificationPolling finished processing item
052e0da7-4e8f-4804-84fb-76bb1b373d62
"Lukasz Pawlowski [MSFT]" wrote:
> What is the login failure you're recieving? Is it in the report server log
> file when you try to perform the delivery?
> If so the report server service account may not have rights to push email to
> your SMTP server. You might need to drop them to the file system and use a
> local SMTP server to pass them along to your outbound SMTP server.
> -Lukasz
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Bill" <Bill@.discussions.microsoft.com> wrote in message
> news:60EAFC5B-9844-40DD-AE82-86A766D719E2@.microsoft.com...
> >I am setting up SQL Reporting enterprise. I can't get email subscriptions
> >to
> > work. SQL Reporting enterprise is installed and the report works fine
> > when
> > generated. The security is setup to use a windows account and store
> > credentials on server. This account has the SA role within SQL and the
> > database where data is being pulled from. Platform is Win2003 - fully
> > patched with Reporting service pack 1
> >
> > There is nothing in the event logs indicating any type of failure.
> >
> > The SMTP server is setup as remote SMTP server and I've verified the
> > config
> > file to ensure it is setup correctly. Since I'm getting a logon failure -
> > I'm not sure its really an email issue at this point. Specifically, the
> > config file is set up as:
> >
> > <SMTPServer>172.24.1.25</SMTPServer>
> > <SMTPServerPort>25</SMTPServerPort>
> > <SMTPAccountName></SMTPAccountName>
> > <SMTPConnectionTimeout></SMTPConnectionTimeout>
> > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> > <SMTPUseSSL></SMTPUseSSL>
> > <SendUsing></SendUsing>
> > <SMTPAuthenticate>0</SMTPAuthenticate>
> > <From>SQLREP@.correctdomain.com</From>
> > <EmbeddedRenderFormats>
> > <RenderingExtension>MHTML</RenderingExtension>
> > </EmbeddedRenderFormats>
> > <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> > <ExcludedRenderFormats>
> > <RenderingExtension>HTMLOWC</RenderingExtension>
> > <RenderingExtension>NULL</RenderingExtension>
> > </ExcludedRenderFormats>
> > <SendEmailToUserAlias>True</SendEmailToUserAlias>
> >
> > At this time out out of ideas - can anyone suggest where to look?
> >
>
>|||Update: I failed to use RSKEYMGNT to export the key prior to resetting the
service account context. I set it back and will change the account properly
to see if this resolves the issue.
"Bill" wrote:
> Thank you for the post. The logon failed is being shown in the web interface
> under subscriptions.
> The reportserverservice does show a login failure - although I can't imagine
> why. I've setup the job with several credentials and all fail. (Including
> Domain Admin role) The Reporting service is currently running as a network
> service but I have also run it will a privledge domain account. Same error.
> I am able to send to the SMTP server from this server without authentication.
> I'm still stumped!
> From the log file:
> ReportingServicesService!dbpolling!6f0!2/10/2005-08:43:09::
> NotificationPolling processing item 052e0da7-4e8f-4804-84fb-76bb1b373d62
> ReportingServicesService!library!6f0!02/10/2005-08:43:09:: i INFO:
> Initializing EnableIntegratedSecurity to 'True' as specified in Server
> system properties.
> ReportingServicesService!library!6f0!02/10/2005-08:43:10:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon
> failed., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon
> failed. --> System.Runtime.InteropServices.COMException (0x8007052E): Logon
> failure: unknown user name or bad password.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName,
> String pDomain, String pPassword, Boolean bTryRemote, IntPtr& pImpToken)
> at
> Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(String userName, String userPwd, String domain)
> -- End of inner exception stack trace --
> ReportingServicesService!notification!6f0!02/10/2005-08:43:10:: e ERROR:
> Error occured processing notification. Logon failed.
> ReportingServicesService!notification!6f0!02/10/2005-08:43:10:: Notification
> 052e0da7-4e8f-4804-84fb-76bb1b373d62 completed. Success: False, Status:
> Logon failed., DeliveryExtension: Report Server Email, Report: Expired
> Enhancements, Attempt 0
> ReportingServicesService!dbpolling!6f0!02/10/2005-08:43:10::
> NotificationPolling finished processing item
> 052e0da7-4e8f-4804-84fb-76bb1b373d62
>
> "Lukasz Pawlowski [MSFT]" wrote:
> > What is the login failure you're recieving? Is it in the report server log
> > file when you try to perform the delivery?
> >
> > If so the report server service account may not have rights to push email to
> > your SMTP server. You might need to drop them to the file system and use a
> > local SMTP server to pass them along to your outbound SMTP server.
> >
> > -Lukasz
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Bill" <Bill@.discussions.microsoft.com> wrote in message
> > news:60EAFC5B-9844-40DD-AE82-86A766D719E2@.microsoft.com...
> > >I am setting up SQL Reporting enterprise. I can't get email subscriptions
> > >to
> > > work. SQL Reporting enterprise is installed and the report works fine
> > > when
> > > generated. The security is setup to use a windows account and store
> > > credentials on server. This account has the SA role within SQL and the
> > > database where data is being pulled from. Platform is Win2003 - fully
> > > patched with Reporting service pack 1
> > >
> > > There is nothing in the event logs indicating any type of failure.
> > >
> > > The SMTP server is setup as remote SMTP server and I've verified the
> > > config
> > > file to ensure it is setup correctly. Since I'm getting a logon failure -
> > > I'm not sure its really an email issue at this point. Specifically, the
> > > config file is set up as:
> > >
> > > <SMTPServer>172.24.1.25</SMTPServer>
> > > <SMTPServerPort>25</SMTPServerPort>
> > > <SMTPAccountName></SMTPAccountName>
> > > <SMTPConnectionTimeout></SMTPConnectionTimeout>
> > > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> > > <SMTPUseSSL></SMTPUseSSL>
> > > <SendUsing></SendUsing>
> > > <SMTPAuthenticate>0</SMTPAuthenticate>
> > > <From>SQLREP@.correctdomain.com</From>
> > > <EmbeddedRenderFormats>
> > > <RenderingExtension>MHTML</RenderingExtension>
> > > </EmbeddedRenderFormats>
> > > <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> > > <ExcludedRenderFormats>
> > > <RenderingExtension>HTMLOWC</RenderingExtension>
> > > <RenderingExtension>NULL</RenderingExtension>
> > > </ExcludedRenderFormats>
> > > <SendEmailToUserAlias>True</SendEmailToUserAlias>
> > >
> > > At this time out out of ideas - can anyone suggest where to look?
> > >
> >
> >
> >|||I am getting a logon failed when I set up my subscription through th
GUI in Report Manager. I confirmed that the SMTP settings wer
correct in the RSReportSever.config file. The Log is as follows: Ca
you help?
ReportingServicesService!library!d84!09/21/2005-14:39:10:: i INFO
Initializing EnableIntegratedSecurity to 'True' as specified i
Server system properties
ReportingServicesService!library!d84!09/21/2005-14:39:10:: e ERROR
Throwin
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException
Logon failed.,
Info
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException
Logon failed. --> System.Runtime.InteropServices.COMExceptio
(0x8007052E): Logon failure: unknown user name or ba
password. a
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int3
errorCode, IntPtr errorInfo
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(Strin
pUserName, String pDomain, String pPassword, Boolean bTryRemote
IntPtr& pImpToken
a
Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(Strin
userName, String userPwd, String domain
-- End of inner exception stack trace --
ReportingServicesService!notification!d84!09/21/2005-14:39:10::
ERROR: Error occured processing notification. Logon failed
ReportingServicesService!notification!d84!09/21/2005-14:39:10:
Notification 4105c963-0eb9-4f69-bbbc-81ab27964a43 completed.
Success: False, [b:f30cd15b21]Status: Logon failed.
DeliveryExtension: Report Server [/b:f30cd15b21]Email, Report
Incomplete Loan Applications, Attempt
ReportingServicesService!dbpolling!d84!09/21/2005-14:39:10:
NotificationPolling finished processing ite
4105c963-0eb9-4f69-bbbc-81ab27964a4

E-mail Notification

We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
Edition Server. We setup some maintenance jobs under Database Maintenance
and would like to setup e-mail notification. When we setup notifications,
we got the following error message: "Error 22022: SQLServerAgent Error:
The SQLServer Agent mail session is not running; check the mail profile
and/or the SQLServerAgent service startup account in the SQLServerAgent
Properties dialog." What do we need to do? Please let us know if you need
additional information. Thank you.
You have to interactively login as thye service account that SQL is running
under and install Outlook and configure a mapi profile. If you are still
running as localsystem, you'll need to switch to a service account for it to
work. The SQL Server service account maust have rights to access the mapi
profile.
"Diane Walker" wrote:

> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
> Edition Server. We setup some maintenance jobs under Database Maintenance
> and would like to setup e-mail notification. When we setup notifications,
> we got the following error message: "Error 22022: SQLServerAgent Error:
> The SQLServer Agent mail session is not running; check the mail profile
> and/or the SQLServerAgent service startup account in the SQLServerAgent
> Properties dialog." What do we need to do? Please let us know if you need
> additional information. Thank you.
>
>
|||Thanks very much for your prompt response, Jeffrey.
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:3DBDB121-D7D6-413C-BF3F-1B1F33CEDB4D@.microsoft.com...[vbcol=seagreen]
> You have to interactively login as thye service account that SQL is
> running
> under and install Outlook and configure a mapi profile. If you are still
> running as localsystem, you'll need to switch to a service account for it
> to
> work. The SQL Server service account maust have rights to access the mapi
> profile.
> "Diane Walker" wrote:

E-mail Notification

We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
Edition Server. We setup some maintenance jobs under Database Maintenance
and would like to setup e-mail notification. When we setup notifications,
we got the following error message: "Error 22022: SQLServerAgent Error:
The SQLServer Agent mail session is not running; check the mail profile
and/or the SQLServerAgent service startup account in the SQLServerAgent
Properties dialog." What do we need to do? Please let us know if you need
additional information. Thank you.You have to interactively login as thye service account that SQL is running
under and install Outlook and configure a mapi profile. If you are still
running as localsystem, you'll need to switch to a service account for it to
work. The SQL Server service account maust have rights to access the mapi
profile.
"Diane Walker" wrote:

> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
> Edition Server. We setup some maintenance jobs under Database Maintenance
> and would like to setup e-mail notification. When we setup notifications,
> we got the following error message: "Error 22022: SQLServerAgent Error:
> The SQLServer Agent mail session is not running; check the mail profile
> and/or the SQLServerAgent service startup account in the SQLServerAgent
> Properties dialog." What do we need to do? Please let us know if you nee
d
> additional information. Thank you.
>
>|||Thanks very much for your prompt response, Jeffrey.
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:3DBDB121-D7D6-413C-BF3F-1B1F33CEDB4D@.microsoft.com...[vbcol=seagreen]
> You have to interactively login as thye service account that SQL is
> running
> under and install Outlook and configure a mapi profile. If you are still
> running as localsystem, you'll need to switch to a service account for it
> to
> work. The SQL Server service account maust have rights to access the mapi
> profile.
> "Diane Walker" wrote:
>

E-mail Notification

We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
Edition Server. We setup some maintenance jobs under Database Maintenance
and would like to setup e-mail notification. When we setup notifications,
we got the following error message: "Error 22022: SQLServerAgent Error:
The SQLServer Agent mail session is not running; check the mail profile
and/or the SQLServerAgent service startup account in the SQLServerAgent
Properties dialog." What do we need to do? Please let us know if you need
additional information. Thank you.You have to interactively login as thye service account that SQL is running
under and install Outlook and configure a mapi profile. If you are still
running as localsystem, you'll need to switch to a service account for it to
work. The SQL Server service account maust have rights to access the mapi
profile.
"Diane Walker" wrote:
> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
> Edition Server. We setup some maintenance jobs under Database Maintenance
> and would like to setup e-mail notification. When we setup notifications,
> we got the following error message: "Error 22022: SQLServerAgent Error:
> The SQLServer Agent mail session is not running; check the mail profile
> and/or the SQLServerAgent service startup account in the SQLServerAgent
> Properties dialog." What do we need to do? Please let us know if you need
> additional information. Thank you.
>
>|||Thanks very much for your prompt response, Jeffrey.
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:3DBDB121-D7D6-413C-BF3F-1B1F33CEDB4D@.microsoft.com...
> You have to interactively login as thye service account that SQL is
> running
> under and install Outlook and configure a mapi profile. If you are still
> running as localsystem, you'll need to switch to a service account for it
> to
> work. The SQL Server service account maust have rights to access the mapi
> profile.
> "Diane Walker" wrote:
>> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
>> Edition Server. We setup some maintenance jobs under Database
>> Maintenance
>> and would like to setup e-mail notification. When we setup
>> notifications,
>> we got the following error message: "Error 22022: SQLServerAgent Error:
>> The SQLServer Agent mail session is not running; check the mail profile
>> and/or the SQLServerAgent service startup account in the SQLServerAgent
>> Properties dialog." What do we need to do? Please let us know if you
>> need
>> additional information. Thank you.
>>

EM: Getting rid of "do you want to continue..." message

Hi,
I use the Enterprise Manager frequently and then have quite a few tables
opened. I spend half my day (well, it feels like that anyway...) clicking
away the messageboxes "Do you want to continue working with this resultset"
and "the pane has been cleared to save resources".
I understand why SQLServer 2000 wants to do this, I just don't want those
messageboxes... is there a way to tell the EM that for the rest of my life
I don't want to continue working with any resultset until I run the query
again? It would be a lifesaver for me!
Thanks!I recommend you avoid editing tables in EM. Occassionaly opening a table for
review in EM is reasonable enough but Query Analyzer is actually a much more
powerful tool for querying and updating data. QA doesn't cause the same
problems. See:
http://www.aspfaq.com/show.asp?id=2455
David Portas
SQL Server MVP
--

EM won't display databases

After adding 6 databases to a server for a total of 16
databases, my Enterprise Manager won't display databases
(the databases just disappeared).
However, DBArtisan and Query Analyzer work fine. Both can
display the databases. Is there a limit on the total
number of databases EM can display? Or is this a bug in
EM?
TIA.
JeffreyJeff,
EM surely can handle 16.Whats the SQLServer version and service pack level
of this EM?
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jeffrey Wang" <jwang@.dot.state.tx.us> wrote in message
news:588b01c42d3f$2455aa40$a301280a@.phx.gbl...
> After adding 6 databases to a server for a total of 16
> databases, my Enterprise Manager won't display databases
> (the databases just disappeared).
> However, DBArtisan and Query Analyzer work fine. Both can
> display the databases. Is there a limit on the total
> number of databases EM can display? Or is this a bug in
> EM?
> TIA.
> Jeffrey|||2000 SP3a. Is it possible that SP3a is the problem?
Thanks.
>--Original Message--
>Jeff,
>EM surely can handle 16.Whats the SQLServer version and
service pack level
>of this EM?
>--
>Dinesh
>SQL Server MVP
>--
>--
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Jeffrey Wang" <jwang@.dot.state.tx.us> wrote in message
>news:588b01c42d3f$2455aa40$a301280a@.phx.gbl...
can[vbcol=seagreen]
>
>.
>|||Jeff,
Not sure.Try reinstalling the relevant MDAC.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
<anonymous@.discussions.microsoft.com> wrote in message
news:596401c42d60$3dcafcc0$a601280a@.phx.gbl...[vbcol=seagreen]
> 2000 SP3a. Is it possible that SP3a is the problem?
> Thanks.
> service pack level
> can|||Jeff -
There are several differences in the way that Artisan and Enterprise
Manager enumerate the list of DBs-
Enterprise Manager runs 'exec sp_MSdbuseraccess N'db', N'%'' to get a list,
and Artisan runs 'SELECT name,status,' ',CONVERT(char(10),crdate,101)+'
'+SUBSTRING(CONVERT(char(20),crdate,0),1
3,7) FROM master.dbo.sysdatabases
ORDER BY 1'
There important diff here is permissions. To test, run exec
sp_MSdbuseraccess N'db', N'% in Query Analyzer as the same user you connect
using EM. I am guessing that the list will be short the same way EM is. Then
you need to fix your permissions.
Let me know if that does not help.
Craig
ccarl@.mcafee.com
"Jeffrey Wang" <jwang@.dot.state.tx.us> wrote in message
news:588b01c42d3f$2455aa40$a301280a@.phx.gbl...
> After adding 6 databases to a server for a total of 16
> databases, my Enterprise Manager won't display databases
> (the databases just disappeared).
> However, DBArtisan and Query Analyzer work fine. Both can
> display the databases. Is there a limit on the total
> number of databases EM can display? Or is this a bug in
> EM?
> TIA.
> Jeffrey

EM won't display databases

After adding 6 databases to a server for a total of 16
databases, my Enterprise Manager won't display databases
(the databases just disappeared).
However, DBArtisan and Query Analyzer work fine. Both can
display the databases. Is there a limit on the total
number of databases EM can display? Or is this a bug in
EM?
TIA.
Jeffrey
Jeff,
EM surely can handle 16.Whats the SQLServer version and service pack level
of this EM?
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jeffrey Wang" <jwang@.dot.state.tx.us> wrote in message
news:588b01c42d3f$2455aa40$a301280a@.phx.gbl...
> After adding 6 databases to a server for a total of 16
> databases, my Enterprise Manager won't display databases
> (the databases just disappeared).
> However, DBArtisan and Query Analyzer work fine. Both can
> display the databases. Is there a limit on the total
> number of databases EM can display? Or is this a bug in
> EM?
> TIA.
> Jeffrey
|||2000 SP3a. Is it possible that SP3a is the problem?
Thanks.
>--Original Message--
>Jeff,
>EM surely can handle 16.Whats the SQLServer version and
service pack level[vbcol=seagreen]
>of this EM?
>--
>Dinesh
>SQL Server MVP
>--
>--
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Jeffrey Wang" <jwang@.dot.state.tx.us> wrote in message
>news:588b01c42d3f$2455aa40$a301280a@.phx.gbl...
can
>
>.
>
|||Jeff,
Not sure.Try reinstalling the relevant MDAC.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
<anonymous@.discussions.microsoft.com> wrote in message
news:596401c42d60$3dcafcc0$a601280a@.phx.gbl...[vbcol=seagreen]
> 2000 SP3a. Is it possible that SP3a is the problem?
> Thanks.
> service pack level
> can
|||Jeff -
There are several differences in the way that Artisan and Enterprise
Manager enumerate the list of DBs-
Enterprise Manager runs 'exec sp_MSdbuseraccess N'db', N'%'' to get a list,
and Artisan runs 'SELECT name,status,' ',CONVERT(char(10),crdate,101)+'
'+SUBSTRING(CONVERT(char(20),crdate,0),13,7) FROM master.dbo.sysdatabases
ORDER BY 1'
There important diff here is permissions. To test, run exec
sp_MSdbuseraccess N'db', N'% in Query Analyzer as the same user you connect
using EM. I am guessing that the list will be short the same way EM is. Then
you need to fix your permissions.
Let me know if that does not help.
Craig
ccarl@.mcafee.com
"Jeffrey Wang" <jwang@.dot.state.tx.us> wrote in message
news:588b01c42d3f$2455aa40$a301280a@.phx.gbl...
> After adding 6 databases to a server for a total of 16
> databases, my Enterprise Manager won't display databases
> (the databases just disappeared).
> However, DBArtisan and Query Analyzer work fine. Both can
> display the databases. Is there a limit on the total
> number of databases EM can display? Or is this a bug in
> EM?
> TIA.
> Jeffrey

EM won't display databases

After adding 6 databases to a server for a total of 16
databases, my Enterprise Manager won't display databases
(the databases just disappeared).
However, DBArtisan and Query Analyzer work fine. Both can
display the databases. Is there a limit on the total
number of databases EM can display? Or is this a bug in
EM?
TIA.
JeffreyJeff,
EM surely can handle 16.Whats the SQLServer version and service pack level
of this EM?
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jeffrey Wang" <jwang@.dot.state.tx.us> wrote in message
news:588b01c42d3f$2455aa40$a301280a@.phx.gbl...
> After adding 6 databases to a server for a total of 16
> databases, my Enterprise Manager won't display databases
> (the databases just disappeared).
> However, DBArtisan and Query Analyzer work fine. Both can
> display the databases. Is there a limit on the total
> number of databases EM can display? Or is this a bug in
> EM?
> TIA.
> Jeffrey|||2000 SP3a. Is it possible that SP3a is the problem?
Thanks.
>--Original Message--
>Jeff,
>EM surely can handle 16.Whats the SQLServer version and
service pack level
>of this EM?
>--
>Dinesh
>SQL Server MVP
>--
>--
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Jeffrey Wang" <jwang@.dot.state.tx.us> wrote in message
>news:588b01c42d3f$2455aa40$a301280a@.phx.gbl...
>> After adding 6 databases to a server for a total of 16
>> databases, my Enterprise Manager won't display databases
>> (the databases just disappeared).
>> However, DBArtisan and Query Analyzer work fine. Both
can
>> display the databases. Is there a limit on the total
>> number of databases EM can display? Or is this a bug in
>> EM?
>> TIA.
>> Jeffrey
>
>.
>|||Jeff,
Not sure.Try reinstalling the relevant MDAC.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
<anonymous@.discussions.microsoft.com> wrote in message
news:596401c42d60$3dcafcc0$a601280a@.phx.gbl...
> 2000 SP3a. Is it possible that SP3a is the problem?
> Thanks.
> >--Original Message--
> >Jeff,
> >
> >EM surely can handle 16.Whats the SQLServer version and
> service pack level
> >of this EM?
> >
> >--
> >Dinesh
> >SQL Server MVP
> >--
> >--
> >SQL Server FAQ at
> >http://www.tkdinesh.com
> >
> >"Jeffrey Wang" <jwang@.dot.state.tx.us> wrote in message
> >news:588b01c42d3f$2455aa40$a301280a@.phx.gbl...
> >> After adding 6 databases to a server for a total of 16
> >> databases, my Enterprise Manager won't display databases
> >> (the databases just disappeared).
> >>
> >> However, DBArtisan and Query Analyzer work fine. Both
> can
> >> display the databases. Is there a limit on the total
> >> number of databases EM can display? Or is this a bug in
> >> EM?
> >>
> >> TIA.
> >>
> >> Jeffrey
> >
> >
> >.
> >|||Jeff -
There are several differences in the way that Artisan and Enterprise
Manager enumerate the list of DBs-
Enterprise Manager runs 'exec sp_MSdbuseraccess N'db', N'%'' to get a list,
and Artisan runs 'SELECT name,status,' ',CONVERT(char(10),crdate,101)+'
'+SUBSTRING(CONVERT(char(20),crdate,0),13,7) FROM master.dbo.sysdatabases
ORDER BY 1'
There important diff here is permissions. To test, run exec
sp_MSdbuseraccess N'db', N'% in Query Analyzer as the same user you connect
using EM. I am guessing that the list will be short the same way EM is. Then
you need to fix your permissions.
Let me know if that does not help.
Craig
ccarl@.mcafee.com
"Jeffrey Wang" <jwang@.dot.state.tx.us> wrote in message
news:588b01c42d3f$2455aa40$a301280a@.phx.gbl...
> After adding 6 databases to a server for a total of 16
> databases, my Enterprise Manager won't display databases
> (the databases just disappeared).
> However, DBArtisan and Query Analyzer work fine. Both can
> display the databases. Is there a limit on the total
> number of databases EM can display? Or is this a bug in
> EM?
> TIA.
> Jeffrey

EM wants to confirm user's password

Hi,
I'm having a problem with Enterprise Manager. The problem is that, whenever
I use EM to modify a user's SQL Server account (any modification), EM will a
sk me to confirm the user's pasword. I don't know the user passwords. A few
months ago I read about
this problem but now I can't find any info and have forgotten where I read a
bout this bug. I have other tools to use to make changes so, I haven't worri
ed about it. But now, I want to fix the bug. On my desk top I'm running SQL
2000 client tools. Our serv
ers are mostly SQL 2000 with SP3 with a few SQL 7 SP4.
Any information would be helpful.
Thanks,
JoeSounds like this may be the bug you are referring to:
FIX: You Are Prompted for Password Confirmation After You
Change a Standard SQL Server Login
http://support.microsoft.com/?kbid=826161
-Sue
On Fri, 26 Mar 2004 11:16:08 -0800, Joe <joeydba@.yahoo.com>
wrote:

>Hi,
> I'm having a problem with Enterprise Manager. The problem is that, whenever I use
EM to modify a user's SQL Server account (any modification), EM will ask me to conf
irm the user's pasword. I don't know the user passwords. A few months ago I read ab
out
this problem but now I can't find any info and have forgotten where I read a
bout this bug. I have other tools to use to make changes so, I haven't worri
ed about it. But now, I want to fix the bug. On my desk top I'm running SQL
2000 client tools. Our ser
vers are mostly SQL 2000 with SP3 with a few SQL 7 SP4.
> Any information would be helpful.
>Thanks,
>Joe

EM VS TSQL

We are using SQL 2000
Please tell me that is it not recommended to use Enterprise manager for all
operations?
Is it OK if i use EM for all backup , restore & Maintenance Plan?
Could you please provide me the TSQL for Backup , Restore & Maintenance
Plan.
Thanking you in anticipation
regards
On Wed, 29 Sep 2004 10:03:24 +0530, uppal wrote:
Hi uppal,
Already answered in microsoft.public.sqlserver.server. Please post a
question to one newsgroup only. And if you really feel that you must post
to multiple groups, then at least use the cross-posting feature of your
newsreader.
http://www.aspfaq.com/etiquette.asp?id=5003
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)

EM VS TSQL

We are using SQL 2000
Please tell me that is it not recommended to use Enterprise manager for all
operations?
Is it OK if i use EM for all backup , restore & Maintenance Plan?
Could you please provide me the TSQL for Backup , Restore & Maintenance
Plan.
Thanking you in anticipation
regards
See if this helps:
http://vyaskn.tripod.com/sql_enterpr...r_or_t-sql.htm
Also check the BACKUP and RESTORE commands in SQL Server Books Online.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"uppal" <compaq@.smil.co.in> wrote in message
news:eZItzydpEHA.1992@.TK2MSFTNGP09.phx.gbl...
We are using SQL 2000
Please tell me that is it not recommended to use Enterprise manager for all
operations?
Is it OK if i use EM for all backup , restore & Maintenance Plan?
Could you please provide me the TSQL for Backup , Restore & Maintenance
Plan.
Thanking you in anticipation
regards
|||On Wed, 29 Sep 2004 10:02:55 +0530, uppal wrote:

>Please tell me that is it not recommended to use Enterprise manager for all
>operations?
Hi Uppal,
On the contrary. EM is very suitable for *SOME* operations. Just don't use
EM for creation of tables, views, procuderes and functions or for changing
data in your tables. Using EM to manage your SQL Server installation is
okay.

>Is it OK if i use EM for all backup , restore & Maintenance Plan?
That's one of the operations that EM excels in.

>Could you please provide me the TSQL for Backup , Restore & Maintenance
>Plan.
I have no idea. If you really need to know it, you should either look in
Books Online or you could run a trace to find out which commands are
executed when you execute these operations through EM.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||"uppal" <compaq@.smil.co.in> wrote in message
news:eZItzydpEHA.1992@.TK2MSFTNGP09.phx.gbl...
> We are using SQL 2000
> Please tell me that is it not recommended to use Enterprise manager for
all
> operations?
> Is it OK if i use EM for all backup , restore & Maintenance Plan?
>
Control.
It all comes down to how much control you want.

> Could you please provide me the TSQL for Backup , Restore & Maintenance
> Plan.
> Thanking you in anticipation
> regards
>

EM VS TSQL

We are using SQL 2000
Please tell me that is it not recommended to use Enterprise manager for all
operations?
Is it OK if i use EM for all backup , restore & Maintenance Plan?
Could you please provide me the TSQL for Backup , Restore & Maintenance
Plan.
Thanking you in anticipation
regardsSee if this helps:
http://vyaskn.tripod.com/sql_enterprise_manager_or_t-sql.htm
Also check the BACKUP and RESTORE commands in SQL Server Books Online.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"uppal" <compaq@.smil.co.in> wrote in message
news:eZItzydpEHA.1992@.TK2MSFTNGP09.phx.gbl...
We are using SQL 2000
Please tell me that is it not recommended to use Enterprise manager for all
operations?
Is it OK if i use EM for all backup , restore & Maintenance Plan?
Could you please provide me the TSQL for Backup , Restore & Maintenance
Plan.
Thanking you in anticipation
regards|||On Wed, 29 Sep 2004 10:02:55 +0530, uppal wrote:
>Please tell me that is it not recommended to use Enterprise manager for all
>operations?
Hi Uppal,
On the contrary. EM is very suitable for *SOME* operations. Just don't use
EM for creation of tables, views, procuderes and functions or for changing
data in your tables. Using EM to manage your SQL Server installation is
okay.
>Is it OK if i use EM for all backup , restore & Maintenance Plan?
That's one of the operations that EM excels in.
>Could you please provide me the TSQL for Backup , Restore & Maintenance
>Plan.
I have no idea. If you really need to know it, you should either look in
Books Online or you could run a trace to find out which commands are
executed when you execute these operations through EM.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||"uppal" <compaq@.smil.co.in> wrote in message
news:eZItzydpEHA.1992@.TK2MSFTNGP09.phx.gbl...
> We are using SQL 2000
> Please tell me that is it not recommended to use Enterprise manager for
all
> operations?
> Is it OK if i use EM for all backup , restore & Maintenance Plan?
>
Control.
It all comes down to how much control you want.
> Could you please provide me the TSQL for Backup , Restore & Maintenance
> Plan.
> Thanking you in anticipation
> regards
>

EM SQL Script generation BUG?

I'm using Enterprise Manager to generate a SQL script from a database, the
intent being that I can use that script to populate a new "empty" database
instance, duplicating the schema of the source database. My source database
has a table whose name contains a space; e.g., [tblFoo Bar].
There is a relationship between this table and another and so its name is
incorporated in the constraint name; e.g., [FK ...tblFoo Bar...]. The
problem is that the EM generated DROP statement doesn't use brackets to
delimit the object name; thus an error is thrown when the generated script
is executed in OA. Note that brackets *are* used in the generated script at
the point where the constraint is (re)created.
This appears to be a bug in the script generator. Surely the generator
should generate valid SQL!!
Is this a known problem? Is there a fix?
Thanks in advance,
Bill
Oops, forgot to mention SQL Server 2000 SP3
"Bill Cohagan" <bill@.teraXNOSPAMXquest.com> wrote in message
news:%23GkQs4DjEHA.556@.tk2msftngp13.phx.gbl...
> I'm using Enterprise Manager to generate a SQL script from a database, the
> intent being that I can use that script to populate a new "empty" database
> instance, duplicating the schema of the source database. My source
database
> has a table whose name contains a space; e.g., [tblFoo Bar].
> There is a relationship between this table and another and so its name is
> incorporated in the constraint name; e.g., [FK ...tblFoo Bar...]. The
> problem is that the EM generated DROP statement doesn't use brackets to
> delimit the object name; thus an error is thrown when the generated script
> is executed in OA. Note that brackets *are* used in the generated script
at
> the point where the constraint is (re)created.
> This appears to be a bug in the script generator. Surely the generator
> should generate valid SQL!!
> Is this a known problem? Is there a fix?
> Thanks in advance,
> Bill
>
|||Hi Bill,
Thanks for sharing your pains with us!
Based on my scope, I noticed there is an known issue like this, however, I
need more information to confirm it. Would you please so kind as to provide
more information about this?
1. What's the owner of your 2 tables? All are [dbo]?
2. Could you show me an example for me how to make this issue reporduce?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||The answer to #1 is yes. I'll try to get some code to you to repro the
problem, but it'll be a couple of days.
Bill
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:6MqG4RkjEHA.2860@.cpmsftngxa10.phx.gbl...
> Hi Bill,
> Thanks for sharing your pains with us!
> Based on my scope, I noticed there is an known issue like this, however, I
> need more information to confirm it. Would you please so kind as to
> provide
> more information about this?
> 1. What's the owner of your 2 tables? All are [dbo]?
> 2. Could you show me an example for me how to make this issue reporduce?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||Cheng
Following is a SQL generated script for a simple database containing two
tables, [Table A] and [Table B] and a one to many relationship between A and
B. Note the first SQL statement containing the DROP CONSTRAINT. The
constraint name should be enclosed in [...] but is not.
If you'd like to recreated the database, wrap this name in [ ], then
execute the entire script to populate an empty database with the two tables
and relationship. Finally do a script generation and you should see the same
DROP CONSTRAINT name problem. Let me know if you have any questions.
==========================================
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[FK_Table B_Table A]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Table B] DROP CONSTRAINT FK_Table B_Table A
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table
A]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table A]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table
B]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Table B]
GO
CREATE TABLE [dbo].[Table A] (
[AID] [uniqueidentifier] NOT NULL ,
[SomeText] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Table B] (
[BID] [uniqueidentifier] NOT NULL ,
[AID] [uniqueidentifier] NOT NULL ,
[SomeInfo] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Table A] ADD
CONSTRAINT [PK_Table A] PRIMARY KEY CLUSTERED
(
[AID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Table B] ADD
CONSTRAINT [PK_Table B] PRIMARY KEY CLUSTERED
(
[BID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Table B] ADD
CONSTRAINT [FK_Table B_Table A] FOREIGN KEY
(
[AID]
) REFERENCES [dbo].[Table A] (
[AID]
)
GO
==========================================
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:6MqG4RkjEHA.2860@.cpmsftngxa10.phx.gbl...
> Hi Bill,
> Thanks for sharing your pains with us!
> Based on my scope, I noticed there is an known issue like this, however, I
> need more information to confirm it. Would you please so kind as to
> provide
> more information about this?
> 1. What's the owner of your 2 tables? All are [dbo]?
> 2. Could you show me an example for me how to make this issue reporduce?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||Hi Bill,
Thanks for your posting to let me reproduce it!
Admittedly, it is an known issue for us. There is no public document
released for this issue. Bad news from SQL Server development Team is they
won't fix this issue for SQL Server 2000 as the fix will induce rewrite of
SQL Server Enterprise Manager.
The only workaround for this is not using space in constraint name or add
the brackets manually. I am sincerely sorry for the inconvenience you may
meet from this issue.
Thanks again for your kindest providing repo scenario for us and your
corpoerations.
If you have any questions or concerns, don't hesitate to let me know. We
are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Thanks for looking into this; though I can hardly imagine fixing the problem
would require a "rewrite of SQL Server Enterprise Manager" -- since the tool
already does the right thing when *creating* the constraint; i.e., the
failure is only when DROPping the old constraint.
Unfortunately in my case I have no control over the database schema as I'm
supplying a tool to generate code using the MS generated SQL code as input.
I suppose I can just tell my customers that SQL Server 2000 simply does not
support blanks in table names -- at least if you want to generate scripts,
but I doubt their reaction will be pleasant.
I would appreciate it if you'd get another reading from the Enterprise
Manager folks because I really think this fix is probably pretty simple. The
only reason I can imagine it to be a "rewrite" would be if Microsoft has
misplaced the source code!
Also, until/unless this gets fixed it'd save everyone time were it
documented in the KB.
Regards,
Bill
PS - Perhaps I should have targeted my product at Oracle! ;-)
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:tTueemxmEHA.752@.cpmsftngxa06.phx.gbl...
> Hi Bill,
> Thanks for your posting to let me reproduce it!
> Admittedly, it is an known issue for us. There is no public document
> released for this issue. Bad news from SQL Server development Team is they
> won't fix this issue for SQL Server 2000 as the fix will induce rewrite of
> SQL Server Enterprise Manager.
> The only workaround for this is not using space in constraint name or add
> the brackets manually. I am sincerely sorry for the inconvenience you may
> meet from this issue.
> Thanks again for your kindest providing repo scenario for us and your
> corpoerations.
> If you have any questions or concerns, don't hesitate to let me know. We
> are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||Hi Bill,
I understood that this issue may make a big business impact for you. If so,
I would like to suggest you ask for a direct assistance from a Microsoft
Support Professional through Microsoft Product Support Services. They may
find a better workaround for you. You can contact Microsoft Product Support
directly to discuss additional support options you may have available, by
contacting us at 1-(800)936-5800 or by choosing one of the options listed
at http://support.microsoft.com/default...=sz;en-us;top.
I am afraid the development of SQL Server Enterprise Manager might be
easier to think than to do. As I had said, the workaround for this is not
using space in constraint name or add the brackets manually. I am sincerely
sorry again for the inconvenience you may meet from this issue.
Thank you for your patience and cooperation.
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||OK. Thanks for working with me on this problem.
Regards,
Bill
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:B9wHeN8mEHA.752@.cpmsftngxa06.phx.gbl...
> Hi Bill,
> I understood that this issue may make a big business impact for you. If
so,
> I would like to suggest you ask for a direct assistance from a Microsoft
> Support Professional through Microsoft Product Support Services. They may
> find a better workaround for you. You can contact Microsoft Product
Support
> directly to discuss additional support options you may have available, by
> contacting us at 1-(800)936-5800 or by choosing one of the options listed
> at http://support.microsoft.com/default...=sz;en-us;top.
> I am afraid the development of SQL Server Enterprise Manager might be
> easier to think than to do. As I had said, the workaround for this is not
> using space in constraint name or add the brackets manually. I am
sincerely
> sorry again for the inconvenience you may meet from this issue.
> Thank you for your patience and cooperation.
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>

EM Script Error

I've have a minor problem with my enterprise manager. Whenever I try to look at the database screen I get the following pop-up, and then it just leaves the screen saying "Loading Database Information"

I tried a ground up re-install of the EM, no joy. I'm running a Dell GX260 with WinXP SP1.

Any ideas. It's just an annoyance.Think there is a problem with SQL installation. Try re-installing the SQL.|||I did re-install the SQL. Still no luck.|||do onething, open any other MMC and add SQL Server in that.|||Same error. :(|||Then there is a problem with your service pack.

EM question....

How to know how the SQL Server is registered (Windows/SQL Authentication) in
Enterprise Manager?
SQL Server 2005.
Thank you,
JohnRight-click on the server in EM and then click on Edit SQL Server
Registration Properties.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"John Smith" <JohnSmithAl@.hotmail.com> wrote in message
news:uzDPXro%23FHA.2876@.TK2MSFTNGP10.phx.gbl...
> How to know how the SQL Server is registered (Windows/SQL Authentication)
> in
> Enterprise Manager?
> SQL Server 2005.
> Thank you,
> John
>
>
>
>|||Thank you.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23o5aPto%23FHA.3676@.tk2msftngp13.phx.gbl...
> Right-click on the server in EM and then click on Edit SQL Server
> Registration Properties.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada tom@.cips.ca
> www.pinpub.com
> "John Smith" <JohnSmithAl@.hotmail.com> wrote in message
> news:uzDPXro%23FHA.2876@.TK2MSFTNGP10.phx.gbl...
> > How to know how the SQL Server is registered (Windows/SQL
Authentication)
> > in
> > Enterprise Manager?
> >
> > SQL Server 2005.
> >
> > Thank you,
> >
> > John
> >
> >
> >
> >
> >
> >
> >
>

EM query strange behavior

In the Enterprise Manager query tool, a query (the date entered in the
criteria field as 31.03.05) displays as an SQL statement:
SELECT *
FROM [TABLE]
WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
and yields the expected results.
However, changing query type to
DELETE FROM [SAME TABLE AS ABOVE]
WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
results in the opposite of what is to be expected - all records where
TRANS_DATE < [the entered time] is deleted.
The TRANS_DATE field is of type DATETIME, and I cannot see that there are
any properties either in the field or the table that separates it from all
my other DATETIME fields in any other tables, where this bizarre delete
action does not occur.
I assume this has to do with some configuration of the automatic
timeconversion that happens in the tool itself, but how to change this
conversion setting so as to produce more desired delete results?
And how is it that it only happens with data from one single table'
Thanks for answering.
Message posted via http://www.droptable.comHi
What happens when you run this:
DELETE FROM [SAME TABLE AS ABOVE]
WHERE (TRANS_DATE > '2005-03-31 00:00:00'
Regards
Mike
"Knut Bohn via droptable.com" wrote:

> In the Enterprise Manager query tool, a query (the date entered in the
> criteria field as 31.03.05) displays as an SQL statement:
> SELECT *
> FROM [TABLE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> and yields the expected results.
> However, changing query type to
> DELETE FROM [SAME TABLE AS ABOVE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> results in the opposite of what is to be expected - all records where
> TRANS_DATE < [the entered time] is deleted.
> The TRANS_DATE field is of type DATETIME, and I cannot see that there are
> any properties either in the field or the table that separates it from all
> my other DATETIME fields in any other tables, where this bizarre delete
> action does not occur.
> I assume this has to do with some configuration of the automatic
> timeconversion that happens in the tool itself, but how to change this
> conversion setting so as to produce more desired delete results?
> And how is it that it only happens with data from one single table'
> Thanks for answering.
> --
> Message posted via http://www.droptable.com
>|||Knut
I dont uderstand you.
> In the Enterprise Manager query tool, a query (the date entered in the
> criteria field as 31.03.05) displays as an SQL statement:
You said that the table's column is defined as datetime datatype and data
was entered as 31.03.05 which is thrown the error
--insert into table1 values ('31.03.05')
"The conversion of a char data type to a datetime data type resulted in an
out-of-range datetime value.
The statement has been terminated."
"Knut Bohn via droptable.com" <forum@.nospam.droptable.com> wrote in
message news:b10f4c5d93df49c6b3c31bee2a957db0@.SQ
droptable.com...
> In the Enterprise Manager query tool, a query (the date entered in the
> criteria field as 31.03.05) displays as an SQL statement:
> SELECT *
> FROM [TABLE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> and yields the expected results.
> However, changing query type to
> DELETE FROM [SAME TABLE AS ABOVE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> results in the opposite of what is to be expected - all records where
> TRANS_DATE < [the entered time] is deleted.
> The TRANS_DATE field is of type DATETIME, and I cannot see that there are
> any properties either in the field or the table that separates it from all
> my other DATETIME fields in any other tables, where this bizarre delete
> action does not occur.
> I assume this has to do with some configuration of the automatic
> timeconversion that happens in the tool itself, but how to change this
> conversion setting so as to produce more desired delete results?
> And how is it that it only happens with data from one single table'
> Thanks for answering.
> --
> Message posted via http://www.droptable.com|||Mike;
Same thing - deletes records with TRANS_DATE < entered value.
What's really bizzarre is that there's another datetime column in the
table, and running a delete with criteria filtered against those date
values yields the expected result.
Again, I really can't spot any differences in the respective data
properties of these two columns.
Uri;
I don't think I follow what you're getting at? The SELECT runs fine with
the date criteria entered as 31.03.05, but somehow things go off
differently with no other change thatn replacing SELECT with DELETE.
Message posted via http://www.droptable.com|||Hi
I did some test
CREATE TABLE #Test
(
col DATETIME
)
INSERT INTO #Test VALUES ('20050331')--Proper format to insert datetime
INSERT INTO #Test VALUES ('20050401')
INSERT INTO #Test VALUES ('20050328')
DELETE FROM #Test WHERE col>'20050331'--Deletes 1 row
SELECT* FROM #Test--Everything is ok
DROP TABLE #Test
--Another repro
CREATE TABLE #Test
(
col VARCHAR(30)
)
INSERT INTO #Test VALUES ('31.03.05')--with datetime this insert will be
failed
INSERT INTO #Test VALUES ('28.03.05')--with datetime this insert will be
failed
INSERT INTO #Test VALUES ('01.04.05')--with datetime this insert will be
failed
DELETE FROM #Test WHERE col>CONVERT(DATETIME,'2005-03-31',102)--Error is
thrown
SELECT CONVERT(DATETIME,REPLACE(col,'.',''),102) FROM #Test
--2031-03-05 00:00:00.000
--2028-03-05 00:00:00.000
--2001-04-05 00:00:00.000
--That's why it deletes wrong data
DELETE FROM #Test WHERE CONVERT(DATETIME,REPLACE(col,'.',''),112)
>CONVERT(DATETIME,'2005-03-31',102)
SELECT* FROM #Test
DROP TABLE #Test
"Knut Bohn via droptable.com" <forum@.droptable.com> wrote in message
news:c446a5e8529b4bc49709d20ca6d2518d@.SQ
droptable.com...
> Mike;
> Same thing - deletes records with TRANS_DATE < entered value.
> What's really bizzarre is that there's another datetime column in the
> table, and running a delete with criteria filtered against those date
> values yields the expected result.
> Again, I really can't spot any differences in the respective data
> properties of these two columns.
> Uri;
> I don't think I follow what you're getting at? The SELECT runs fine with
> the date criteria entered as 31.03.05, but somehow things go off
> differently with no other change thatn replacing SELECT with DELETE.
> --
> Message posted via http://www.droptable.com|||Uri,
Thaanks for taking the time to test this. However, I don't think it
explains the criteria oddity that occurs when in the query changing from
SELECT to DELETE?
best,
knut
Message posted via http://www.droptable.com

EM query strange behavior

In the Enterprise Manager query tool, a query (the date entered in the
criteria field as 31.03.05) displays as an SQL statement:
SELECT *
FROM [TABLE]
WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
and yields the expected results.
However, changing query type to
DELETE FROM [SAME TABLE AS ABOVE]
WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
results in the opposite of what is to be expected - all records where
TRANS_DATE < [the entered time] is deleted.
The TRANS_DATE field is of type DATETIME, and I cannot see that there are
any properties either in the field or the table that separates it from all
my other DATETIME fields in any other tables, where this bizarre delete
action does not occur.
I assume this has to do with some configuration of the automatic
timeconversion that happens in the tool itself, but how to change this
conversion setting so as to produce more desired delete results?
And how is it that it only happens with data from one single table?
Thanks for answering.
Message posted via http://www.droptable.com
Hi
What happens when you run this:
DELETE FROM [SAME TABLE AS ABOVE]
WHERE (TRANS_DATE > '2005-03-31 00:00:00'
Regards
Mike
"Knut Bohn via droptable.com" wrote:

> In the Enterprise Manager query tool, a query (the date entered in the
> criteria field as 31.03.05) displays as an SQL statement:
> SELECT *
> FROM [TABLE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> and yields the expected results.
> However, changing query type to
> DELETE FROM [SAME TABLE AS ABOVE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> results in the opposite of what is to be expected - all records where
> TRANS_DATE < [the entered time] is deleted.
> The TRANS_DATE field is of type DATETIME, and I cannot see that there are
> any properties either in the field or the table that separates it from all
> my other DATETIME fields in any other tables, where this bizarre delete
> action does not occur.
> I assume this has to do with some configuration of the automatic
> timeconversion that happens in the tool itself, but how to change this
> conversion setting so as to produce more desired delete results?
> And how is it that it only happens with data from one single table?
> Thanks for answering.
> --
> Message posted via http://www.droptable.com
>
|||Knut
I dont uderstand you.
> In the Enterprise Manager query tool, a query (the date entered in the
> criteria field as 31.03.05) displays as an SQL statement:
You said that the table's column is defined as datetime datatype and data
was entered as 31.03.05 which is thrown the error
--insert into table1 values ('31.03.05')
"The conversion of a char data type to a datetime data type resulted in an
out-of-range datetime value.
The statement has been terminated."
"Knut Bohn via droptable.com" <forum@.nospam.droptable.com> wrote in
message news:b10f4c5d93df49c6b3c31bee2a957db0@.droptable.co m...
> In the Enterprise Manager query tool, a query (the date entered in the
> criteria field as 31.03.05) displays as an SQL statement:
> SELECT *
> FROM [TABLE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> and yields the expected results.
> However, changing query type to
> DELETE FROM [SAME TABLE AS ABOVE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> results in the opposite of what is to be expected - all records where
> TRANS_DATE < [the entered time] is deleted.
> The TRANS_DATE field is of type DATETIME, and I cannot see that there are
> any properties either in the field or the table that separates it from all
> my other DATETIME fields in any other tables, where this bizarre delete
> action does not occur.
> I assume this has to do with some configuration of the automatic
> timeconversion that happens in the tool itself, but how to change this
> conversion setting so as to produce more desired delete results?
> And how is it that it only happens with data from one single table?
> Thanks for answering.
> --
> Message posted via http://www.droptable.com
|||Mike;
Same thing - deletes records with TRANS_DATE < entered value.
What's really bizzarre is that there's another datetime column in the
table, and running a delete with criteria filtered against those date
values yields the expected result.
Again, I really can't spot any differences in the respective data
properties of these two columns.
Uri;
I don't think I follow what you're getting at? The SELECT runs fine with
the date criteria entered as 31.03.05, but somehow things go off
differently with no other change thatn replacing SELECT with DELETE.
Message posted via http://www.droptable.com
|||Hi
I did some test
CREATE TABLE #Test
(
col DATETIME
)
INSERT INTO #Test VALUES ('20050331')--Proper format to insert datetime
INSERT INTO #Test VALUES ('20050401')
INSERT INTO #Test VALUES ('20050328')
DELETE FROM #Test WHERE col>'20050331'--Deletes 1 row
SELECT* FROM #Test--Everything is ok
DROP TABLE #Test
--Another repro
CREATE TABLE #Test
(
col VARCHAR(30)
)
INSERT INTO #Test VALUES ('31.03.05')--with datetime this insert will be
failed
INSERT INTO #Test VALUES ('28.03.05')--with datetime this insert will be
failed
INSERT INTO #Test VALUES ('01.04.05')--with datetime this insert will be
failed
DELETE FROM #Test WHERE col>CONVERT(DATETIME,'2005-03-31',102)--Error is
thrown
SELECT CONVERT(DATETIME,REPLACE(col,'.',''),102) FROM #Test
--2031-03-05 00:00:00.000
--2028-03-05 00:00:00.000
--2001-04-05 00:00:00.000
--That's why it deletes wrong data
DELETE FROM #Test WHERE CONVERT(DATETIME,REPLACE(col,'.',''),112)
>CONVERT(DATETIME,'2005-03-31',102)
SELECT* FROM #Test
DROP TABLE #Test
"Knut Bohn via droptable.com" <forum@.droptable.com> wrote in message
news:c446a5e8529b4bc49709d20ca6d2518d@.droptable.co m...
> Mike;
> Same thing - deletes records with TRANS_DATE < entered value.
> What's really bizzarre is that there's another datetime column in the
> table, and running a delete with criteria filtered against those date
> values yields the expected result.
> Again, I really can't spot any differences in the respective data
> properties of these two columns.
> Uri;
> I don't think I follow what you're getting at? The SELECT runs fine with
> the date criteria entered as 31.03.05, but somehow things go off
> differently with no other change thatn replacing SELECT with DELETE.
> --
> Message posted via http://www.droptable.com
|||Uri,
Thaanks for taking the time to test this. However, I don't think it
explains the criteria oddity that occurs when in the query changing from
SELECT to DELETE?
best,
knut
Message posted via http://www.droptable.com

EM query strange behavior

In the Enterprise Manager query tool, a query (the date entered in the
criteria field as 31.03.05) displays as an SQL statement:
SELECT *
FROM [TABLE]
WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
and yields the expected results.
However, changing query type to
DELETE FROM [SAME TABLE AS ABOVE]
WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
results in the opposite of what is to be expected - all records where
TRANS_DATE < [the entered time] is deleted.
The TRANS_DATE field is of type DATETIME, and I cannot see that there are
any properties either in the field or the table that separates it from all
my other DATETIME fields in any other tables, where this bizarre delete
action does not occur.
I assume this has to do with some configuration of the automatic
timeconversion that happens in the tool itself, but how to change this
conversion setting so as to produce more desired delete results?
And how is it that it only happens with data from one single table'
Thanks for answering.
--
Message posted via http://www.sqlmonster.comHi
What happens when you run this:
DELETE FROM [SAME TABLE AS ABOVE]
WHERE (TRANS_DATE > '2005-03-31 00:00:00'
Regards
Mike
"Knut Bohn via SQLMonster.com" wrote:
> In the Enterprise Manager query tool, a query (the date entered in the
> criteria field as 31.03.05) displays as an SQL statement:
> SELECT *
> FROM [TABLE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> and yields the expected results.
> However, changing query type to
> DELETE FROM [SAME TABLE AS ABOVE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> results in the opposite of what is to be expected - all records where
> TRANS_DATE < [the entered time] is deleted.
> The TRANS_DATE field is of type DATETIME, and I cannot see that there are
> any properties either in the field or the table that separates it from all
> my other DATETIME fields in any other tables, where this bizarre delete
> action does not occur.
> I assume this has to do with some configuration of the automatic
> timeconversion that happens in the tool itself, but how to change this
> conversion setting so as to produce more desired delete results?
> And how is it that it only happens with data from one single table'
> Thanks for answering.
> --
> Message posted via http://www.sqlmonster.com
>|||Knut
I dont uderstand you.
> In the Enterprise Manager query tool, a query (the date entered in the
> criteria field as 31.03.05) displays as an SQL statement:
You said that the table's column is defined as datetime datatype and data
was entered as 31.03.05 which is thrown the error
--insert into table1 values ('31.03.05')
"The conversion of a char data type to a datetime data type resulted in an
out-of-range datetime value.
The statement has been terminated."
"Knut Bohn via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in
message news:b10f4c5d93df49c6b3c31bee2a957db0@.SQLMonster.com...
> In the Enterprise Manager query tool, a query (the date entered in the
> criteria field as 31.03.05) displays as an SQL statement:
> SELECT *
> FROM [TABLE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> and yields the expected results.
> However, changing query type to
> DELETE FROM [SAME TABLE AS ABOVE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> results in the opposite of what is to be expected - all records where
> TRANS_DATE < [the entered time] is deleted.
> The TRANS_DATE field is of type DATETIME, and I cannot see that there are
> any properties either in the field or the table that separates it from all
> my other DATETIME fields in any other tables, where this bizarre delete
> action does not occur.
> I assume this has to do with some configuration of the automatic
> timeconversion that happens in the tool itself, but how to change this
> conversion setting so as to produce more desired delete results?
> And how is it that it only happens with data from one single table'
> Thanks for answering.
> --
> Message posted via http://www.sqlmonster.com|||Mike;
Same thing - deletes records with TRANS_DATE < entered value.
What's really bizzarre is that there's another datetime column in the
table, and running a delete with criteria filtered against those date
values yields the expected result.
Again, I really can't spot any differences in the respective data
properties of these two columns.
Uri;
I don't think I follow what you're getting at? The SELECT runs fine with
the date criteria entered as 31.03.05, but somehow things go off
differently with no other change thatn replacing SELECT with DELETE.
--
Message posted via http://www.sqlmonster.com|||Hi
I did some test
CREATE TABLE #Test
(
col DATETIME
)
INSERT INTO #Test VALUES ('20050331')--Proper format to insert datetime
INSERT INTO #Test VALUES ('20050401')
INSERT INTO #Test VALUES ('20050328')
DELETE FROM #Test WHERE col>'20050331'--Deletes 1 row
SELECT* FROM #Test--Everything is ok
DROP TABLE #Test
--Another repro
CREATE TABLE #Test
(
col VARCHAR(30)
)
INSERT INTO #Test VALUES ('31.03.05')--with datetime this insert will be
failed
INSERT INTO #Test VALUES ('28.03.05')--with datetime this insert will be
failed
INSERT INTO #Test VALUES ('01.04.05')--with datetime this insert will be
failed
DELETE FROM #Test WHERE col>CONVERT(DATETIME,'2005-03-31',102)--Error is
thrown
SELECT CONVERT(DATETIME,REPLACE(col,'.',''),102) FROM #Test
--2031-03-05 00:00:00.000
--2028-03-05 00:00:00.000
--2001-04-05 00:00:00.000
--That's why it deletes wrong data
DELETE FROM #Test WHERE CONVERT(DATETIME,REPLACE(col,'.',''),112)
>CONVERT(DATETIME,'2005-03-31',102)
SELECT* FROM #Test
DROP TABLE #Test
"Knut Bohn via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:c446a5e8529b4bc49709d20ca6d2518d@.SQLMonster.com...
> Mike;
> Same thing - deletes records with TRANS_DATE < entered value.
> What's really bizzarre is that there's another datetime column in the
> table, and running a delete with criteria filtered against those date
> values yields the expected result.
> Again, I really can't spot any differences in the respective data
> properties of these two columns.
> Uri;
> I don't think I follow what you're getting at? The SELECT runs fine with
> the date criteria entered as 31.03.05, but somehow things go off
> differently with no other change thatn replacing SELECT with DELETE.
> --
> Message posted via http://www.sqlmonster.com|||Uri,
Thaanks for taking the time to test this. However, I don't think it
explains the criteria oddity that occurs when in the query changing from
SELECT to DELETE?
best,
knut
--
Message posted via http://www.sqlmonster.com

EM losing Server registrations in XP

Hi all
Every time we change a users password in XP Pro, the
client PC looses all of the Server registrations within
SQL 2000 Enterprise Manger.
Anyone else experienced this, and found any solution to it.
CheersFIX: Registered Remote Servers Disappear from SQL Enterprise Manager in
Windows XP When Non-Domain User Password is Changed
http://support.microsoft.com/?id=323280
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:119e201c3f614$b9bc73a0$a101280a@.phx
.gbl...
> Hi all
> Every time we change a users password in XP Pro, the
> client PC looses all of the Server registrations within
> SQL 2000 Enterprise Manger.
> Anyone else experienced this, and found any solution to it.
> Cheers
>|||Thanks
We are running with SP3 already installed.
I will however give the registry tweak a go and see if it
makes a difference
Cheers
>--Original Message--
>FIX: Registered Remote Servers Disappear from SQL
Enterprise Manager in
>Windows XP When Non-Domain User Password is Changed
>http://support.microsoft.com/?id=323280
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
><anonymous@.discussions.microsoft.com> wrote in message
> news:119e201c3f614$b9bc73a0$a101280a@.phx
.gbl...
it.
>
>.
>

EM locks up

On certain occasions, when I'm running a long-running query in Query
Analyzer, I can't get in to Enterprise Manager. What happens is the list of
tables can't be enumerated until the long-running query finishes. What's
odd to me is that the query only affects 1 or 2 tables. So why can't I get
into EM until this job finishes?
Thanks, Andre
Hi,
This might be because your ISQLW.EXE in client machine will be using the
CPU and Memory fully. If you have better processor PIII or higher +
512 MB ram you should have such issues.
Check your virtual memory definition in your client machine. Always try to
run the long running queries in text result mode.
Thanks
Hari
MCDBA
"Andre" <AndreGetsEnoughSPAM@.nospam.com> wrote in message
news:#O07UKgLEHA.1556@.TK2MSFTNGP10.phx.gbl...
> On certain occasions, when I'm running a long-running query in Query
> Analyzer, I can't get in to Enterprise Manager. What happens is the list
of
> tables can't be enumerated until the long-running query finishes. What's
> odd to me is that the query only affects 1 or 2 tables. So why can't I
get
> into EM until this job finishes?
> Thanks, Andre
>
|||Actually, the long-running query is running on a different box. For
example, if you and I were in the same office, and I was running the query,
you might not be able to get into EM.
Andre
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23udrVlgLEHA.1032@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Hi,
> This might be because your ISQLW.EXE in client machine will be using the
> CPU and Memory fully. If you have better processor PIII or higher +
> 512 MB ram you should have such issues.
> Check your virtual memory definition in your client machine. Always try to
> run the long running queries in text result mode.
> Thanks
> Hari
> MCDBA
>
>
> "Andre" <AndreGetsEnoughSPAM@.nospam.com> wrote in message
> news:#O07UKgLEHA.1556@.TK2MSFTNGP10.phx.gbl...
list[vbcol=seagreen]
> of
What's
> get
>
|||Hi,
Means , you will be able to open the enterprise manager, but while expanding
your SQL Server it just hangs..
Can you check the SQLSERVR.exe CPU usage in server. If it is 100% then the
performance will be slow and cause a time out. The CPU usage in the log
running query can be minimized by tuning the query by effect sql statement
and adding proper indexes.
Did you installed SP3 in SQL server machine. If not install SP3.
Thanks
Hari
MCDBA
"Andre" <AndreGetsEnoughSPAM@.nospam.com> wrote in message
news:ep0$dzgLEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Actually, the long-running query is running on a different box. For
> example, if you and I were in the same office, and I was running the
query,[vbcol=seagreen]
> you might not be able to get into EM.
> Andre
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23udrVlgLEHA.1032@.tk2msftngp13.phx.gbl...
the[vbcol=seagreen]
to[vbcol=seagreen]
> list
> What's
I
>
|||sp3a was installed shortly after it was released. Yes, I (or other users)
can launch EM, can expand the server, but can't get a list of tables when
trying to expand the tables folder. Query analyzer works just fine. CPU
usage on the server is typically low when this is happening. sp_who2 shows
that the long running query is blocking the EM process. I just can't figure
out why a query that "might" have a lock on a table would prevent the list
of tables from being displayed in EM.
Andre
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:ODjXezpLEHA.3052@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Means , you will be able to open the enterprise manager, but while
expanding[vbcol=seagreen]
> your SQL Server it just hangs..
> Can you check the SQLSERVR.exe CPU usage in server. If it is 100% then the
> performance will be slow and cause a time out. The CPU usage in the log
> running query can be minimized by tuning the query by effect sql statement
> and adding proper indexes.
> Did you installed SP3 in SQL server machine. If not install SP3.
> Thanks
> Hari
> MCDBA
> "Andre" <AndreGetsEnoughSPAM@.nospam.com> wrote in message
> news:ep0$dzgLEHA.3292@.TK2MSFTNGP11.phx.gbl...
> query,
> the
try[vbcol=seagreen]
> to
can't
> I
>
|||Hi,
Do you have the problem yet? I am having a similar problem. I have 2 machines:
1 .- SQL server 2000 + SP3, without problems
2 .- SQL Server 2000 + SP3a, with performance problems
I am reinstalling Sql server + SP3 and I am testing machine 1. I am sending you information.
Lina
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...