Thankx for the information.I didn't notice this

quote:

---

Dinesh, please note that GMT and UTC is not exactly the same thing. As I discussed...

Got it

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/maintain/operate/opsguide/default.asp

There was a book in MSDN. I don't have the short cut.

I found I will post it

http://www.sqlservercentral.com/columnists/dasanka/findminmaxvaluesinaset.asp

in here it generates a sequence number

Oh! Got it 🙂

COUNT(*) is the problem

COUNT(P.WFS_SERVER_ID )

Same with me.

It will be better if default of this option is set to true.

In other forums defult is set.

You can write a simple VB application or a Stored procedure for this

Part 2 of it

http://www.sqlservercentral.com/columnists/sjones/codingstandardspart2formatting.asp

EXEC sp_columns @table_name = 'TableName' ,@column_name ='ColumnName'

Thanku guys

I haven't notice the time.

I find some what iritating when I see same tile with few mails

That's funny!!

Yes

BOL

CREATE FUNCTION

Creates a user-defined function, which is a saved Transact-SQL routine that returns a value. User-defined functions cannot be used to perform a set of actions that modify the...

exec xp_cmdshell 'mkdir c:\t'

from the putput u can check whether folder exists

I don't think u can do this other than giving the names in INSERT INTO command