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...

Our best friend ... BOL ... guided me on this one :w00t:

/*

http://www.sqlservercentral.com/Forums/Topic579917-338-1.aspx

ROT13 ref http://en.wikipedia.org/wiki/ROT13

*/

CREATE FUNCTION dbo.ufn_ROT13 (@inputvar varchar(128))

RETURNS varchar(128)

AS

/*

declare @inputvar varchar(128)

set @inputvar = 'abcdefghijklmnopqrstuvwxyz'

select @inputvar = @inputvar + upper(@inputvar)...

mtassin (10/2/2008)

---

The problem with this plan is that CLR doesn't work on SQL 2000.

Yes this is the SQL 2005 forum. But... what I'm working on needs to run on...

As I've read from our "SQL Obi-wan Kenobis" (Jeff Moden & Matt Miller 😉 ) this would be a typical case to use a CLR module.

Don't use the xp,...