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!

it depedns on your source.

if you only have 3 firstnames,3 middlenames and 3 lastnames that is 3x3x3 = 81 unique combinations.in two million rows, that will repeat a lot.

if...

a set based operation will be orders of magnitude faster than c#.

you need the three base tables, say FNAME,MNAME and LNAME.

the secret is to cross join the three agasint themselves,...

Sean Lange (3/12/2012)

---

That sounds...

"Login failed for user ukk_admin"

means you connected to the server, so it's gotta be user/login related.

on the new server, did you CREATE LOGIN ukk_admin ?

if you restored a copy...

did you try specifying the specific port in the connection string?

for exmaple, if you changed the dynamic listeninc port below from 1711 (or whatever yours currently is) to port 14330...

we have additional columns in one of our databases, instead of rows.

so the application ends up displaying the column [descrip_en-us] of , say Row 1 for a product,

[descrip_fr-FR] for french,...

i also have this snippet for stripping comments via TSQL; if you could get that to be an inline function, you'll have it all;

the onyl way i could think of...

to do it all in sql, you'd need a CLR for stripping comments out; then it could all be done via TSQL.

this would be my prototype to start with:

SELECT *...

pallvi.pathania (3/12/2012)

---

Essentially all the databases are made from a clone so most of them might be exactly same. But I am loooking for incase for any database if there was...