It works fine with the regular text format on DTS. After rename to .csv file, it won't work.

How to import binary file(got from UNIX through ftp) to SQL table, which...

I got the .csv file from UNIX through ftp. I also tried to use MS Excel for the provider on DSN, it could not accept the format.

Thanks. I want to know how to check the patches that were applied.

Are SQL clustering and SQL 2k Enterprise a seperate installation? If so, which one should be installed first?

I tried and got error below.

'Server: Msg 15290, Level 16, State 1, Procedure sp_change_users_login, Line 137 Terminating this procedure. The Action 'auto_fix' is incompatible with the other parameter values ('User_Name',...

I queried sysperfinfo; Also get Netiq report on SQL server service memory utilization in one hour interval.

I used the following script to assign max to 5120, but I could figure out why it can use more than (5120*1024)=5242880KB, it reachs 5256856KB and the number is still...

Klk, where can I find your article? Could you send to me tracylyang@hotmail.com? Thanks.

Tried alias, it returned same error message. Does something related to firewall?

To be hornest with you, I do not have the performance degradation now, just curious, if the server performance is very bad, how to find out if it is caused...

Where to save it after wrote the details in xp_sendmail and shedule xp_sendmail.

Which service need to be started by domain account? sql server or sql agent?

Thank you guys.

>>I would look at usage and size that will tell you if a database is taking the bulk of the data cache or not.

How to get the information?

...

Do you know which tool has the function?