List Server Roles

I am currently working on a SSIS configuration database. However, I am having trouble writing a script to get the the users that have each server role permissions. I'm pretty sure that I need to use sp_helpsrvrole, but am not sure where to go from here. If anybody has any ideas or has seen a script on the internet to get this then that would be a tremendous help.

Thanks in advance,

Kyle

Please try:

exec sp_helpsrvrolemember

this should get the server role membership information you are looking for. Let us know if you have any further questions.

-Raul Garcia

SDE/T

SQL Server Engine

List of SQL Server Error Messages

Hi All,
I was wondering if anybody knows where to get a complete list of SQL Server error messages. I am writing a stored procedure that scans SQL Server Logs for errors and if there are errors in the logs, I get paged.
Thanks.Personally, I just look for keywords. Like "error".|||books online has a lot extremely unhelpful descriptions unser Troubleshooting --> Error Messages --> Error Message Descriptions --> System Error Messages.|||there is a table sysmessages in master db|||That's great. But besides the error messages I am also looking for messages in the SQL Server logs such as SQL Server terminating, backup failed, scheduler appears to be hung etc. I found these messages in the SQL Server logs and would like to get a list of all the possible messages that can be found in the logs.

List of Databases

I am writing an Active Server Page application that will get all of the
databases that a user can access. Is there a way I can do this with Active
Server Pages? I also will provide the users with the option to change
records, table structure, etc with this application.
I will also be developing an asp.net (C#) project that will do the same
thing.
If anyone can provide code snippets or anything that would be great.
Thanks,
Rick Langschultz
Web Developer/IT Manager
Rick Langschultz wrote:
> I am writing an Active Server Page application that will get all of
> the databases that a user can access. Is there a way I can do this
> with Active Server Pages? I also will provide the users with the
> option to change records, table structure, etc with this application.
> I will also be developing an asp.net (C#) project that will do the
> same thing.
> If anyone can provide code snippets or anything that would be great.
> Thanks,
> Rick Langschultz
> Web Developer/IT Manager
What database? Should we assume that it's SQL Server given the inclusion of
the sqlserver groups in your crosspost?
Please don't make us guess. We need to know the type and version of rdbms
you are using.
You left out the dotnet groups that could have helped you with the .Net
code you need (I'm responding from the .asp group which is for classic ASP
questions)
For starters, do a search at www.aspfaq.com. Here's one of the articles you
will find:
http://www.aspfaq.com/show.asp?id=2456
HTH,
Bob Barrows
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
|||the easiest way is:
select name from master.dbo.sysdatabases
Leo
"Rick Langschultz" wrote:

> I am writing an Active Server Page application that will get all of the
> databases that a user can access. Is there a way I can do this with Active
> Server Pages? I also will provide the users with the option to change
> records, table structure, etc with this application.
> I will also be developing an asp.net (C#) project that will do the same
> thing.
> If anyone can provide code snippets or anything that would be great.
> Thanks,
> Rick Langschultz
> Web Developer/IT Manager
>
>

List of Databases

I am writing an Active Server Page application that will get all of the
databases that a user can access. Is there a way I can do this with Active
Server Pages? I also will provide the users with the option to change
records, table structure, etc with this application.
I will also be developing an asp.net (C#) project that will do the same
thing.
If anyone can provide code snippets or anything that would be great.
Thanks,
Rick Langschultz
Web Developer/IT Manager
Rick Langschultz wrote:
> I am writing an Active Server Page application that will get all of
> the databases that a user can access. Is there a way I can do this
> with Active Server Pages? I also will provide the users with the
> option to change records, table structure, etc with this application.
> I will also be developing an asp.net (C#) project that will do the
> same thing.
> If anyone can provide code snippets or anything that would be great.
> Thanks,
> Rick Langschultz
> Web Developer/IT Manager
What database? Should we assume that it's SQL Server given the inclusion of
the sqlserver groups in your crosspost?
Please don't make us guess. We need to know the type and version of rdbms
you are using.
You left out the dotnet groups that could have helped you with the .Net
code you need (I'm responding from the .asp group which is for classic ASP
questions)
For starters, do a search at www.aspfaq.com. Here's one of the articles you
will find:
http://www.aspfaq.com/show.asp?id=2456
HTH,
Bob Barrows
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
|||the easiest way is:
select name from master.dbo.sysdatabases
Leo
"Rick Langschultz" wrote:

> I am writing an Active Server Page application that will get all of the
> databases that a user can access. Is there a way I can do this with Active
> Server Pages? I also will provide the users with the option to change
> records, table structure, etc with this application.
> I will also be developing an asp.net (C#) project that will do the same
> thing.
> If anyone can provide code snippets or anything that would be great.
> Thanks,
> Rick Langschultz
> Web Developer/IT Manager
>
>

List of Databases

I am writing an Active Server Page application that will get all of the
databases that a user can access. Is there a way I can do this with Active
Server Pages? I also will provide the users with the option to change
records, table structure, etc with this application.
I will also be developing an asp.net (C#) project that will do the same
thing.
If anyone can provide code snippets or anything that would be great.
Thanks,
Rick Langschultz
Web Developer/IT ManagerRick Langschultz wrote:
> I am writing an Active Server Page application that will get all of
> the databases that a user can access. Is there a way I can do this
> with Active Server Pages? I also will provide the users with the
> option to change records, table structure, etc with this application.
> I will also be developing an asp.net (C#) project that will do the
> same thing.
> If anyone can provide code snippets or anything that would be great.
> Thanks,
> Rick Langschultz
> Web Developer/IT Manager
What database? Should we assume that it's SQL Server given the inclusion of
the sqlserver groups in your crosspost?
Please don't make us guess. We need to know the type and version of rdbms
you are using.
You left out the dotnet groups that could have helped you with the .Net
code you need (I'm responding from the .asp group which is for classic ASP
questions)
For starters, do a search at www.aspfaq.com. Here's one of the articles you
will find:
http://www.aspfaq.com/show.asp?id=2456
HTH,
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"|||the easiest way is:
select name from master.dbo.sysdatabases
Leo
"Rick Langschultz" wrote:

> I am writing an Active Server Page application that will get all of the
> databases that a user can access. Is there a way I can do this with Active
> Server Pages? I also will provide the users with the option to change
> records, table structure, etc with this application.
> I will also be developing an asp.net (C#) project that will do the same
> thing.
> If anyone can provide code snippets or anything that would be great.
> Thanks,
> Rick Langschultz
> Web Developer/IT Manager
>
>

List of All SSIS packages stored in MSDB

Hi,

I am writing one program in vb.Net where I need to bind a treeview with all the SSIS packages stored in SQL server MSDB database.

Is it possible to get all the SSIS packages by using T-SQL query or Object model ?

Thanks

Reference assembly Microsoft.SqlServer.ManagedDts.dll and create Application object (in Microsoft.SqlServer.Dts.Runtime namespace). To get list of packages use Application.GetPackageInfos method:

http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.application.getpackageinfos(SQL.90).aspx|||

Alternatively the following query returns the list of stored packages from MSDB database:

SELECT * FROM msdb.dbo.sysdtspackages90

Thanks,
Loonysan

List of All SSIS packages stored in MSDB

Hi,

I am writing one program in vb.Net where I need to bind a treeview with all the SSIS packages stored in SQL server MSDB database.

Is it possible to get all the SSIS packages by using T-SQL query or Object model ?

Thanks

Reference assembly Microsoft.SqlServer.ManagedDts.dll and create Application object (in Microsoft.SqlServer.Dts.Runtime namespace). To get list of packages use Application.GetPackageInfos method:

http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.application.getpackageinfos(SQL.90).aspx|||

Alternatively the following query returns the list of stored packages from MSDB database:

SELECT * FROM msdb.dbo.sysdtspackages90

Thanks,
Loonysan