enabling and disabling of agents question

on the properties page for an agent (I referring mainly to snapshot and
merge agents), on the general tab there is an 'enable' check box. Then on
the schedule tab there is also an 'enable' checkbox for the shedule.
If the enable checkbox on the general tab is not checked (disabled) but the
enable checkbox on the schedule is checked (enabled) will the agent run?
The reason I ask is that my merge agent was running even though I'm looking
at the enable check box and it is not checked? The only thing I can think
of is that I unchecked 'enable' while the agent was currently running..
maybe I did not stop it first.. could that be the explanation?
any info is appreciated. thanks.
DJC,
yes - you need to stop synchronizing to stop the job, and disabling it just
sets the property without stopping it. 'Start Synchronizing' and 'Stop
Synchronizing' are actually independant of this property though.
HTH,
Paul Ibison
|||that helps very much. Thank you again Paul.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23Ccmp%23wUEHA.3692@.TK2MSFTNGP09.phx.gbl...
> DJC,
> yes - you need to stop synchronizing to stop the job, and disabling it
just
> sets the property without stopping it. 'Start Synchronizing' and 'Stop
> Synchronizing' are actually independant of this property though.
> HTH,
> Paul Ibison
>

Empty Warning box appears with only OK button (2 processes started) when I open Microsoft SQL se

Hello,

I'm new to SQL server 2005. I installed SQL server 2005 and had some problems with the original install. I therefore uninstalled SQL server 2005. Rebooted and than installed SQL server 2005 again. Everything appears to have installed correctly except for the fact that when I start SQL Server Management Suite I get 2 copies running in the foreground. The last copy of the SQL Server Management Suite shows a dialogue box that contain a warning sign (yellow triangle) with no text but an OK button is in the dialogue box. When I press the OK button, this instance of SQL Server Management Suite kills itself. The first instance is now given window focus and it brings up the "Connect to Server" dialogue box. I can connect to my local server and run a script to add columns to the database. But everytime I bring up SQL Server Management Suite, I always end up with 2 copies running and I have to hit the OK button to get rid of the second copy. Can anyone help me get ride of this annoying problem?

Hello,

I solved this problem! I installed windows XP Pro updates and one of the updates was the Update for .NET Framework 3.0 x86(KB932471). When I went to add/remove programs and removed this update, Microsoft SQL server management suite came up just like it is suppose to (only one instance running and the "Conncet to Server" Dialogue box is present.

JoAnn

Empty Messagebox

Hi

When I start the MSQL Server Management Studio Express I get a Message Box with a yellow exclamation icon and NO message, just an OK button. Which when I press it goes away allowing me to logon to the Management Studiio.

All seems to be working fine (although I have not used it much since getting this strange behaviour).

I have re-installed Win XP Pro SP2, applied all patches from MS website, install is clean and no errors. Also downloaded latest SQLExpress Edition and as well as latest Server Management Studio.

Any ideas?

Thanks, any help will be appreciated.

I'm moving this to the Tools group where the management studio folks hang out.

Mike

|||

I recently installed Windows Live Local Add-in for Microsoft Office Outlook which also installed .Net 1.1 (although it was already installed on my PC along with .Net 2.0). I then started to get the same empty message box when Management Studio started. I did a repair on .Net 2.0 and the empty message box has stopped.

|||

Hi Steve

Thanks, that worked for me as well.

Had me worried!!

Regards.

Larry.

|||

This also occured after the install of SP2 for 2005 Developers Edition. (Blank message box with exclamation icon)

Repairing .Net 2.0 corrected the message.

I think it was caused by an update to the .Net 1.1 Framework that happened immediately following the install of SP2.

Thanks for the tip...

Empty Messagebox

Hi

When I start the MSQL Server Management Studio Express I get a Message Box with a yellow exclamation icon and NO message, just an OK button. Which when I press it goes away allowing me to logon to the Management Studiio.

All seems to be working fine (although I have not used it much since getting this strange behaviour).

I have re-installed Win XP Pro SP2, applied all patches from MS website, install is clean and no errors. Also downloaded latest SQLExpress Edition and as well as latest Server Management Studio.

Any ideas?

Thanks, any help will be appreciated.

I'm moving this to the Tools group where the management studio folks hang out.

Mike

|||

I recently installed Windows Live Local Add-in for Microsoft Office Outlook which also installed .Net 1.1 (although it was already installed on my PC along with .Net 2.0). I then started to get the same empty message box when Management Studio started. I did a repair on .Net 2.0 and the empty message box has stopped.

|||

Hi Steve

Thanks, that worked for me as well.

Had me worried!!

Regards.

Larry.

|||

This also occured after the install of SP2 for 2005 Developers Edition. (Blank message box with exclamation icon)

Repairing .Net 2.0 corrected the message.

I think it was caused by an update to the .Net 1.1 Framework that happened immediately following the install of SP2.

Thanks for the tip...

Empty Message Box

Hi

When I start the MSQL Server Management Studio Express I get a Message Box with a yellow exclamation icon and NO message, just an OK button. Which when I press it goes away allowing me to logon to the Management Studiio.

All seems to be working fine (although I have not used it much since getting this strange behaviour).

I have re-installed Win XP Pro SP2, applied all patches from MS website, install is clean and no errors. Also downloaded latest SQLExpress Edition and as well as latest Server Management Studio.

Any ideas?

Thanks, any help will be appreciated.

I'm moving this thread to the Tools forum.

Empty dialog box on startup of Management Studio Express

Hi,
Everytime I start Studio Express I get an empty dialog box. I've seen some
posts about a similar problem but they were linked to upgrades. I have not
upgraded SQLExpress so there must be something else that causes it.
The only thing that I have done recently was to delete few users from a
database and instance.
I'm using SQLExpress 2005.
Any ideas what could be happening and how to troubleshoot this?
ThanksHi
I would suggest removing and re-installing, but other posts say fixing .NET
Framework 2 .0 fixed it!
John
"bogdan" <bogdan@.company.com> wrote in message
news:OvOLTAplIHA.2396@.TK2MSFTNGP02.phx.gbl...
> Hi,
> Everytime I start Studio Express I get an empty dialog box. I've seen
> some posts about a similar problem but they were linked to upgrades. I
> have not upgraded SQLExpress so there must be something else that causes
> it.
> The only thing that I have done recently was to delete few users from a
> database and instance.
> I'm using SQLExpress 2005.
> Any ideas what could be happening and how to troubleshoot this?
> Thanks
>