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

Once again it is been prooven : a sound dba must pop the questions !

and the attitude will change from [b]"must now ... chop chop.. cannot do it other way..."...

KingCobra (2/24/2010)

---

There you go,

Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT...

You should indeed be able to define a linked server from sql2008 to mysql.

However, If you also want performance, that may not be your best choice !

If you don't need...

Thank you for the feedback.

That's a bummer :ermm:

Isn't each db engine like an "add on" for NHibernate ?

So maybe just adding MySQL in the config could do the trick.

My...