Other options to consider are:

Log Shipping

Clustering

Each instance on a cluster needs to be installed on it's own resources. So, in Cluster Administrator, add a new group, and add your (new) Drive resources to that group....

<beat head on wall>.....

I spent over an hour on the web, trying out different things before posting this question. Then, after posting, I tried one other thing and it worked.....

Set...

balbirsinghsodhi (3/3/2010)

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near 'GO'.

Msg 111, Level 15, State 1, Line 3

'CREATE VIEW' must be the first...

There are 3 different examples above... which one did you end up using?

Suresh Kumar-284278 (3/3/2010)

If your time is stored as character data, try this:

declare @i varchar(4)

set @i = '1'

select stuff(right('0000'+@i,4),3,0,':')

if it's stored as numeric data, try this:

declare @i int

set @i = 1

select stuff(right('0000'+convert(varchar(4),@i),4),3,0,':')

nguyennd (3/2/2010)

CREATE TABLE [dbo].[A](

[K] [int] NOT NULL,

[V] [varchar](50) NOT NULL,

CONSTRAINT [PK_A] PRIMARY KEY CLUSTERED

(

[K] ASC,

[V] ASC

)

SQL

DECLARE @a int = 1 --or NULL,...

SELECT * FROM A WHERE @a is...

Tom, Brad, "tstaker", Randy and Jason: I'm glad you'll liked the article... and I hope you never need to reference it!

@jason: plus, you get a point for doing so. 😉

Lynn Pettis (3/3/2010)

tstaker (3/3/2010)

"Then, verify your backup – until you do so, you don’t know if it’s good or not. In case you manage to really mess up...

I agree that experience counts.

But what irks me even more is the places that won't even look at you if you don't have a college degree... I've been in...

Check out Books Online (BOL) for the ROW_NUMBER() function... with this, you can easily accomplish what you are trying to do.

Lot's of good questions Roy.

As one of the people that does have certs, I like them. I know that I meet the minimum standards for being a MCDBA / MCIPT...

Lowell,

This works for me...

declare @input varchar(max)

--set @input = char(13) + char(10) + '

set @input = '

--for users who are too lazy to type "SELECT * FROM" ...