Thanks for the inputs guys!

Thanks!

I will try this!

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_9i5u.asp

Multiple Instances of SQL Server on a Failover Cluster

You can run only one instance of SQL Server on each virtual server of a SQL Server failover cluster, although...

Clarify:

Two instances in one box with two different version of SQL Server. It is a Active/Passive environment.

If there is a hardware failure. The other box kicks in...

Wow! No one knows it....

Pls. ignore my post. I figure it out...

Varchar (35)

I also tried LTRIM & RTRIM, still NO Luck!

Thanks Sergiy! I got it...It should be RIGHT JOIN...

why there is separate job for each INIT & NOINIT? why not just one INIT or NOINIT, know what I mean?

How about this? I want the day of the month

Birthdate char(10)

SELECT substring(convert(char(2),datepart(day,BirthDate)),6,7) from FOR_UPDATE_CUST

Error: The conversion of a char data type to a datetime data type resulted in an...

But I need in this date format mm/dd/yyyy...

still gettin the error:

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

The statement has been terminated.

@ExistCount int,

@key int,

@t_date varchar(11)...

Restore a backup taken from that server and that database...

I tried that...

some len is 2, some len is 4, etc...

any solutions?