While partitions are elegant , they do require some time too look at (I should have mentioned this). James's solution is simpler and could...

You could produce XML in a stored procedure, and then just use XSLT to make it nice. Of course you need to consider the supporting browsers, whether you want some...

If you are on Enterprise edition, you may want to consider table partitions. SQL Server allows you then to swap in/out individual partitions, which can have their own indexes as...

Among others temporary tables are stored in tempdb. Large and complex queries from other databases also use the tempdb. use sp_spaceused to get some basic information on how much space...

Indexed views are actually quite handy, and can increase query performance. SQL Server's query optimizer does use them automatically, even if the view is not referenced. You are right however...

I'm glad that you have isolated the problem,

Andras

In case someone does not post a validation to what I said (it is not particularly overdocumented) :

You can validate it yourself by:

Create...

The fact that you can connect to 1433 is a good sign. This should mean that SQL Server is listening on that port, and that you can connect to it....

SQL Server stores only the columns that are in the view. This of course means that data will be duplicated, but only for the columns that are part of the...

SQL Server listens on TCP port 1433 (the default instance). Try connecting to this port from the remote machine using telnet or something similar. Also, if you have a named...

Yes. This must be enabled if you want to connect to the SQL Server via TCP/IP. As Steve mentioned, named pipes can be used for local connections only.

Andras

Do you have TCP connections enabled for the server (use Surface Area Configuration to check/set this)

Regards,

Andras

Yes it is. If you do this the database on the 2005 server will be in compatibility mode 80.

Regards,

Andras

Is your SQL Server Browser Service running?

Andras

Synonyms can only be created for tables, views, functions, stored procedures and extended stored procedures. (And there are some limitations even for these.)

This post looks like http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=391743

Regards,

Andras