Lynn Pettis (3/15/2012)

---

SQLKnowItAll (3/15/2012)

---

Lowell (3/15/2012)

---

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us...

sorry gang, link is fixed.

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread here:

http://www.sqlservercentral.com/Forums/Topic1267763-391-1.aspx

i've done what you are asking in another post...if you followed the netiquette, as ColdCoffee suggests, I probably would have posted the solution.

in the meantime, if you search the forums...

there's a number of threads here on SSC where the requirement is to remove public permissions in order to comply and lock down a SQL server to DoD standards (google...

first, you don't need a trigger...you could simply add a check constraint to prevent that.

ALTER TABLE product1 ADD CONSTRIANT CK_COST_VS_SELL CHECK(costprice <= sellingprice)

your trigger assumes only one row being inserted,...

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;