If you are not going to use SQL Server in production, why use it during development?  Surely you're just storing up a big headache for yourself at go-live when you...

Can't you just keep multiple versions of the database within SQL Server and take Access out of the equation?  If you script all of the db changes you make, you...

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)...