We use subversion, which handles chek-in.outs, versioning , deployment etc... its a good product but does not tie into SQL server in a way that I would...

Is this for a cube or relational source?

There is nothing inherently wrong with your setup, but there are things you can do to prepare.

I would start by looking at the...

use N datatype (nvarchar,nchar, ntext)

if you need sorting and comparisons in Chinese then select which colaiton suits your Chinese lanugage and make this the colation of the the column...

There are a few things wrong with it.

1. replace needs 3 paramters you need to extend the brackets

2 as type is not needed since you are naming the...

example of what?

you have not stated which language you require and what datatype you need depends on the language's characters.

it depends on what characters the languages use, if you are required to store languages that do not use the latin characters such as Arabic or Thai then...

It's difficult to say if you will face performance issues or not without knowing anything about the types of queries and the amount of data involved.

Generally speaking if the queries...

If the projects relate to each other then i think its good to put them in the same solution, for example SSIS/SSAS/SSRS projects all relating to one BI...

Good point Paul, I did not realise it was un-documented. I jave just been using it without thinking about it too much... maybe time to re-think this..

Theres no point, SQL server has an in-built one with spt_values up to...

It's not entirely clear what you are asking

Point in time restoration ,point of failure restoration not possible in bulk recovery model becoz of minimal information..(doing bulk operations)

If so how can...

The account that you are running this under, does not have the correct permisions. If you running this from SQL server then you will need to have the account...

Are you going to use the agent to run this job? if so you can simply click on the run in 32bit mode flag.

If you are going to use...

The only way i can think of to do this, is to use the filtered list as suggested then in your CLR or Application you would need to loop through...

use the /X86 flag to run in 32-bit mode

this is only for the agent, not too sure how you do it from the command line. I assume you...