I'm sure the CrLf is in there, it's just not visible based ont he tools you are using;

Proof: you said it looks like this:

Dear Committee Member,

We'd like to invite you...

Best practice is for each column you need to change should have a single ALTER TABLE statement for it.

your syntax was way off, probably just peudocode, but the example below...

i'm pretty sure there is a CHAR(13) + CHAR(10) in there, that you are not seeing, but is part of the data...THAT is what is getting replaced witha < br...

the error message from MS was really good; it basically said to check the Surface...

search for "ProperCase" in the scripts section for even more ways to do this;

here's an old example which assumes a Tally Table exists:

--===== Create and populate the Tally table on...

do you mean like this:

SELECT DISTINCT

CONVERT(CHAR(50),'ecd or emm') AS RESULTS,

...

so that it is say, 50 chars, padded with whitespace?

i have this saved in my snippets from a similar post:

--Security List Admin rights

EXEC sp_MSForEachDB 'SELECT ''?'' AS [Database Name], su1.name AS [Database User Name], su2.name AS [Database Role]

...

well, you can check the status of the databases:

select * from sys.databases where state_desc <> 'ONLINE'

--possible values:

/*Database state:

0 = ONLINE

1 = RESTORING

2 = RECOVERING

3 = RECOVERY_PENDING

4 = SUSPECT

5 =...

i have this snippet saved from SQL 2000, which is supposed to add back Builtin\Administrators if it was removed;

i ran it on my SQL2008 without errors, but that doesn't technically...

ahh good point Ian; forgot about that one;

i just tested, and if anyone is connected, you need to kick them off with Ians command as well:

ALTER DATABASE [SandBox2000] SET OFFLINE...

here you go:

http://www.lmgtfy.com/?q=trigger+types+in+sql+server+2005

http://msdn.microsoft.com/en-us/library/ms189799.aspx

general, generic questions like this are probably best suited to a google query rather than asking a forum and waiting for an answer.

you don't really shut down a database, but you can kick everyone off so you have exclusive access; you might do that so you can restore the database, or detach...

I think packet size is a TCP/IP limitation; it's not really related to the program that sends the data(ie Word, SQL 2005, MYSQL,etc)

For Ethernet LAN/WAN, max packet size is 1500...

this was an order of magnitude faster: 8 minutes to create a text file to disk, then 20 seconds to bulk insert into a table

using the /b command, it was...

here's something to get you started. Assuming you've enabled xp_cmdshell, and the SQL service is using credentials that can see the program files folder, this command would give you a...