well, i have a shared web server out there somewhere, so i throw my screenshots there, and link directly to them.

so if you are not linking to an image you...

Login Failed for user '' looks a lot more like a blank username was passed to the server, rather than the password changing.

otherwise i'd expect the error to say Login...

SQLKnowItAll (3/14/2012)

---

Taking a stab... I think the OP is asking if there is a way NOT to use a linked server to gather data from another server for the view....

the error is here: one column is missing a comma, so the field is used ans an alias instead:

to check that one, specific value, this will do what you ask, but you must change the "StrongPassword" to whatever the key is the developers gave you:

USE tempdb;

-- create symmetric...

sql renames tables via a stored procedure..the syntax you are using is appropriate for Oracle only, i think.

sp_rename 'OriginalTableName','NewTableName'

--or

-- if you have two items with the same name but different...

krypto recopy my post, i edited it to use all nvarchar(max) columns; DESX uses varbinary as the cypher results, but AES is still text, so i tweaked and re-tested, and...

here's exactly how i've done it, along with the link i used to build my model.

I used DESX, and changed the code below to AES_128.

note AES requires Server 2003.

--http://www.4guysfromrolla.com/articles/022107-1.aspx

-- use...

After you've deployed it once, you can script the assemblies out, just as Nils is describing;

Paul take a look at this post here in the Discussions thread;

http://www.sqlservercentral.com/Forums/FindPost1079779.aspx

That post ( a few posts above this) has a much more modern scripting style that correctly takes into...

I like your example Cadavre, but there's a possbility of creating names that contain unintenteded...

you could do it with a suite of DDL triggers, but would it not be easier to tell the developers not to do it.

it seems a little extreme to do...

sure just add something simple like Firstname + '.' + Lastname + '@fake.com' to generate John.Smith@fake.com

no tool, documented or not that i ever saw to do this;

i've had to script this out manually, which is a bitc...er i mean .. rather involved.

here's my old mental...

ahhh they are scared of the claw SSIS!