I usually create dedicated SQL account on the target server for the source server to log on with.

In the SECURITY option of the linked server on the source box, I...

Information is power as they say.

Check the Windows and SQL logs in detail to see if any evidence is offered.

Have you tried assigning Service to the AUTHORITY\NetworkService account and...

You beat me to it by minutes!

SELECTT1.TranID,

(

SELECTOriginCode + DestinationCode

FROM#Test T2

WHERET2.TranID = T1.TranID

ORDER BY

OriginCode

FOR XML PATH('') ) TheString

FROM#Test T1

GROUP BY

TranID ;

Just to echo previous comments I've used Calendar tables in which is held all the necessary fiscal/lunar/holiday information required for the business.

Even 100 years worth of data held by the...

Check out Microsoft Lightswitch. It's great for creating a basic CRUD front end application (web or fat-client).

Just point it to a database and off it goes - I created a...

Using the term "stuck" is is a bit vague.

From what I can gather, running a query from an ASP.NET page causes issues on the SQL Server?

If that is the case,...

We have a mixture here of .NET 2 / 3.5 and 4, as well as MS Access. All works fine.

Raised eyebrows if I saw stuff this in production...

Nice back to basics question although I'm a bit more of a COALESCE man myself.

There's no catch all script as "Audit" means different things to different DBA's.

However, take a look at http://www.brentozar.com/blitz/ which was recommended to me and is a great starting point.

Hi ramyours2003, sorry, I don't understand the question. Can you be a bit clearer?

As a data migration task, you'll have some planning to do to ensure data types between the two systems are compatible, especially dates.

You can export data from SQL 2008 in...

My somewhere limited Page Latch experience has always pointed to the IO sub system.

On one occasion, the cause were bad sectors, on other it was misconfiguration of the IO...

I don't know of a way of splitting the error log but you could force the creation of a new log file whenever you want.

For example, once a week create...

I've has this same error when the file was too big. Opening it in Wordpad worked fine. Can you locate the file?