Embedding SQL Server Express in the installer

Can we embed the SQL Server Express in the windows installer jsut like the XML files or the Ms access database?You are referring to the windows installer in VS 2005 I suppose ??
It is not possible in the installer of VS 2003, but I suppose it can be done with Whidbey ... I haven't tried it yet though ...|||The following information may provide clarification regarding the same;

Can I redistribute SQL Express?
http://blogs.msdn.com/sqlexpress/archive/2004/07/04/172952.aspx

Embedding reports in Winform App...

I am looking for options for rendering RDLs in a .Net 1.1 Windows Forms
application using SQL Server 2K.
Thanks everyone.Use fyiReporting component (http://www.fyireporting.com). Is open source and
read RDL files with Windows Forms Viewer component.
[]s
"Terry Mulvany" <terry.mulvany@.rouseservices.com> escreveu na mensagem
news:eh4oCnMqFHA.2072@.TK2MSFTNGP14.phx.gbl...
>I am looking for options for rendering RDLs in a .Net 1.1 Windows Forms
>application using SQL Server 2K.
> Thanks everyone.
>|||Thanks Pedro, do you or anyone else know of any similar 3rd party (pay or
open source) components that actually use the infrastructure of SQL Server
Reporting Services (i.e. ReportServer web service and it's corresponding
security) rather than just simply being able to load an RDL file and view it
as the FYIReporting stuff does.
(I know .Net 2.0 and Yukon will support this but we do not have that as an
option)
Thanks all.
-Terry
"Pedro Jr." <pedro.alvesjr@.gmail.com> wrote in message
news:epT5CvMqFHA.2776@.TK2MSFTNGP10.phx.gbl...
> Use fyiReporting component (http://www.fyireporting.com). Is open source
> and read RDL files with Windows Forms Viewer component.
> []s
>
> "Terry Mulvany" <terry.mulvany@.rouseservices.com> escreveu na mensagem
> news:eh4oCnMqFHA.2072@.TK2MSFTNGP14.phx.gbl...
>>I am looking for options for rendering RDLs in a .Net 1.1 Windows Forms
>>application using SQL Server 2K.
>> Thanks everyone.
>|||You can use web services to return a stream rendered how you want and then
display that (pdf, excel, html, etc). Or you can use URL integration. Put a
IE browser control and set its URL appropriately. With .Net 2.0 where will
be a winform control which will make all of this extremely easy.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Terry Mulvany" <terry.mulvany@.rouseservices.com> wrote in message
news:eh4oCnMqFHA.2072@.TK2MSFTNGP14.phx.gbl...
>I am looking for options for rendering RDLs in a .Net 1.1 Windows Forms
>application using SQL Server 2K.
> Thanks everyone.
>

Embedding plug-ins in Reports

Hi,
I am trying to figure out the way to embed a plug-in (Chime for Windows)
into my report, so that I can display a certain object from a database, that
is stored there as a string. This Chime plug-in would read the input string
and convert it to video display.
This embedding is easily done in simple HTML:
<embed type='chemical/x-mdl-molfile' display2d=true width=200 height=200
hlabels2d='terminalhetero' structure= [encrypted string from the database
follows]>
I am wondering is there a way to do such embedding straight into my report
by using the report designer features or by modifying an RDL file for my
report?
Thank you.
Anton Bagayev,
TransForm Pharmaceuticals, Inc.
29 Hartwell Avenue
Lexington, MA 02421Or even simpler, is it possible to embed an HTML in a report.
That would be an exiting idea.
Thanks in advance.
Anton.
"Anton" wrote:
> Hi,
> I am trying to figure out the way to embed a plug-in (Chime for Windows)
> into my report, so that I can display a certain object from a database, that
> is stored there as a string. This Chime plug-in would read the input string
> and convert it to video display.
> This embedding is easily done in simple HTML:
> <embed type='chemical/x-mdl-molfile' display2d=true width=200 height=200
> hlabels2d='terminalhetero' structure= [encrypted string from the database
> follows]>
> I am wondering is there a way to do such embedding straight into my report
> by using the report designer features or by modifying an RDL file for my
> report?
> Thank you.
> Anton Bagayev,
> TransForm Pharmaceuticals, Inc.
> 29 Hartwell Avenue
> Lexington, MA 02421sql

Embedding an object into report

Hi,

I am trying to figure out the way to embed a plug-in (Chime for Windows)
into my report, so that I can display a certain object from a database, that
is stored there as a string. This Chime plug-in would read the input string
and convert it to video display.
This embedding is easily done in simple HTML:
<embed type='chemical/x-mdl-molfile' display2d=true width=200 height=200
hlabels2d='terminalhetero' structure= [encrypted string from the database
follows]>

I am wondering is there a way to do such embedding straight into my report
by using the report designer features or by modifying an RDL file for my
report?
If I am able to place my <embed...> string somewhere in my report and when the report is rendered as HTML this string is interpreted as an HTML tag, this would be awesome! So far I experimented with displaying <embed...> string in one of my textboxes, but HTML renderer for report obviously interprets my string as a text not as a tag, so instead of seeing plug-in in action I just see the text of my string.

Probably another approach would be to embed an HTML in a report.
That would also be an exiting idea.
I would appreciate any help on this.
Thanks in advance!
Anton.Reporting Services does not support embedded HTML or object tags. The only way you could do this is to post-process the resulting output.|||

Hello,

Can you detail the approach to be taken, please?

Thanks

Embedding an object into report

Hi,

I am trying to figure out the way to embed a plug-in (Chime for Windows)
into my report, so that I can display a certain object from a database, that
is stored there as a string. This Chime plug-in would read the input string
and convert it to video display.
This embedding is easily done in simple HTML:
<embed type='chemical/x-mdl-molfile' display2d=true width=200 height=200
hlabels2d='terminalhetero' structure= [encrypted string from the database
follows]>

I am wondering is there a way to do such embedding straight into my report
by using the report designer features or by modifying an RDL file for my
report?
If I am able to place my <embed...> string somewhere in my report and when the report is rendered as HTML this string is interpreted as an HTML tag, this would be awesome! So far I experimented with displaying <embed...> string in one of my textboxes, but HTML renderer for report obviously interprets my string as a text not as a tag, so instead of seeing plug-in in action I just see the text of my string.

Probably another approach would be to embed an HTML in a report.
That would also be an exiting idea.
I would appreciate any help on this.
Thanks in advance!
Anton.Reporting Services does not support embedded HTML or object tags. The only way you could do this is to post-process the resulting output.|||

Hello,

Can you detail the approach to be taken, please?

Thanks

email using

hi
can any one guide me, how to send email using stored procedure in sql server
2000 in windows 2003 o/s without using mail client installed on server.
Thanks
KalyanUse xp_smtp_sendmail, all you need is the ability to install an extended
procedure, and an SMTP server you can control.
http://www.aspfaq.com/2403
"Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
news:6CF632BE-9936-4E86-8477-297EBEFC952A@.microsoft.com...
> hi
> can any one guide me, how to send email using stored procedure in sql
> server
> 2000 in windows 2003 o/s without using mail client installed on server.
> Thanks
> Kalyan
>|||Aaron
My operating system is windows 2003, Is smtp comes with IIS?
Thanks
Kalyan
"Aaron Bertrand [SQL Server MVP]" wrote:

> Use xp_smtp_sendmail, all you need is the ability to install an extended
> procedure, and an SMTP server you can control.
> http://www.aspfaq.com/2403
>
> "Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
> news:6CF632BE-9936-4E86-8477-297EBEFC952A@.microsoft.com...
>
>|||> My operating system is windows 2003, Is smtp comes with IIS?
IIS has its own SMTP server, so yes, I guess it is compatible. However, you
do not have to have SMTP running on the same server as SQL Server, in fact I
recommend it be separate.

Email Subscriptions in Sql Server 2000 Reporting Services

Hi,

I have changed my Reporting services from Windows Security to Forms Security. When I deploy reports on the local SQL server, a windows pops up. This windows requires my username and password for the report server. After I input them, everything works fine.

However, When I deploy reports to the above server from the different SQL server located on a different computer, the windows always pops up, although I type the same username and same password. Any ideas?

Thanks a lot.Is this a Windows dialog box from IE? If so, have you enabled anonymous access to the ReportServer and Reports virtual directories in the IIS management console?This is one of the pre-requisites for making forms authentication work.

Thanks
Tudor|||Hi,

Yes, I have already changed them on the computer where my reporting server is located. In fact, I have succeeded in implementing Forms security locally. Like what I described in my question post, after my inputing username and password, local deploying is fine. But when I deploy from another computer, after my inputer the same username and password, the poped-up windows is still there.

Moreover, I also encountered another problem. When email-subscription works under windows security, but it doesn't work under forms security. The error is "Object reference not set to an instance of an object."

Any ideas about them?

Thanks a lot.|||Urgent. any ideas?|||

Check whether the error comes from the (modified) sample code. For instance the sample implementation of GetUserInfo checks for the existence of the HttpContext and returns null if it's not present.
If you have changed that, it would be possible that it could fail when running the report as part of a subscription.

Thanks
Tudor

|||How do you enable anonymous access to the ReportServer? I have an application that references the URL of the report. It is also prompting for credentials. I would really not like to pass the login and password through. Currently we are using one standard user name and password.

Thanks in advance!|||You enable anonymous in the IIS settings. Note, security will effectively be disabled at this point.|||I received a differnent error while using the Forms Extension with SQL REporting Services 2005 when trying to use email subscriptions. The error I received is "

The Forms extension failed to read its configuration settings from the RSReportServer.config configuration file. The extension is not available to users."

Any ideas

Thanks

|||

Hi ,

I have configured SMTP server and i have done email subscription to particular customer called "tbs".The report generates daily at 9:00pm and report will be sent to customer's email.But,if the report doesnot contain any Records,the report should not be delivered to Customer.

Could you be able to guide me and suggest me .

Thanks,

Jayaram

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.
>>

email alert log shipping out of sync?

Hello all,
Windows 2000 Log shipping Qu.
I have successfully set up log shipping but would like the monitor server to
send an email if the servers become out of sync. It seems that the default
is only to log the event in the app log does anyone know how to set up an
email alert?
Thanks in advance foir the help, Simon.If you do not have SQL mail setup, one easy alternative is to use
xp_smtp_mail. All the required information you needed regarding this can be
found at:
http://www.sqldev.net/xp/xpsmtp.htm
Anith|||Thanks for the advice - I can use SQL mail but I'm not sure how to fire the
event:
Do the monitor server jobs (listed below) fail when there is a problem or do
they simply log the event in app log?
Log Shipping Alert Job - Backup &
Log Shipping Alert Job - Restore
Thanks again.
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:Olz9OPbHFHA.2420@.TK2MSFTNGP14.phx.gbl...
> If you do not have SQL mail setup, one easy alternative is to use
> xp_smtp_mail. All the required information you needed regarding this can
> be found at:
> http://www.sqldev.net/xp/xpsmtp.htm
> --
> Anith
>|||In your job, create a new step ( say step 2 ) with the functionality to
email required addressee. On the initial step, set the "on failure action"
to goto step 2. Make sure set the "on success action" as Quit with success.
Anith

email alert log shipping out of sync?

Hello all,
Windows 2000 Log shipping Qu.
I have successfully set up log shipping but would like the monitor server to
send an email if the servers become out of sync. It seems that the default
is only to log the event in the app log does anyone know how to set up an
email alert?
Thanks in advance foir the help, Simon.
If you do not have SQL mail setup, one easy alternative is to use
xp_smtp_mail. All the required information you needed regarding this can be
found at:
http://www.sqldev.net/xp/xpsmtp.htm
Anith
|||Thanks for the advice - I can use SQL mail but I'm not sure how to fire the
event:
Do the monitor server jobs (listed below) fail when there is a problem or do
they simply log the event in app log?
Log Shipping Alert Job - Backup &
Log Shipping Alert Job - Restore
Thanks again.
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:Olz9OPbHFHA.2420@.TK2MSFTNGP14.phx.gbl...
> If you do not have SQL mail setup, one easy alternative is to use
> xp_smtp_mail. All the required information you needed regarding this can
> be found at:
> http://www.sqldev.net/xp/xpsmtp.htm
> --
> Anith
>
|||In your job, create a new step ( say step 2 ) with the functionality to
email required addressee. On the initial step, set the "on failure action"
to goto step 2. Make sure set the "on success action" as Quit with success.
Anith

email alert log shipping out of sync?

Hello all,
Windows 2000 Log shipping Qu.
I have successfully set up log shipping but would like the monitor server to
send an email if the servers become out of sync. It seems that the default
is only to log the event in the app log does anyone know how to set up an
email alert?
Thanks in advance foir the help, Simon.If you do not have SQL mail setup, one easy alternative is to use
xp_smtp_mail. All the required information you needed regarding this can be
found at:
http://www.sqldev.net/xp/xpsmtp.htm
--
Anith|||Thanks for the advice - I can use SQL mail but I'm not sure how to fire the
event:
Do the monitor server jobs (listed below) fail when there is a problem or do
they simply log the event in app log?
Log Shipping Alert Job - Backup &
Log Shipping Alert Job - Restore
Thanks again.
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:Olz9OPbHFHA.2420@.TK2MSFTNGP14.phx.gbl...
> If you do not have SQL mail setup, one easy alternative is to use
> xp_smtp_mail. All the required information you needed regarding this can
> be found at:
> http://www.sqldev.net/xp/xpsmtp.htm
> --
> Anith
>|||In your job, create a new step ( say step 2 ) with the functionality to
email required addressee. On the initial step, set the "on failure action"
to goto step 2. Make sure set the "on success action" as Quit with success.
--
Anith

Email Alert

I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
up email alerts and reporting on the SQL server. what is the most safe and
best way to achive this?Hi docsql,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You want to know
how to setup a email notification for an alert in SQL Server 2000. If I
misunderstood your concern, please feel free to point it out.
In SQL Server 2000, you can define the Response to an alert and choose the
email operator to notify.
To setup a SQL Mail, you need to configure a mail profile first.
SQL Mail must have a mail profile created in the same user domain account
or context that is used to start an instance of SQL Server. You can create
the profile with a mail client, such as Microsoft Outlook, that is
installed locally on the SQL Server computer.
You can find how to configure SQL Mail in the following article.
http://msdn.microsoft.com/library/d...-us/adminsql/ad
_1_server_2ecs.asp
Also, following KB article may help you to set up a SQL Agent Mail.
263556 INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
315886 INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886
321183 HOW TO: Troubleshoot Your SQL Mail Issue
http://support.microsoft.com/?id=321183
311231 INF: Frequently Asked Questions - SQL Server - SQL Mail
http://support.microsoft.com/?id=311231
Hope this will be helpful.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

Email Alert

I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
up email alerts and reporting on the SQL server. what is the most safe and
best way to achive this?
Hi docsql,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You want to know
how to setup a email notification for an alert in SQL Server 2000. If I
misunderstood your concern, please feel free to point it out.
In SQL Server 2000, you can define the Response to an alert and choose the
email operator to notify.
To setup a SQL Mail, you need to configure a mail profile first.
SQL Mail must have a mail profile created in the same user domain account
or context that is used to start an instance of SQL Server. You can create
the profile with a mail client, such as Microsoft Outlook, that is
installed locally on the SQL Server computer.
You can find how to configure SQL Mail in the following article.
http://msdn.microsoft.com/library/de...us/adminsql/ad
_1_server_2ecs.asp
Also, following KB article may help you to set up a SQL Agent Mail.
263556 INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
315886 INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886
321183 HOW TO: Troubleshoot Your SQL Mail Issue
http://support.microsoft.com/?id=321183
311231 INF: Frequently Asked Questions - SQL Server - SQL Mail
http://support.microsoft.com/?id=311231
Hope this will be helpful.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Email Alert

I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
up email alerts and reporting on the SQL server. what is the most safe and
best way to achive this?Hi docsql,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You want to know
how to setup a email notification for an alert in SQL Server 2000. If I
misunderstood your concern, please feel free to point it out.
In SQL Server 2000, you can define the Response to an alert and choose the
email operator to notify.
To setup a SQL Mail, you need to configure a mail profile first.
SQL Mail must have a mail profile created in the same user domain account
or context that is used to start an instance of SQL Server. You can create
the profile with a mail client, such as Microsoft Outlook, that is
installed locally on the SQL Server computer.
You can find how to configure SQL Mail in the following article.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
_1_server_2ecs.asp
Also, following KB article may help you to set up a SQL Agent Mail.
263556 INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
315886 INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886
321183 HOW TO: Troubleshoot Your SQL Mail Issue
http://support.microsoft.com/?id=321183
311231 INF: Frequently Asked Questions - SQL Server - SQL Mail
http://support.microsoft.com/?id=311231
Hope this will be helpful.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

EM slows windows

Often, EM running on my desktop will cause all other
windows either to refresh very slowly or not at all. (I
may get a border with some of the display) I can't
navigate to any window completely until I shut down EM.
SQL 2000 running on Win2k.
Thanks.
One possibility is that you have ODBC tracing turned on. You
can check by going to Administrative Tools and then to the
ODBC Data Source Administrator. Click on the Tracing tab. If
caption on the command button says "Stop Tracing Now", click
that button. That will turn off ODBC tracing.
-Sue
On Wed, 9 Jun 2004 07:08:54 -0700, "Andy Mous"
<andymous@.discussions.microsoft.com> wrote:

>Often, EM running on my desktop will cause all other
>windows either to refresh very slowly or not at all. (I
>may get a border with some of the display) I can't
>navigate to any window completely until I shut down EM.
>SQL 2000 running on Win2k.
>Thanks.

EM question....

How to know how the SQL Server is registered (Windows/SQL Authentication) in
Enterprise Manager?
SQL Server 2005.
Thank you,
John
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
>
>
>
>
|||Thank you.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23o5aPto%23FHA.3676@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> 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...
Authentication)
>

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 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...
Authentication)[vbcol=seagreen]
>