Try this:

select convert(datetime, '01/09/2008 05:37', 103)

The style 103 indicates that you want to read the string you're passing through as if it was in the british datetime format.

Hope that helps.

Looks...

If you were using SQL Server 2005 I'd recommend setting up mirroring between the two sites and then manually failover to the second site.

As you're not using SQL 2005 then...

Just because the jobs completed successfully doesn't necessarily mean that the log backups...

Muralidharan Venkatraman (10/30/2008)

---

1. In the standby side, my understanding is that when the restore happens, no user

should be logged in. If so, it fails. Also, i...

The code you posted works fine for me. I just copied and pasted it in a query window in Management Studio and it works.

In that case Gail's suggestion will work for you.

GilaMonster (10/29/2008)

---

If all you want to do is remove the P character from the columns, then this will work

UPDATE SomeTable

SET SomeColumn = REPLACE(SomeColumn,'P','')

WHERE SomeColumn...

Pooja_prasad (10/29/2008)

---

thnkz.

I know the above syntax but I got to know that there is an insert...set form also. Or is it that it is present only in MySQL and not...

Try this instead:

insert into contactinfo (FullName, Source, CreatedDate, ModifiedDate)

values ('XYZ', 'ABC', '2008-09-09 00:00:00.000', '2008-09-09 00:00:00.000')

Try this:

SELECT top 1 @a = name FROM SYS.parameters WHERE OBJECT_ID = OBJECT_ID('MQA.tsp_GetSubject')

Create the target table with an identity column for ProductId.... like so....

create table my_table

(

ProductId[int] identity(1,1),

ProducerId[int],

ProductName[varchar](50)

);

go

--and then to insert into it:

insert into my_table(ProducerId, ProductName)

select ProducerId, ProductName from my_view;

go

Hope that helps.

Taken from the following article: http://www.microsoft.com/whdc/system/platform/server/PAE/PAEmem.mspx

"When the physical RAM in the system exceeds 16 GB and the /3GB switch is used, the operating system will ignore the additional RAM until...

Garth Michel (10/28/2008)

---

Isn't me setting the SELECT to READ ONLY pretty much the same as setting the mode to repeatable read and would this mode be sufficient for what I...

Garth Michel (10/28/2008)

---

I did read...

The problem is probably related to the tables in the inner join having different collations. Or at least on the columns that you are joining.

Do an sp_help on the...