Using SMO 2012 to trouble shoot support issues

Question

Using SMO 2012 to trouble shoot support issues

Peter Bannister

SSC-Addicted

Points: 461
More actions
July 26, 2012 at 12:04 am

#264687

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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

RichB SSCrazy Eights Points: 9651 More actions · Answer 1

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?

Peter Bannister SSC-Addicted Points: 461 More actions · Answer 2

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

derek.colley SSCrazy Eights Points: 8040 More actions · Answer 3

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:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

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.

Basit Farooq Ten Centuries Points: 1151 More actions · Answer 4

Nice article.

Regards,

Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)

http://basitaalishan.com

Peter Bannister SSC-Addicted Points: 461 More actions · Answer 5

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