Do regular stored procedures still run when Agent XPs are disabled?

Gurus,
I noticed when my SQL Server Agent is stopped, what appears in SSMS is the
following:
"SQL Server Agent (Agent XPs disabled)"
Agent XPs are extended stored procedures.
http://msdn2.microsoft.com/en-us/library/ms178127.aspx
My question is do regular stored procedures still run?
Spin
Spin,
Yes, they do. Agent XPs disable really means just the SQL Agent procedures
that SQL Agent uses to get its job done.
RLF
"Spin" <Spin@.invalid.com> wrote in message
news:647jmvF2ae2t8U1@.mid.individual.net...
> Gurus,
> I noticed when my SQL Server Agent is stopped, what appears in SSMS is the
> following:
> "SQL Server Agent (Agent XPs disabled)"
> Agent XPs are extended stored procedures.
> http://msdn2.microsoft.com/en-us/library/ms178127.aspx
> My question is do regular stored procedures still run?
> --
> Spin
>
sql

Do regular stored procedures still run when Agent XPs are disabled?

Gurus,
I noticed when my SQL Server Agent is stopped, what appears in SSMS is the
following:
"SQL Server Agent (Agent XPs disabled)"
Agent XPs are extended stored procedures.
http://msdn2.microsoft.com/en-us/library/ms178127.aspx
My question is do regular stored procedures still run?
--
SpinSpin,
Yes, they do. Agent XPs disable really means just the SQL Agent procedures
that SQL Agent uses to get its job done.
RLF
"Spin" <Spin@.invalid.com> wrote in message
news:647jmvF2ae2t8U1@.mid.individual.net...
> Gurus,
> I noticed when my SQL Server Agent is stopped, what appears in SSMS is the
> following:
> "SQL Server Agent (Agent XPs disabled)"
> Agent XPs are extended stored procedures.
> http://msdn2.microsoft.com/en-us/library/ms178127.aspx
> My question is do regular stored procedures still run?
> --
> Spin
>

Do Queries Support Regular Expressions?

If I had the following string in a table how could I find all records that
contained the term 'Business' for example? Would Regular Expressions be
supported in this context? Your comments regarding performance of a category
schema such as this?
// Example
PrivateSector_Business_Services
<%= Clinton GallagherClinton,
You could use the LIKE operator with the % wildcard character as:
WHERE COLUMN LIKE '%Business%'
Optionally you could use a Full-Text index as well.
HTH
Jerry
"clintonG" < csgallagher@.REMOVETHISTEXTmetromilwaukee
.com> wrote in message
news:OOuBDiczFHA.1192@.TK2MSFTNGP10.phx.gbl...
> If I had the following string in a table how could I find all records that
> contained the term 'Business' for example? Would Regular Expressions be
> supported in this context? Your comments regarding performance of a
> category schema such as this?
> // Example
> PrivateSector_Business_Services
> <%= Clinton Gallagher
>
>
>
>|||Thank you Jerry. That was simple :-)
<%= Clinton Gallagher
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OZqoPlczFHA.2884@.TK2MSFTNGP09.phx.gbl...
> Clinton,
> You could use the LIKE operator with the % wildcard character as:
> WHERE COLUMN LIKE '%Business%'
> Optionally you could use a Full-Text index as well.
> HTH
> Jerry
> "clintonG" < csgallagher@.REMOVETHISTEXTmetromilwaukee
.com> wrote in message
> news:OOuBDiczFHA.1192@.TK2MSFTNGP10.phx.gbl...
>|||For what it's worth, you can make real regular expression query searches via
calls to external COM libraries.
http://blogs.msdn.com/khen1234/arch.../11/416392.aspx
However, if using the native LIKE operator satisfies your requirement, then
use that instead.
"clintonG" < csgallagher@.REMOVETHISTEXTmetromilwaukee
.com> wrote in message
news:OOuBDiczFHA.1192@.TK2MSFTNGP10.phx.gbl...
> If I had the following string in a table how could I find all records that
> contained the term 'Business' for example? Would Regular Expressions be
> supported in this context? Your comments regarding performance of a
> category schema such as this?
> // Example
> PrivateSector_Business_Services
> <%= Clinton Gallagher
>
>
>
>

Distributed Transaction Coordinator/Cluster

Hi there. I'm new to this clustering mularky and I've a couple of questions
regarding a linked-server query I have.
1. Server A is a regular server. Server B is a clustered server with shared
storage.
From A, I want to call a stored proc that sits on B.
Q: I need to add B(cluster) as a Linked server on A - Do I need to add A as
a linked server on B also?
2. Depending on the answer to my first question, I might need to get MSDTC
running on the clustered server - is there some special configuration I
should undergo? I've come across some msdn articles regarding use of
"Comclust.exe" but I don't know if I need to use it.....
Any help would be appreciated - I'm a bit worried about this stuff!
I can answer #2 - Follow 817064, then 301600
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"len" <len@.discussions.microsoft.com> wrote in message
news:D1696F91-B3EF-485F-A362-785E910D02D7@.microsoft.com...
> Hi there. I'm new to this clustering mularky and I've a couple of
> questions
> regarding a linked-server query I have.
> 1. Server A is a regular server. Server B is a clustered server with
> shared
> storage.
> From A, I want to call a stored proc that sits on B.
> Q: I need to add B(cluster) as a Linked server on A - Do I need to add A
> as
> a linked server on B also?
>
> 2. Depending on the answer to my first question, I might need to get MSDTC
> running on the clustered server - is there some special configuration I
> should undergo? I've come across some msdn articles regarding use of
> "Comclust.exe" but I don't know if I need to use it.....
> Any help would be appreciated - I'm a bit worried about this stuff!
|||Dhanks for that - it's just what I was looking for! I have one question
regarding 301600 though:
Part of the instructions state that after creating a Cluster group for
MSDTC, I need to add an IP Address resource to that group.
What I don't know is: where should this IP address come from? I've already
tried the IP address of both of my cluster nodes AND the virtual IPAddress of
my shared storage/SQL server but errors are thrown up about these being in
use already. do I need to create an entirely ne IP address?
thanks again!
"Rodney R. Fournier [MVP]" wrote:

> I can answer #2 - Follow 817064, then 301600
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
> "len" <len@.discussions.microsoft.com> wrote in message
> news:D1696F91-B3EF-485F-A362-785E910D02D7@.microsoft.com...
>
>
|||You are most welcome.
The IP has to be a new IP address, it needs to be in the same subnet as the
SQL & Cluster IP.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"len" <len@.discussions.microsoft.com> wrote in message
news:08F90F15-972F-41D6-87E1-F34C1EBCFAB3@.microsoft.com...[vbcol=seagreen]
> Dhanks for that - it's just what I was looking for! I have one question
> regarding 301600 though:
> Part of the instructions state that after creating a Cluster group for
> MSDTC, I need to add an IP Address resource to that group.
> What I don't know is: where should this IP address come from? I've already
> tried the IP address of both of my cluster nodes AND the virtual IPAddress
> of
> my shared storage/SQL server but errors are thrown up about these being in
> use already. do I need to create an entirely ne IP address?
> thanks again!
>
> "Rodney R. Fournier [MVP]" wrote: