If your goal is to execute a package in a SQL Agent job, you can use DTSRUN in a job step. You should find details in Books Online. ...

This script claims to be able to script out all packages in a SQL instance so they can be searched.

http://www.sqlservercentral.com/scripts/Miscellaneous/31613/

Were you connected as employeelogin or is emp owned by employeeloginuser? If either of those is true, the message makes sense.

Generally, you would create a login first, then create the user.

To create the user:

create user csvuser (see BOL for syntax)

The user won't have any permissions for the table by default,...

User mapping in the GUI attempts to create the user in the database you're trying to map to, thus the error you got.

Use sp_change_users_login to remap the existing database user...

You can grant the EXECUTE permission on each stored procedure that you want the user to be able to run. If you do that, the user won't need the...

The...

I've used a script in the past that I can't seem to find right now, however, a search of the script section here at SSC shows a couple of scripts...

ckingtaylor (1/20/2011)

---

Wow, that was too simple. I've been looking at this package for hours. What is the best method for sending the email from the step? CmdExe,...

Try this:

select distinct o.name, o.type_desc from sys.objects o

where OBJECT_DEFINITION(o.object_id) like '%col1%'

order by o.name

SQL Server logins are instance dependent. So, in your example, the login on ServerB wouldn't be affected by changes made on ServerA.

1. Yes, that's all you'd have to replace.

2. It's up to you. It's just two ways to achieve the same thing.

I'm not clear about whether you want to import the view itself or the data that is returned by the view.

Because the Import Wizard imports views as tables,...

OCTom (12/29/2010)

---

My workplace is for work and my home is not. Unless I get called at home to work on something, I do not work from home.

There needs to be...

You should be able to do that in Express.