The query will produce a GRANT statement for each stored procedure in the current database. You have to execute the GRANT statements in a query window to grant the...

There isn't a built in database role for EXECUTE permissions. You could script GRANT EXECUTE statements for each database and execute them. Something like this:

select 'GRANT EXECUTE ON...

Sorry, I don't have a T-SQL script for this because I've never needed to do it on an on going basis. I've only scripted jobs to as a one-time...

Database mirroring only mirrors user databases. The only way I can think of to copy jobs is to build and schedule a script that scripts them and runs the...

nymgk_75 (3/2/2009)

---

So always use the db_login for asp.net code....not the actual db_user. Got it.

Ahhh, makes sense. Have a 1:1 relationship for a db_user and a db_login. So...

First question is where is the package stored - in SQL Server or in the file system? If it's in SQL Server, you can take advantage of the SSIS...

I'll try to help. There is a Reporting Services group of forums pretty far down the list on the forums "Home" page (click "Forumns" in the list on the...

My suggestion is to enable logging in the package then examine the log. The log records are recorded in the order they're executed as the package runs.

Enable...

zombi (2/24/2009)

---

Thanks for ur sincere answer.

The question i asked is because MSDB database contains job information and master database contains other information. so if i migrate sql agent jobs...

I'm not sure I have the complete picture. Are the sources of the web databases data all SQL Server databases or some other kind of data store? Does...

Actually, MS does refer to side-by-side upgrade as "migration". Zombi, if you're really talking about installing a SQL 2005 intance and migrating databases to it with backup/restore or detach/attach,...

There's something in the script section of SSC that I've used to script out linked servers and recreate them on other servers: http://www.sqlservercentral.com/scripts/Miscellaneous/30620/.

That won't help him if he wants to to keep the packages as legacy DTS. I second George's advice. ...

You'll either have to

1. create an SSIS package that contains a Transfer SQL Server Objects task (not available in the Wizard)

or

2. Script the table CREATE statements...

matias.diaz (2/20/2009)

---

I'hope that this script helps you!

-----------------------------------------------------------

OPEN Lista

FETCH NEXT FROM Lista

Into @Type ,@Name , @Owner

WHILE @@FETCH_STATUS = 0

BEGIN

if (@Type ='P' or @Type ='F')

begin

exec('grant all privileges'...