I've put some code up here (years ago), then a few years later was trying to solve an issue, did a google search, and what was the first item that...

CREATE TABLE encrypted_login_details(

ServerName varchar(15)

, username varchar(10)

, password varbinary(100)

)

go

--EncryptByPassPhrase:

INSERT INTO encrypted_login_details(ServerName,username,password) VALUES('MyServer','MyUserName',EncryptByPassPhrase('SSIS Is the future','ThisIsThePassword@1234'))

/*

-Syntax: ENCRYPTBYPASSPHRASE('PASSPHRASE','text')

In this statement, PASSPHRASE specifies the data string to be used to derive an encryption...

Thanks. I d did manage to solve it. Apparently I had a mismatch between the server name in my tnsnames.ora file and the server name in my script....

There is more than one person watching this...I'm trying to work out what the "SID" is.

Running the script gives me this:

OLE DB provider "MSDAORA" for linked server "MyServerName" returned message...

Thanks, but you cannot get to a table list unless you have selected both a database and a server.

Even though this is two years old, I did end up working...

What Jim said + 1

What's the difference between "the cloud" and a data centre providing hosting? A lot of companies that I've worked with over the years have been quite happy to...

dwain.c (5/22/2012)

You might be surprised how few people take the...

I'm just lazy... 😀

ISNULL()

COALESCE()

+1

While I agree in principle, the proliferation...

+1

I haven't yet read the Bloomberg article yet, just the snippets from Steve's editorial. I am a software engineer specialising in Data Warehousing, SSIS & SQL Server...

Revenant (12/8/2011)

<snippity snip>

I think I could make an argument that humans share some of what we call 'morals' with other species of mammals; for example, special consideration for mothers with...