Interface for executing SSMS Packages

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Interface for executing SSMS Packages

Interface for executing SSMS Packages

Rate Topic

Display Mode

Topic Options

Author

Message

Veena Pande

Posted Tuesday, November 25, 2008 10:22 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, June 17, 2009 10:24 AM
Points: 4, Visits: 34

Is there a way to create a quick interface like SSMS to manage SQL tasks for assigning roles?

Post #608850

RBarryYoung

Posted Tuesday, November 25, 2008 11:40 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

What would an SSMS Package be?

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #608869

Veena Pande

Posted Tuesday, November 25, 2008 11:52 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, June 17, 2009 10:24 AM
Points: 4, Visits: 34

Let me rephrase the question. I need to create an interface using which a user who does not directly work with SQL Server can create roles, logins, give rights to users etc. I was thinking it will be like simulating SSMS.

Post #608872

RBarryYoung

Posted Wednesday, November 26, 2008 7:04 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

Well the functionality is not too hard, you could either use SMO, which is effectively the API for SSMS (actually, it is the management API for SQL Server, which SSMS uses) or you could write a series of stored procedures to give a relatively unprivileged and non-technical user the ability to do this.

What is a lot trickier is the user interface. There are no forms or graphical input capabilities built in to SQL Server (or SSMS), you have to either write client code or just use an existing interface like SSMS. You could just train your user to use the stored procs mentioned above, but this is not very visual.

The alternative would be to write your own GUI using C# or VB.net. It sounds like an interesting project/utility though, something that might be reusable for many other SQL Server customers.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #609042

Jerry Hung

Posted Wednesday, November 26, 2008 7:58 AM

Right there with Babe

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 3:02 PM
Points: 768, Visits: 1,159

Mnn, if you assign the users appropriate limited permissions
Won't they just use the same SSMS interface, just with less options?

They don't see everything a sysadmin would see

Beyond that, either write your own GUI or SMO/Power Shell (which I think it's only in SQL 2008)?

SQLServerNewbie

MCITP: Database Administrator SQL Server 2005

Post #609110

« Prev Topic | Next Topic »

Permissions