i've done this all via TSQL; I happen to also get all the scripts in FK hierarchy order as well.

this has a dependancy for the procedure sp_GetDDL, which gets any...

i use this and stick it in master:

usage is simply sp_kill databasename

this is simliar to Sanjay's, but a little more robust on a couple of validation things like your own...

Shabba (10/30/2009)

hmmm... can only seem...

the unregisted version of Editplus is free, with only...

i use the cliptext feature of Editplus to save all my snippets and valuable code; i try to organize with a keyword and brief description;

if i double click on the...

ok, if things run under a default account like you said, this is my next guess: does it return the correct results?

Select

'Sept'as mnth,

td.tdes_m,

tran_x,

...

this is just a guess, but i think this would return a result set for all of your numbers, so you can avoid a cursor.

Select

'Sept'as mnth,

...

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