Unfortunately  any Table access performed before a rollback is lost no matter what. Nested transactions are a little bit intensive and difficult to manage because of the inherent limit of...

select 'A' as Data, count(*) from dbo.SysColumns

union ALL

select 'B', count(*) from dbo.SysColumns

Order by Data desc

is this what you want?

Ah, ussage is your promblem! this is how you are supposed to use it:

at setup time call sp_addmessage for all required languages

ex:

use master

exec sp_addmessage @msgnum = 50001, @severity = 10, ...

That (multi-lingual) is actually one of the stregnths of raiserror !

Why are you saying that ?

This is a tricky question in which there are no Absolutes. The right anwser is "it depends on the application". I bet none of us would like to see the...

>> ... from the Weekly table and then transfer just one occurrence with the aggregated value to the Current table which does have a PK. <<

What is the PK in there? can...

--create table dates([date] datetime, shipment char(4), client char(3), nrofcollo int, Destiny varchar(20))

-- set DATEFORMAT dmy

-- insert into dates ([date], shipment, client, nrofcollo, Destiny) values ('14-01-05', '1254', '012', 1 ,'France')

-- insert...

if you have them in both places and marked as "NOT FOR REPLICATION" in both places you need to partition or manage the value ranges at each location. In other words...

another recomendation:

 try to set lazy_schema_validation "on" for that linked server using sp_serveroption

Melissa,

if you look at the table Email_Templates and add the maximum size that each column can have, you'll see that is more than 8060 which is the maximum recommeded value...

Well if you can not do what Remi just posted You will need an automated tool that captures that information (Be ready to spend big $$$) You can use

On EM

select Tools->Options and uncheck Read/Store user independent

hth

I believe the best way is to replace the values for explicit defaults on the  inserted table using isnull()  but if you still want code independence (I mean if you change a...

if that database has no FK you could

sp_MSforeachtable 'Truncate table ? '

if there are  FK -- Which btw should be the expected thing

you have to find the dependencies on the tables and...

It is not overriding the identity property, it is replicating the PRIMARY KEY!

Not for replication will provoke that the data replicated (inserted) at the subscriber won't affect the value of the...