If I understand correctly, you should be able to use this. The in clause will return all of the cxa_adr_key values that currently have cxa_on_hold_flag = 1. The...

After looking at the query a little more, I am not quire sure what you are trying to do. It looks to me like you are just trying to...

You have it in the query twice with the same name.

update co_customer_x_address

set cxa_on_hold_flag = '1'

from

(select distinct a1.cxa_mailing_label, a1.cxa_adr_key, M.cxa_adr_key

from co_customer_x_address a1

outer apply

(select a2.cxa_adr_key from co_customer_x_address a2

where a1.cxa_adr_key = a2.cxa_adr_key)...

The first thing that stands out to me is that you need to alias the query in the from clause.

update co_customer_x_address

set cxa_on_hold_flag = '1'

from

(select distinct a1.cxa_mailing_label, a1.cxa_adr_key, M.cxa_adr_key

from co_customer_x_address...

Are you doing something like dropping and recreating the database for some reason? The first time a database is created, you can't perform a TLog backup until you have...

You can use the replace function as long as you want to replace all occurances of the server name.

Update Table

Set Col = Replace(Col,'ServerName','NewServerName')

If you just want to replace...

I have never set up Database Mail using Gmail, but this link may help.

http://mail.google.com/support/bin/answer.py?hl=en&answer=13287

Both databases need to run on the same version. Here is a link.

http://technet.microsoft.com/en-us/library/ms366349.aspx

The first thing that comes to mind is that the transactions are stored in the distribution database until they have been applied to all the subscribers. If connectivity is lost...

Try this. You can set it to single user mode and immediately roll back all of the transactions. Then it should be all yours...

Alter Database MyDatabase Set SINGLE_USER With...

Transaction Log backups are only supported using the Full and Bulk-Logged recovery models because the Simple recovery model truncates the transaction log on checkpoint (when the data is written to...

You are only allowed to have one clusted index on a table. By default, when you create a primary key, a clustered index is created on the columns that...

Thanks Jonathan. This one came in handy today.

You can use the ISNULL function to return a 0 if the value is null.

Select ISNULL(val1,0) - ISNULL(val2,0)

Thanks Jeff.

I knew there was a way to do it without the math, I just cound't think of it last night.