What you are suggesting sounds feasible, I have done similar in the past. You may want to consider differential backups ad well to reduce the number of logs you need...

You cannot restore master from SQl Server 200 to 2008, many interbnal thibgs changed that affect the master database.

What do you want to keep from the old master db...

Can you post some more details, the DDL for the table in question, some test data and code that shows the problem, and the exact error message please?

There should be...

Unless you have some other symptoms of memory problems I would do nothing at all. SQL server is designed to use as much memory as is available. It only releases...

If chinese characters are stored properly in SQL Server then they will display properly in Management Studio. So I would work on the assumption they have been mangled somewhere.

I would...

The nonclustered index does indeed take up disc space, but not really in tempdb.

While actually building the index it may use space in tempdb, but the finihed index is...

You can use a variant of insert to copy data from one table to another.

It will be something like:

insert into xxx (col1, col2 etc)

select colx, coly from yyy

But I would...

If a column is defined as a primary key, then by definition it cannot be null, so you cannot do anything to allow nulls in there.

It can however (if...

Reports always deploy using the name of the report, so rename them to something sensible from a user perspective is your best option.

To deploy one report (as opposed to the...

I would stick closer to the example Lowell gave you, (which is almost identical to a template I use) .

The important distinction in that technique compared with what you just...

Without DDL, (including all indexes) and some actual execution plans we are all flying blind, it is almopst impossible o make any suggestions.

Can you try running the select separately from...

I'll second that but add:

It also depends a lot on:

Data types

indexes

disc config

disc speeds

and probably more...

Mike

Table definitions, index details (all of the details) and actual execution plan would all be a gret help, but my initial thoughts (guesses) are:

a) Index on logtime column - is...

While using BCP, SSIS etc will undoiubtedly help you, they tend to be problematic with the problems you have with varying column numbers coming in.

Therefore if you already have a...

Hi Michael

Synonyms are permanent, so exist until dropped.

From your original description I would have thought you could create them all once on an installation, and the code remains the same...