the mail server in your databasemail profile you are using in = your Exchange Server?

i've got several profiles set up , some with the company mails erver, some with...

i think the issue is related to the mails erver, and not your database configuration settings.

Are you using your Exchange server that Outlook points to as the mail server in...

i usually use dynamic sql for the command, as if i'm adding a table that doesn't exist, the script will fail validation.

IF EXISTS(SELECT 1

...

bulk insert allows you to use a format file, and the format file handles the quoted delimiters for you.

without the format file, you end up having to handle the delimiters...

if there are different server versions, for example ServerA is SQL2005 but ServerB is SQL2008, you'll want to rebuild the indexes as well as rebuild the statistics for non-index columns;...

since you are migrating from another table, and at least one value already exists, shouldn't you be joiing on the local data to prevent the duplicates from being inserted?

or do...

i may be misremembering the thread; i'm searching thru my posts now to find it; i was fiddling with trying to make an example, but the clustred index i'm creating...

I think Gail had posted that they are logically stored in the clustered index order, and not necessarily physically stored once you look inside a page.; there was a post...

well remember floats are stored as approximations, so i'd suspect witht eh full details, that's where the issue lies.

SQL

with the one exampel you offered, i don't see anything specific...

are you sure it's an inline TVF? if you are in the database you know it exists, what does this return?

select type,* from sys.objects where name='getuserrelations'

can you start sending differentials or transaction logs to the other site instead of full backups, and start doing incrementals restores there instead?

this is one of the ramificaitons of having the "universal" lookup table instead of one lookup table for each logical group of values.

to do what you are asking, you need...

since MySQL is preventing you from multiple UNIONs, you'll end up having to insert into a temp table (MySQL has temp tables, right?

3 unions would be three inserts, all into...

bcp.exe requires a MS operating system....so you can't call bcp.exe from a unix operating system....

but you can bcp a FILE into or out of a shared directory that exists on...

I'm thinking it's because of statisitcs..the plan itself is fine, but the statistics used get more and more out of date as that 10% per day occurs.

when you recompile...