July 26, 2012 at 12:04 am
Comments posted to this topic are about the item Using SMO 2012 to trouble shoot support issues
I work for 1st Consulting, a small ISV based in the UK. We build web and desktop applications using the MSFT stack. Find us at www.1stconsulting.biz
July 26, 2012 at 3:57 am
Wouldn't it be easier to have an admin server in your datacenter hooked up with Terminal Services and a copy of 2012 on it? You could then also use it as a central management server and whatnot, and only need to vpn in and rdp to it?
July 26, 2012 at 5:25 am
Hi Rich,
sure it would!
However, like I said at the bottom of the article, it was a little contrived to highlight certain parts of SMO.
Cheers
Peter
I work for 1st Consulting, a small ISV based in the UK. We build web and desktop applications using the MSFT stack. Find us at www.1stconsulting.biz
July 26, 2012 at 5:55 am
Ooooooo....
I think if I found one of my developers using SMO to access database objects directly, that person would be found hanging from a cross in the morning.
This situation is exactly what having an API full of stored procedures is for. The devs should never be querying base tables directly, or updating database / server level settings.
Any dev wishing to try using a programmatic interface to access SQL Server would also likely run into permission problems, as the credentials they have may not have permissions on various objects.
---
Note to developers:Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.
July 26, 2012 at 6:48 am
Nice article.
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comJuly 26, 2012 at 9:01 am
Hi Derek,
I dont think I would use SMO for general "day to day" tasks.
However, if you are looking to automate operational tasks or integrate from a line of business application then this is a great tool to have in your bag.
Cheers
Peter
I work for 1st Consulting, a small ISV based in the UK. We build web and desktop applications using the MSFT stack. Find us at www.1stconsulting.biz
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy