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

This is difficult to achieve outside of EM - see the following link for more info. if the EM solution is not what you want.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=126116&p=1

Regards

As you will see if you run this piece of code, your method should work.

declare @temp varchar(10), @service varchar(10), @office varchar(10)

set @service = 'P'

set @office = 'L'

set @temp = @service...

To prove your suspicions, you could try changing the offending select statements by adding WITH (NOLOCK)?  I do not know the answer to your @@isolation question.

Regards

Phil