Thx. but it did not get me the file created time.

I have the right to exec the command. The reason I can't use master.dbo.xp_FileExist is that I need to know the file created date so that I will...

I do not know no match whether I have xls file or not.

I did this in query analyzer. the output is the same. Thx.

exec master..xp_cmdshell 'dir /od C:\*.xls'

output as...

I googled xp_cmdshell to get file creation time did not come out anything. Will you please post some sample ?

Thx.

that is my thought ,too. but I do not know I can't use sum this way. Thx. I looked at bol and google conditional count , not that much come...

I have training from Kalen Delaney. It is good. She wrote the book

Inside Microsoft® SQL Server(TM) 2005: Query Tuning and Optimization .

What is the purpose of

sum(case when b.Status = 1 ...

I just reintalled sql 2005 again. since I need to use. Thx.

<asp:DetailsView ID="dvInfo" runat="server" DefaultMode=ReadOnly AutoGenerateRows="False"

DataSourceID="dsKeyContact" HeaderText="Review the info...

I do not have ms sql 2005 installed in my server at all.

I do not think the error is connection string

http://localhost:2132/HRHSKeyContact/HRHSKeyContact.aspx?hid=2

it is view. it connected to remote database.

http://computername/HRHSKeyContact/HRHSKeyContact.aspx (html file)

it is viewable. web server is working.

it is web application.

application connect to the remote sql2000 server

http://localhost:2132/HRHSKeyContact/HRHSKeyContact.aspx?HID=1 viewable in the local machine

http://webserver(computername)/HRHSKeyContact/HRHSKeyContact.aspx?HID=1 not viewable in the local machine

I just...

I used SP_CONFIGURE to check remote acces config_value is 1 realdy. so.. why I still get the error.

checked

remote access0111

I did reboot the pc. I went to regedit. I find ms sql server 8.00.000, 80,90 . MSSQL.2 MSSQL.3, MSSQL.4.

I do not know what would be sql 2005 express...

On the left bar. There is newsletters you click and go the calendar and select the date you want.