It could be a number of different things. The application may be using too much memory causing SQL to cache to virtual memory, you could be contending for processor...

Is it fixed width? How can you tell one field from the next? Perhaps you could post a file - or part of one.

A UNION ALL can (and almost always will) un-sort your data, so it will mark the data as unsorted.

Data coming from more than one source into a UNION ALL is...

xSQLCompare has a command line utility that you could use to automate this process.

I think Red-Gate's software package does as well, but I cannot remember.

Look at the OUTPUT clause in books online.

It will allow you to output the affected records into another statement.

It is going to be very difficult to determine the exact cause now that you cannot reproduce the behavior.

Stored procedures cache execution plans. If it had cached an execution...

Freeing the procedure cache will not help the issue being noted.

The problem is if there is a plan being built while the setting is changed the plan could possibly be...

It is going to depend on your exact requirements. Does the report database have schema specifically for the reports? It would be common to want different indexes, stored...

There is a "Format" menu with an auto-layout option as well as menu items for alignment and sizing.

If you are either connected to the server via terminal services, or actually sitting at the server console when you try to run the report, does it work?

In the Login Properties dialog, choose the User Mapping section.

In the top (users mapped to this login), select your database and leave the defaults here.

In the bottom (which just enabled),...

Are you are referring to several lines showing up when you run sp_who2 with the same spid and sometimes the spid is displaying as blocking itself?

If that is the situation,...

The "Spinning Wheel" is just an animated gif. The fact that it is not spinning suggests that you have some problem with the web page displaying on the client.

If...

If you have replication running for a particular table (making it an article) you need to make schema changes through the replication UI. If you try to make a...

MS Access is a bit of a terrible front-end for a SQL Database. It is not really designed for a multi-user environment. To add to that, you have...