Try this code:

CREATE PROCEDURE spClientContact

@CustomerID int,

@RecruitingOnly bit = 0

AS

BEGIN

SET NOCOUNT ON;

SELECT

    ID_Contact,

    ID_Customer,

    FirstName + ' ' + LastName AS Name

FROM

    tblContactPersons

WHERE

    (@Recruiting = 0

    and ID_Customer =...

Never mind my last post, I missed something.  Give me a couple of minutes.

Try this instead:

CREATE PROCEDURE spClientContact

@CustomerID int,

@RecruitingOnly bit = 0

AS

BEGIN

SET NOCOUNT ON;

SELECT

    ID_Contact,

    ID_Customer,

    FirstName + ' ' + LastName AS Name

FROM

    tblContactPersons

WHERE

    ID_Customer = @CustomerID

    and (@RecruitingOnly =...

If I am like most people, I could always use some extra money.  Only question I have is are you will to work with someone out of country for freelance...

Here is an excerpt from the licensing document from Microsoft:

For Workgroup, Standard and enterprise edition, each virtual operating environment running SQL Server 2005 must have a processor license for...

Are you looking at only running the database portion of PeopleSoft on a 64-bit server?  We run PeopleSoft Financials and HR here (Finance is at 8.9, and HR is on...

If I remember correctly, and you may want to verify this on the Microsoft website, SQL Server needs to be licensed seperately on each virtual server.  I was looking at...

Using the above, I would make one change (you actually have two choices for this one change):

DECLARE @Location VARCHAR(2000)

set @Location = '' -- this

SELECT @Location = @Location +...

Is your company in the process of purchasing SQL Server 2005 Enterprise Edition?  The evaluation copy is the Enterprise Edition that expires after 120 or 180 days, depending on how...

You could use dynamic sql in your stored procedure.  It would look sort of like this:

declare @SqlCmd nvarchar(4000)

set @SqlCmd = N'use msdb;exec your procedure'

exec @SqlCmd

hth

Could you post the SQL you are using to restore the database?

Part of the problem could be that you have SQL Server on domain controller.  That alone could take up quite a bit of system resources even if there are only...

You showed us what you are getting and what you want, but you also need to provide us with some sample data as well (preferable the same data used to...

Try this:

declare @month varchar(15)

set @month = datename(mm,dateadd(mm,-1,getdate()))

select @month -- to see what you got

Yes, I could, but I won't.  maybe some one else will, but we aren't doing you any favors just giving you the answers.  You need to take the time to...