MS SQL Server - MS SQL 2005: How can one justify using SMO over T-SQL?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

MS SQL 2005: How can one justify using SMO over T-SQL?

DontBotherMeWithSpam

2006-10-25, 6:00 am

For few days, I have been trying to write a little Cmdlet in PowerShell
using SMO for creating a new SQL Server 2005 Logins.

Few times I've heard that it's just an overkill to be using SMO instead
of using "CREATE Login" through ADO.NET to call either a sproc or just
run "CREATE LOGIN" statement directly by passing appropriate arguments.

I am wondering when people resort to SMO to handle administrative tasks
instead of T-SQL.
Are there any tips or know-hows links or books on which I can delve
into?

What steps should I consider before using SMO over T-SQL?

Any links, books, blogs, KB, BOL links would be appreicated.
Thank you in advance.

- Sung

Sponsored Links