You can use SQLDMO to access the JobServer object.

You should find that the Status property of the JobServer object will inform you of the status of the SQL Server Agent...

I agree with jpipes, store the value(s) in a table, this is the way Microsoft (and Sybase) store lookup values.

See master.dbo.spt_values as an example. (I have read articles referring to...

This could be something to do with the date format in which your application is passing the datetime data to SQL.

Try to ensure that the application is using either...

Just has a thought......

In your code prior to declaring the cursor, create a temporary table and populate the temporary table with the data from the dynamic statement. Then you...

Your understanding is correct, because the dynamic sql will be executing in a differenc scope to your main procedure you will have to include the WHOLE cursor operation (declare, open,...

You cannot specific the sql statement as a variable for the cursor.

The easiest was around this is to include the whole cursor operation into your dynamic sql statement.

Unless I have missed something in your requirements, will the following give you ther required results:

CREATE PROCEDURE myprocedure

@out_var1 varchar(5) OUTPUT,

@out_var2 varchar(5) OUTPUT,

@out_var3 varchar(5) OUTPUT,

AS

BEGIN

set @out_var1 = (select count(id)...

Marty

You say that you would like to place this functionality into a User Defined Function, however there are a number of issues to consider about using something like this in...

Try this......

declare @table table (UnitID char(4))

insert into @table values('0012')

insert into @table values('010B')

insert into @table values('123F')

insert into @table values('0001')

select UnitID,

case

when right(UnitID, 1) like '[A-Z]' then convert(int, left(UnitID, 3))

else convert(int, UnitID)

end as...

Try taking a look at this article, I found it quite useful

http://www.sql-server-performance.com/performance_monitor_counters.asp

Thanks MarkusB for the prompt response.

I have now written a script to run as a SQL Job when the Alert fires, this script drops and recreates the Alert with the...

Try taking a look at CHARINDEX and SUBSTRING in BOL.

Thanks, but that only returns a list of the SP Parameters (twice) and not the columns in the resultset.

Example: These are the results I get back from one of my databases using SOUNDEX.

select distinct Surname

from tblEmployee

where difference(Surname, 'Smith') = 4

Results:

Sainty

Samani

Samina Seikh

Sammimi

Sammut

Sanani

Sandhi

Sandhu

Sandow

Sandy

Sant

Saundh

Seaman

Seamen

Seemann

Seemon

Shanahan

Shand

Shando

Shanhan

Shannon

Shant

Shimmin

Siannot

Simeon

Simmnet

Simmonds

Simmonite

Simon

Simonds

Simonite

Sinnot

Sinnott

Smit

Smith

Smith - Left

Smith-Taylor

Smith?

Smooth

Smoothy

Smoth

Smout

Smyth

Smythe

Snead

Sneyd

Snoad

Somani

Someone

Sonnet

Soundy

Summon

Symmonds

Symon

Symonds

I'm not saying...

I agree that Soundex functionality will return the all the various characters used in this 'Lopez' example. However, due to the way in which soundex works it is possible...