Yes it's possible but it's the application's job to do that. Why do you need to do this on the server?

2, they don't do the same thing, and they won't always run when the other is ran.

Hard to say... the process just seems LOONNNNNNNGGGG. And it's not helped by the denormalisation. The best guess I can give you is to try to optimize your...

So what do you have access to exactly?

That's the way the transaction should work, if something doesn't work, ALL FAILS. That way you can correct the problem and resend the whole transaction without having to find...

There's no magic button for that, you need to learn it by yourself : Perf tuning articles

You might ask for help >> consultant, new temp, formation. depending on the size and importance of the job.

And you have no design training??? You need to correct that fast. Normalisation is an art, it can't be learned by yourself overnight. You need (HAVE TO...

You can always open a doc file, and select all the text, and do an insert into a text field, which you can then index in a full text catalog....

You can make sure no data loss is possible :

Declare @demo table (name nvarchar(25) not null primary key clustered)

insert into @demo (name) values (N'this is a long string')

insert into...

So true... but there's something to be said for less paper even if paperless out of the question .

Thanx in advance.

Acronymfinder.com .

TIA.

Pretty much all I had... you'll have to trust non microsoft sources on this one. But I guess building you're own table after that wouldn't be much of a...

HTH 2. Now that reminds me of this thread .

Do we need paper?