then how about creating a role that revokes the rights to the specific column, and adding everyone except the app login to that to take away th permissions of the...

[Grant said this in another thread]

sp_addextendedproperty is for putting descriptions, etc., on to your SQL server objects. It doesn't do any kind of formatting of any kind. It's for creating...

odeonkreel (6/24/2011)

---

I have many users setup in my SQL 2008 db.

All those users are then assigned to Database Roles I created, based on jib function/department.

Those Roles then specify what tables/views...

you'll need to query each server, but the query is the same for each server:

SELECT name FROM master.sys.databases where LEFT(name,3) = 'MSX'

this is where you might want to consider a...

don't forget more than one space in a row will not render in HTML by default, you have to replace with   or CHAR(160)

reminds me of some of the other threads , like where the poster wants to encrypt the definition of his tables, because, to him, that might reveal a trade secret...

by fixed dollar sign, what do you mean? a dollar sign followed by a number up to say, $999,999,999.99 in size?

so 1.22 has 10 spaces between the $ and the...

it goes back to the "who can you trust" issue.

if you cannot trust the people with the keys to the database, there's basically three options: remove the keys, remove...

can you get the data with a delimiter that is not used in the data, like a tab delimited or pipe [|] or tilde [~] or something? for get the...

i htink you also need a backup of master just in case;

I thought the CREDENTIAL for any database mail username/pass used for the AUTH command are in master, and i...

ok, BULK insert's about a zillion times easier to use than SSIS.

your original table definition that you posted is missing two columns that appear in your data, country, and selection...

CrLf is CHAR(13) + CHAR(10), i think you have the order reversed, so it's not finding anything.

REPLACE(Col011, CHAR(13) + CHAR(10) , ' ') AS Expr2

Thanks! i got inspired by seeing at least three recent threads with that same theme.

gotcha, so in a disaster recovery scenario like that, where the mdf was damaged/lost, you would not be able to do a tail backup...

all you can do is restore the...

instead of a trigger, i strongly recommend a scheduled job that migrates the data to the linked server.

if the linked server cannot be connected to(due to username/password, networking issues, or...