Just for information, the RPC service is running on these servers

R

could you be more specific as to what i am looking for?

Why would would the openquery work in that circumstance?

Having read sellertools response, I would concur.

The reason I am sweeping the directory is that we perform other tasks at os level as well

The check sellertools is using will mean...

Hi there....recently had our MI guys ask me for such functions too.

As we needed to know first of month, last of month, last working day etc, have a number of...

hi there

I think it would be quicker to use

where left(course_id,3)='ISM'

as this is a more exact match.  Wildcards tend to slow things down

Ross

Hi

you need the following

sp_addlogin 

@loginame = 'login' ,

@passwd = 'password' ,

@defdb = 'database', 

@deflanguage = 'language'

you then need to grant access to databases:

change to database and

exec sp_grantdbaccess 'login'  

to add user to a role

exec sp_addrolemember 'dbo','login'

Ross

hi

the error is caused by the fact that you are select column 3, but are not grouping by it.

all non-aggregate columns must be included in the group by clause.

simply changing...

Hi David

when you say if you rely on transaction logs, what do you mean?

I have, like you, set it in dev.  Our live environment uses FULL recovery.  We do 30min...

hi

Does the server you are connecting to have a named instance? If so you will need to specify this.

As a default, sqlsserver will try to connect to a default unnamed...

Hi.

Its hard to say without seeing your example: maybe type it?

DTS allows scripting using ActiveX, so for instance if you have a text field MM/YYYY you can easily extract the...

Almost definetly a permissions problem

I suspect you are logged in with full rights, but these are not available to your account that runs SQL Agent as Andrew says

Right click on...

ok yuvraj, i suspect that is your problem

If you setup your package to work from your local machine, it runs from that machine.

I suspect that if you can get onto...

Yuvraj

I may have got a little confused here....

If you are able to execute successfully through DTS Designer, but are using a local version of Enterprise Manager to do it, it is...

This depends on how the file gets there

If you are loading via ftp/asp for instance, your asp page can check for a correct load and then execute a corresponding DTS...

Hi Yuvraj

Can you confirm that you have built the package in DTS Designer and successfully executed if from there and that the problem only occurs when you run it through...