fleshing out a rough example from Sean and Garadin:

--proof of concept:

--unlike your developers, do not do this work on production:

USE tempdb;

CREATE TABLE [dbo].[PERSON1](

...

sure you can, but you have to tackle the test just a little differently;

also,you'll have to switch to dynamic SQL to do the ALTEr + UPDATE part.

how about this?:

DECLARE @tableName...

Ive definitely seen that error when my files were -slash-r terminiated and my script expected -slash-n;

especially since your error said it happened on line1 /column 18 of what we think...

your table has to exactly match the file you bulk insert...it cannot have more or less columns than the file you import;

i mentioned i had to add two columns, and...

and nested replaces are really fast too;

here's an example, spread out for readability/unserstand-ability,...

wow....that's kind of what i...

only what i mentioned before...for example, rename [SFEDID] to [SFEDID_ORIG]

and then create a view named [SFEDID] that selects from the table, that masks that specific column.

you...

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