No a log backup only marks the log content "ready to be overwritten".

It will not shrink your transaction log file !

What is the result of DBCC OPENTRAN (to be...

write an update statement in stead of the delete / insert.

Keep in mind, you need to check if it actually updated a row (@@rowcount)

Because if it didn't, you'll have to...

I would start sqlprofiler, your cleaning up of data may have caused some application to fail, hence it is trying to do its work, but rolls back time and again...

If you can, start with an empty table, because it will handle the partition shift at the apply partitioning time.

At insert time, it will put the data in the correct...

You database consists at least of two files ( e.g. db_data.MDF and db_log.LDF)

The sum of both files make your total db size, but the LDF file will only contain log...

This is a good article that proves how normalization helps you design and maintain a database.

push your access project to a test sqlinstance using Microsofts Migration assistant for Access to SQL2008 and see how it handles it !

This migration assistant is free !

http://www.microsoft.com/downloads/details.aspx?FamilyID=133b59c2-c89c-4641-bebb-6d04476ec1ba&DisplayLang=en

you might as well just add the new drive(s) and move some of your current db files to the new location.

Keep in mind you need to copy the folder structures...

negative spids can be related to MSTDC having problems to handle a distributed transation.

have a look at http://robkraft.spaces.live.com/Blog/cns!E6687F3AB6372637!161.entry?wa=wsignin1.0&sa=14956856

Did you have a look at http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/01/25/setting-up-database-mail-to-use-gmail-account-for-presentations.aspx

Did you enable the tcp/ip protocol for your sqlexpress ?

Use sqlserver configuration manager.

You should have come to something like this ...

DECLARE @xml NVARCHAR(MAX)

DECLARE @body NVARCHAR(MAX)

DECLARE @email NVARCHAR(MAX)

CREATE TABLE #tmp_tableC

( fullname nvarchar(30)

, emailaddress1 nvarchar(max)

...

It's obvious you must execute sp_send_dbmail once for every receipient, right ?

So you're bound to a while loop or cursor anyway.

I hope this one puts you back on track ....

Here's...

did you have a look at this article ?

http://www.sqlservercentral.com/articles/T-SQL/63953/

Let's hope they finally are equal in sql2008.

It's a...