Thanks Lynn. I remember that now after reading it.

Wonder why those parameters for ServerProperty still...

Agreed.

EXCEPT will get you a list of all of those that you want them to have, minus the ones already...

This will get you the information for one server:

select ServerProperty('LicenseType'), ServerProperty('NumLicenses')

What I would do is to incorporate this into the SQLCMD command line utility, using the FOR /F dos command...

NP. Haven't heard back from the OP yet...

I think it's all fixed now... all the code...

To elaborate on what Lynn mentioned, you can use either the IF or CASE statements as shown below:declare @var1 char(3),

@var2 char(3)

set @var1...

Rog Saber (4/20/2010)

If you're using a monitor server, the "Transaction Log Shipping Status" report (available in SSMS, right-click the server, select reports | Standard Reports | Transaction Log Shipping Status), and you...

You might want to check out this link for help in pivoting a query.

You might want to check out the REPLACE function in BOL.

You might also check out the LIKE function... you might be able to use it as LIKE '%[SX]VD%'.

I was just thinking about this,...

I don't see an issue with your code.

I just ran this code, without error.

CREATE PROCEDURE [dbo].[sp_TLCOMSCandReg] (@CandID VARCHAR(50) output,@FirstName VARCHAR(100),@MiddleName Varchar(100),

@LastName VARCHAR(100),@EmailID VARCHAR(250),@MobileNo VARCHAR (15),

@PhoneNo VARCHAR (15),@DOB DATETIME,@Gender SMALLINT,@Address...

This doesn't have anything to do with your issue, but why are you passing nvarchar fields to a procedure that is expecting varchar?

And that is why I help out... I end up learning more, and it has the benefit of enforcing what I do...

SW_Lindsay (4/20/2010)

To select eligible candidates in the first select you say

select * from @Candidates where MeetsEligibility = convert(bit,1);

Why do you convert...