I am absolutely sure, I've tried and tested it already many times

I've lost my vpn connectione, so I cannot try it againg.

Monday, when I am at the office I will...

Hi,

this returns

SomeUserSQL_LOGIN0

Hi,

Remark: I am trying to make a linked server to the same sql server.

The sql server is the default instance, so if the server name is A, I am making...

Hi,

I forgot in the previous reply to mention the error from the errorlog

Login failed for user 'SomeUser'. Reason: Could not find a login matching the name provided

Thx for the feedback

Hi,

The remote user is a sql login which has then necessary rights on the database.

I can login with that user on the server and query the tables.

I use the...

Hi,

I have a default sql instance and 2 named instances on the server.

The PID's of the sqlserver.exe are 1672, 1644 and 1816.

The performance counter is Process, %processor time. (not Processor,...

Thx for the response but when I have a default Sql server MyServer and an extra sql instance Myserver\NamedInstance.

I get MSSQLSERVER and NamedInstance for @@servicename

So I am still missing the...

Hi,

The solution Jim mentioned a few posts before worked for me.

I disabled the data colledtion.

Then I Changed the cache directory and enabled the data collection again.

Hi,

I experienced the same problem.

A partial solution is to make a third dataset in which you retrieve all available values (for your selected group id)

And set the available values of...

Hi,

maybe you could use xp_delete_file, but this is undocumented.

Fe EXECUTE master.dbo.xp_delete_file 0,N'C:\Backup',N'BAK',N'2008-08-30T07:49:27',1

First param : 0= backupfiles, 1 = reportfiles

2nd param : Path

3 th param : extension of the files you...