The easiest way to do this is first to add the new columns to Sarah_2 - just use Enterprise Manager - making sure that the datatypes are the same as...

Not 100% sure I understand.  Do you want to create a brand new column in Sarah_2 to which will be copied the Sarah_1 data?

Is there a one-to-one relationship between the two tables?

Regards

Phil

Excellent stuff - like it.

OK, this isn't so bad.  If you execute a CREATE TABLE script after a DROP, it will do exactly that - delete the table and its data and then recreate the...

This sounds like an Access issue rather than a SQL Server issue - files do not "get locked for editing" in SQL Server.  In Access, open the database and check Tools/Options/Advanced, ensuring...

Hi Sarah

If you are just changing the structure of an existing database, you should be able to script the required changes without losing data (but this depends on the extent...

Please expand: PS = what?  Power Supply?

Regards

For future reference, please do not post the same question in multiple forums.

Please refer here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=192152

For future reference, please do not post the same question in multiple forums.

Please refer here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=192152

For future reference, please do not post the same question in multiple forums.

I do not like the idea of duplicating all of this data using triggers - it goes against...

I agree - having your db designed like this will always frustrate you as queries which should take 30 seconds to write will take 30 minutes and perform 10 times...

I think that any limit on the number of physical files that can be stored will be at the folder level - so can you just create some sort of...

Check out BOL "Using the inserted and deleted tables" for more info.  To summarise, the 'inserted' table is a temporary table that contains a copy of the record (or records)...

You need to use a join to get the best performance.  Indexing on the id fields would also help a lot.

select * from table2 t2

left join table1 t1 on...

Use CONVERT in your SELECT statement to format the results that are returned by the SELECT statement - this will not affect the underlying data:

SELECT CONVERT(blah blah) as NiceDate, ....

will display...