Ooops kevriley is correct!!!

Post more explanation ... see my signature with online link how can we...

ramadesai108 (3/13/2009)

---

Hi All,

What is wrong with this statement. Even when CHARINDEX is zero it goes thru the 2nd case statement:

CASE WHEN CHARINDEX('-',ClientID) <> 0 THEN

(CASE...

And the winner is ...??? You or again DB properties !?

Ratheesh.K.Nair (3/13/2009)

---

Thanks to all for the prompt reply,

Yes i got the error when i tried to get the database properties by right clicking on database -->properties.

I am using SQL Server...

It was very simple code and interesting but someone wants to know the day of the birth date!

I added some piece script in your core script Lynn like here

declare...

Ratheesh.K.Nair (3/13/2009)

---

Hi Experts,

I am getting the error given below when i selected the properties of a database. I am getting the same error when i try all databases in that...

OR clause should use if you want to work with 2 or 3 values that you are searching the results with them!

IN clause should use if you have more than...

This should work let us know:

SELECT * FROM TBLDEALS

WHERE CONVERT(VARCHAR(20),trade_date, 120) = '2009-03-06 00:00:00'

Yes if your DB is 4GB this is one of the solutions, you should know that the SQL Server...

Jose Ianuck (3/9/2009)

---

Hi, all. We created a Database snapshot to work read only, just reports by web application, so what impact does a database snapshot have on application transaction throughput...

Sure that MCITP and MCTS is with SQL Server 2005, and it would be better if you go for MCTS and MCITP SQL Server 2008 ( no other way)!

There it...

What do you mean the database is Full, is this over 4GB or you storage...

What is you error msg!?

As I can see in the WHERE clause you have the problem with date format!

Very nice and short explanation about User - IP security! Simple code here I like it!

😎

How about hardware configuration info:

RAM memory

HDD Drive

Any RAID Config

also

Win Server info?

etc etc!