check out this article: http://www.sqlservercentral.com/columnists/cmiller/gettingridofexcessfilesandfilegroups.asp

you can run sp_helplanguage

Are all the 5 tables on the same linked server? check this http://support.microsoft.com/kb/269495/EN-US/ maybe helpful.

To run a dts package file:

exec master..xp_cmdshell 'dtsrun /F "C:\test.dts" /E'

E: trusted connection.

You can also run dts packages saved in msdb. Please check bol for the switches of dtsrun utility.

SQL server uses the same native way to store datetime data (8bytes decimal). There is no "format".

If you mean the datatime format for query output, you can try the following:

SET...

Take a look at http://www.examnotes.net/archive79-2002-7-44933.html

The MSDTC needs to start before SQL server service. You can setup dependancies in the service control panel.

It's better to create a SP for the query on EACH of your 100 instance(you can do this by osql or similar tool). Then using the same tool login to each server to...

For randomly jumping from page to page, I can't figure out a satisfied solution in SQL 2000, which does not have a native row_number column for records in a table.

What...

For paging, I am using the following method. It's efficient and flexible.

1) the SP needs to have parameters (@PK_Column_Parameter) for the PK coloumns of the paging data, e.g. @CustomerID.

2) the...

You either use trusted connection -T or SQL server login (-U and -P). So try either

bcp X.dbo.Y in c:\temp\test.txt -c -q -t "$" -r "" -T -S [servername\instancename]

or

bcp X.dbo.Y in...

TransDate should be the first column in the PK.

And there are lots of other constraints on the partitioned table and column. Please check BOL for details: "Updatable Partitioned Views" under...

This is just a normal warning. You can ignore it and continue the script.

The partitioning column must be part of PK. Since you partinition the table by TransDate, TransDate becomes the partition column. But it's not part of PK. So you cannot update it.

In...

Could it be the IE setting different one the two machine? Seems the cache is disabled on the xp machine.

It sounds to me the difference was caused by ANSI_NULLS settings for the views.

Can you check the settings for all the four views by generating their scripts?