You can script all of those by right-clicking on them in Object Explorer of SSMS and selecting "Script as". If you want to script out multiple objects of the...

srawant,

You should be able to script out an application role by querying sys.database_principals, though I haven't had the need to do it.

After going through this pain ourselves we've found the most straightforward way to unlock an account is to run this TSQL as sysadmin:

ALTER LOGIN TestLogin WITH...

There isn't any query history function in Query Analyzer.

Here's a script you could try. I don't remember where I got it or I would credit the original author.

DECLARE @DatabaseUserName [sysname]

SET @DatabaseUserName = 'user_name_goes_here'

SET NOCOUNT ON

DECLARE

@errStatement [varchar](8000),

@msgStatement [varchar](8000),

@DatabaseUserID...

Have you seen this "Best Practices" doc from MS? http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SQL2005SecBestPract.doc

http://www.sqlsecurity is a good site for specific questions and tips: http://www.sqlsecurity.com/

This Kb article lists the steps and options for moving databases: http://support.microsoft.com/kb/314546/en-us

I've most often used the backup/restore method, but I've also used detach/attach. Which one you use...

It would be easier to offer advice if you post what happened when you executed sp_addrolmember. I'm going to guess you got an message that said something like, "User...

Use sp_help_revlogin from MS to transfer logins. I've used this script to script out database users and permissions http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31959/.

Usually though, when I'm copying a database from one instance to...

We've done it both ways where I work. Initially, our data management group, which does data analysis and database management, was part of the infrastructure team along with network...

Permissions for all users in a database:

select U.name, O.name, permission_name from sys.database_permissions

join sys.sysusers U on grantee_principal_id = uid

join sys.sysobjects O on major_id = id

order by U.name

Permissions...

The two errors that I'm able to interpret are:

Error: 2008-10-07 08:32:00.23

Code: 0xC0016016

Source:

Description: Failed to decrypt protected XML node "DTSassword" with...

Okay, sorry. The EXECUTE permission pertains to being able to execute stored procedures.

I don't write a lot of stored procedures myself as that's done mostly by the...

You didn't specify the SSIS package that you want to execute. The /F parameter of dtexec is for specifying the location of the package, not the file you want...

So, you must have figured out how to create a stored procedure. The procedure and the tables is accesses must have the same owner. In our shop, all...