Pls check the SQL Mail..Test....under Support services ..Enterprise Manager.

yeah.....you can very well create a csv format using...

bulk copy....."bcp exec spname parameters queryout filename -t -r\n -c -slocalhost -U(username) -P(password)"

the username and password shd b provided without braces..

and the...

hey i donno wat happ above..it was aspdatagrid...aspdatalist

Cheers

Mate...if ur using asp.net...then you have the following options...

aspataGrid

asp:Repeater

aspataList

... Well you ll have to use...

Hi Vijay.....it does not mean that u have more that 8K rows...

it means that ur some data for ur Companyid

is exceeding its datatype size....itz a rule u cannot have more...

try...

if @@error <> 0

begin print 'error' end

Hi..i think u mean....gettin date only from

datetime..,..in that case

CONVERT stmts wud help u the most...

chk out styles like 112, 114

hope this helps