Or try this:

select dateadd(dd,datediff(dd,getdate()),0)

We are building a data warehouse where I work, and we are using schemas to identify the source systems in our staging environment.  Once the data actually moves to the...

Be sure you read the license agreement.  If I remember correctly, if you install Reporting Services on a machine other than the one where you installed SQL Server 2005, you...

I had my pattern and expression reversed.  Also note that I had to add a single quote to the sixth string due to the single quote in the company name:

create...

Worth a shot.  That was the only way we could get our DTS packages to run as scheduled jobs at my last company.

If I think of anything else, I add...

If you use Windows Server 2003 R2 as the host OS, you can use the same license for up to 4 Virtual Servers on the same box.  Not sure if...

Just for the heck of it, set the owner of the job to sa and see what happens.

Try replacing the variable @string with the column you are trying to split into 2 seperate columns.

There is a way, unfortunately, I can't remember how or where I saw it.  I will, during my free time, try and see if I can find it again and...

Oops, meant this:

select substring(@string, 1, patindex(@string, '% %') - 1), substring(@string, patindex(@string, '% %') + 1, len(@string) - patindex(@string, '% %'))

Try this:

select substring(@string, 1, patindex(@string, '% %') - 1), substring(@string, patindex(@string, '% %') - 1, len(@string) - patindex(@string, '% %'))

I would say because you were trying to make it more complicated than it really was.  You probably could have gotten your way to work, but you should should have...

I just reread the licensing for SQL Server 2005.  You would need to purchase a per processor license for each processor in the server.  If you are looking at a...

Try the following:

declare @d1 datetime,

        @d2 datetime

set @d1 = cast('2007-01-12 15:01:50.863' as datetime)

set @d2 = cast('18:00:00.000 as datetime)

select datediff(ss, @d2, cast(convert(varchar(12), @d1, 114) as datetime)/3600.0

hth

I can't directly answer your question, but I do have a question for you, how many users access the system?  You indicate it is low use, so why are you...