I guess you're running "standard install scripts" using sqlcmd.

In your dos command just use:

rem using windows authentication

sqlcmd -Syourserver\yourinstance -E -s"create login ..."

Check out SQLCMD in books online for all parameters...

With regards to SSIS, I always advise a team of programmers to learn it, just like they would learn any other programing engine.

It is very powerful, but there can...

Did you notice they published a "who is coming' at SQLPASS ??

http://www.sqlpass.org/summit/na2010/Connect/WhosComing.aspx

and I'm on that list :w00t::cool::hehe::-D:smooooth:

MPs were the most "forgotten" topic with hotfixes and service packs. (e.g. the sql2005 sp2 fiasco having a CU1 within the week)

- Remove all the hints and tweaks you use with sql2000 !

- check out the graphical execution plan and see how it proposes for new indexes. Keep in mind you'll...

we use no maintenance plans but schedule our own backup jobs using sqlagent. In the past there have been troubles with MPs, and many people switched to their own controlable...

Indeed ... that's a very nice toolbox item :w00t:

LutzM (10/22/2010)

ALZDBA (10/22/2010)

Jeff Moden (10/21/2010)

Thanks for the input, Johan. Heh... from what I've...

- How to resend email in Database Mail? http://www.sqlservercentral.com/Forums/Topic673403-146-1.aspx#bm793953

and off course also my troubleshooting script:

use msdb

go

/* is dbmail config activated ? */

Select *

from sys.configurations

where [name] = 'Database Mail XPs'

go

exec sysmail_help_queue_sp...

To get you started .... assume every documented pigeon has one male and one female pigeon for parents.

Attached a little brainstorm to start with an experiment on the hierarchy datatype.

Jeff Moden (10/21/2010)

Thanks for the input, Johan. Heh... from what I've seen, even...

Nice article, Shaun.:smooooth:

Chances are you will get errors if you just perform "select * from table".

This doesn't mean you will not be able to pull data from that table.

Try to put the...

I tought it was...

If an activation sproc is modified, and ssb notices that, it will put a notification in sqlservers errorlog.

Off couse, this does not cover for the generated dynamic sql.

This message will...