Jack Corbett (3/5/2010)

---

I think a cert without experience means nothing. A cert validates your experience and the experience validates the cert. If you are already known as a...

If reporting services was installed, then there are two databases installed along with it. Just look for those databases:

select * from sys.databases where name like 'ReportServer%'

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)

---

It gave me the error again..

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)

---

Is there any other way we can fix this issue with out changing the code as I am not planning to use the 32 bit DTEXEC command line...

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)

---

Table

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)

---

They could tier the certifications, as well. One level for those that have passed the certification tests, but lack real worled experience, a higher level for those...

tstaker (3/3/2010)

---

Great Article Wayne! Thanks!

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