You can achieve HA using clustering or mirroring.  It is possible to use both, I guess, if you weren't planning on shifting the databases between clustered servers.  I think I...

Personally, I would think that you'd want to do the partitioning first.  I think it will involve more work to accomplish successfully, then do the HA project.  I would not...

Okay, but if things change, please keep me in mind.  I'd be more than happy to send you my resume.

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...