Dave

I think the biggest risk is in terms of performance.  Both SQL Server and IIS like to grab as much memory as they can.  If you are short on resources...

If you're asking will the query optimiser use the index on PK_TAB_B, the answer is no, not if the PK is defined with the columns in the order you specify. ...

I think you will be able to achieve what you want with replication.  You can use the replication stored procedures to transform the data using code similar to what you...

Luis

It shouldn't be a problem.  If you try to create a stored procedure that calls another that doesn't exist, you'll get a warning message but the stored procedure will be...

Brian

Have a look at the topic SET IDENTITY_INSERT ON in Books Online.  You will want to pay particular attention to the following line:

If the value inserted is larger than...

Jef

Please will you post the DDL and some sample data for the four tables (or three if, as I suspect, table_lines and table_orderline are actually the same table).

Thanks

John

Why wait until Monday?  Just put in Monday's date instead of GETDATE()!

John

Does my solution not work for you?

John

Richard

Look up the CHARINDEX, LEFT and RIGHT functions in Books Online.  They should help you get what you want.

John

Yes, it should be safe to install a third instance.  All that you've got missing are a few shortcuts.  Maybe somebody tried dragging them from the Start Menu on to...

Don

The easiest way is indeed to create a script.  Right-click on the database in Enterprise Manager and choose Generate SQL Script.  You can then make lots of choices about what...

Are you sure this produces the results you require?  You don't have a join predicate to ASP_MASTER, so for every row in the result of the first join, you will...

The reason you have to set up the share as a clustered resource is so that it is a part of the virtual server rather than part of one of...

Megan

Might be better to treat the cause rather than the symptoms... You can avoid fragmentation in the first place by setting you log files as large as they are ever...

No, you do this in Query Analyzer.  You will find the syntax in Books Online under ALTER TABLE.

John