here it is, i think: Jeff Modens "Replace Multiple Spaces With One" Article[/url]

ok what i posted works for my sample data, but not all situations...but i swear it's a variation of that concept.

there is an easy way, but it does require nested replaces; it will remove any number of repeating chars with a single one.

I THINK this is how it works by...

you can use the row number function to do paging...is that what you are looking for?

is this a homework or...

what if you are in the office those two days?

do you have anything in place to track it when you ARE there?

(Is you making changes to the database behind my...

SQL 2008 R2 Express[/url]

there are like three different versions of sp_help_rev_login...one for 2000, and two others for 2005/2008 i believe.

you have to use the one specific to what you are exporting from.

this is...

Here's a Calendar Table Generator that I put together; it features all US National Holidays, as well some other that were fun to research and code; if the holiday is...

on the SQL2005 server, you'll want to download and use Microsofts sp_help_rev_login, which scripts out the logins on the other server.

then run the results on the 2008 server.

once the windows...

ugh;

no dev area and developers making direct changers to production(since it;'s the only work area?); Paul's advice about liquor and updating the resume sounds even better now....

how about a...

DBAgal (5/18/2011)

---

I inherited a database where the db users were granted db_ownership. After spending hours on the phone yesterday explaining the db change management process, the developer was given...

a rename of an existing object doesn't count as a DDL operation, so it wouldn't be in the default trace; I investigated that on a similar thread previously.

you'd want to...

here's one way to do it; I'm just creating a table full of high ascii chars, cross applying them, then using patindex to filter:

with mySampleData

As

(SELECT top 255 row_number() OVER (ORDER...

PhilPacha (5/17/2011)

---

Review the "BCP" entry in Books Online.

-c controls the output of data - in this case, "character."

-r controls the row delimiter

-c -r /n

Review the "BCP" entry in Books Online.

Everything...

homebrew01 's method is exactly how I've done it in the past.

now for "special characters", what does that mean? high ascii?(so you have to export the results as NVarChar?), html...