In the file connection manager, click on properties and then click on expressions.

Create an expression for connection string and use the expression builder to add your user variable adn...

Make sure you have Full-Backup and Transactional Log back-Ups running, work out how much data loss the company can handle in a disaster and time...

Right Click on the Table in SSMS --> Script Table...

From what i understand the warning about Database mirroring not ready for production was fixed in SP2.

Really hard to tell without seeing the table structures and some data.

From first looks, you could make this query better by using INNER JOIN notation to join your tables, ...

The first thing you should do is go through the .Net code and find out what columns are actualy being used, i don't believe the application is using them...

300 columns is a lot for one table, as mentioned don't Select *.

Can you post your table definitions ? for some further advice

You really need to have a primary key for replication to work, otherwise the rep-agent would not know what rows need updating.

So my suggestion would be to add primary key,...

Are you using Unicode data types in SQL server ? nchar + nvarchar

Mad-Dog (2/3/2009)

no the file name is not static but what static is the . and then 3 letters

and before that there is this so we have in the end \test.mdf

i...

You need to use the sum aggregate function in the select statement

select distinct

BI.REF,

BI.DESIGN,

SUM(BI.QTT),

...

Make sure you do a Full Backup AFTER the process as well, otherwise you will not be able to restore from Transactions logs as the chain will be broken.

If the data size is to big for the column then the insert will fail.

Otherwise if is the the same size or less then it will succeed.

This does depend on...

Not really a good idea to prevent attacks, you should really be using paramatized SQL in your procedures, rather than executing a Dynamic SQL statement.

Also there are other ways...

Sorry i don't have any examples on hand as I do not use SAS at all at the moment i am unable to run any tests.

Try looking at the SAS...