Grant Fritchey (12/11/2007)

---

In a case like this, use the tool above or, if you want to roll your own, SMO (SQL Management Objects) allows you generate SQL scripts by object...

this:

FROM ml where ((ml.conta not like '243%' or ml.conta not like '22%') and (ml.conta between '21101' and '26901'))

should be this:

FROM ml where ((ml.conta not like '243%' and ml.conta not like...

"business rules dictating triggers firing off emails"

isn't firing off an email for every transaction a core part of being ACID?

🙂

I wrote a console app to do exactly this. it's open source also.

http://www.codeplex.com/scriptdb

you can just use 3 part naming if the db is on the same server:

exec OtherDB.dbo.ProcName @myparam=1234

Gift Peddie (10/18/2007)

---

jezemine (10/17/2007)

---

you can certainly have resource...

uh, no. using NOLOCK by default is not a good habit to...

I understand it's a pain to have to call Dispose,...

you can certainly have resource leaks in managed...

Jeff Moden (10/14/2007)

---

Not quite true... Much like an extended stored procedure, a CLR is precompiled and not changeable from SQL. Since it is precompiled, it can be set to...

Jeff Moden (10/13/2007)

---

Another reason might be so that you can create the functionality not allowed by some DBA's. For example, shelling out to certain DOS/CMD functions might be impossible...

rudy komacsar (10/11/2007)

---

On a more personal note, my deepest sympathies to those converting time in Indiana. Whilst being a life long Hoosier, I have been luck to live in one...

I wrote a documenter that will do this for you also - see link in my sig.

it's extremely annoying to not be able to see the post you are replying to - in fact I think there ought to be a "quick reply" textarea on each...

Gift: not sure why you posted those links, none of them really show you how to use sqlcmd or osql...

anyway, the best reference in all things related to SQL Server...