WayneS (6/4/2010)

---

I'm in a gov't organization where we have SA's and DBA's. Most of the DBAs are not comfortable with doing things on the servers themselves, because "the SAs have...

It's not obvious from that job step message what the problem is. Do you have any logging enabled in the package? If not, I suggest doing that and...

The first thing that comes to mind is to make sure you updated the configurations in the packages. It sounds like you're saving file paths in the configurations? ...

I totally agree with Shawn. We've never done an in-place upgrade because of the "no fall back option" issues. Side-by-side migration offers the ability to have the SQL...

select databaseproperty('databasename','issingleuser')

By default, jobs run as the SQL Agent service account. You would create a credential and proxy if you wanted to have the job started by an user account....

Wow, a lot of responses to this one! I have quite a few hobbies, none of which involve computers. While I enjoy the challenge of working with databases,...

I think the only way the user could own the schema is if someone actually made it the owner. Is this one of the databases that the login created?

To...

The login you see as domain\username is your connection to the instance you're viewing and isn't used in execution of the job.

Typically, a job is run under the...

This will create a new table and populate it with the result set of the select from source table. Put this...

Do you want a login other than the SQL Agent account or a member of sysadmin to execute the job? See SQL Server Agent Fixed Database Roles in BOL.

If you're using Enterprise Manager, expand server, Management, SQL Server Agent, right-click on Jobs, select All Tasks, select Generate SQL Script...

If you're using SQL Server Management Studio, expand server, SQL...

Need more information.

What login is the application using to connect to the databse?

What login are you using to connect via SSMS?

What are the database privileges of the logins...

Am I the only one who finds this a little odd that by version 2008 (R2) of SQL Server that there does not appear to be any default way of...

The only way I know is to have a DDL trigger enabled for CREATE_LOGIN.