You cannot alter a UDT if it is used by objects.

do you mean

update yourtable

set yourcolumn = ''

where yourcolumn = 'NULL' -- column actually contains value NULL

or

update yourtable

set yourcolumn = ''

where yourcolumn is NULL -- column actually...

Yet another query 🙁

Maybe you'd be better off just copy/paste-ing the actual thing you want...

What is this selects giving you as a result:

Select count(*)

from myTable

where [CAR1] IS NOT...

Hey, hey, ..... that's not what you posted first...

metalray (10/8/2008)

---

Hi Guys

I am down to one column that causes a problem. I have a simple INSERT:

INSERT INTO dbo.myTable(Code,Car, Amount)

SELECT

[AR] As [Code], --Year

[SDF] As Car , --Vendor

[SVB] As Amount...

You have to open the needed port(s) clientside in the firewall.

HowTo ? That depends on the firewall software that is installed.

more info: http://support.microsoft.com/kb/287932

Since this is a clean install, I would upgrade to SP2 + CU9 or 10

and only then try debugging this

Did you enable sqlserver for his firewall (client side) ?

with db mirroring, every action on the primary database is sent to the mirror db.

It is not active, so no one else can tamper with it.

Keep in mind a backup file can contain more than one backup !

Are you creating log backups using the NOINIT parameter ? That's the way you can add a backup...

check the ms website for more info and prereqs.

http://www.microsoft.com/sql/solutions/migration/oracle/default.mspx

and

http://www.microsoft.com/sql/techinfo/whitepapers/MigrOracleSQL2005.mspx

That should be ok.

Yep, checking is what makes this job worth the while :hehe:

Chris Morris (10/3/2008)

---

Had to try it, guys...

[font="Courier New"]DECLARE @StringIn VARCHAR(200), @StringOut VARCHAR(200)

SET @StringIn = 'The Quick Brown Fox Jumps Over The Lazy Dog.'

SET @StringOut = ''

SELECT @StringOut = @StringOut +...

There is a MS white paper called "MS WP DatabaseMirroring.doc"

It contains a nice overview of all sqlserver replication techniques and when to use them.

This is a "hear say" :the only...