Thanks SSCarpal Tunnel

Hi All,

i completed 70-431.

now i am a MCP or MCTS.

http://www.microsoft.com/learning/mcp/mcts/sql/default.mspx

Regards,

Kiruba sankar.S

Hi :),

U Can See Yr Required Fields to Run Following Query.

SELECT * FROM SYS.dm_exec_sessions

Regards,

Kiruba sankar.S (MCTS)

http://sqlbits.blogspot.com

Hi All,

I passed MCTS (70-431) in SQL SERVER 2005..

Regards,

Kiruba sankar.S

(MCTS)

Hi,

i facing this problem. because i am using Auto shrink option in DB Property.

so if you are using that Auto shrink property.DB will be come slow.

Jeff,

You have to try like this

case when col1 = 1 THEN 'yes' else (case when col2 = 1 THEN 'no' end) end as column3

Regards

Kiruba...