Thanks for advise, I did not know about this function.

So it sound like I have to create a job which on periodical basis will call this function and load trace...

Thanks a lot Robert.

This is great solution. I did not run it yet, I am not very proficient in Powershell, I will let you know about results.

It executes in average 5-7 sec when is success, and up to 40 sec for failure. That's right that something is related to data, but I need to troubleshoot it...

It works fine in 99% of all ecxecutions. And there is no any pattern for failure timings, it looks completely random.

The package is rather complex. It populates two dim tables...

Thank all for replies. Sorry for delay, I was busy all day today.

MyDoggieJessie:

The database size is 36 GB including log.

Totally 16 tables, only 10 of them have PKs, and...

Thanks for quick replies.

Alan: I cannot create a real table, because this db will be restored, and the table will be gone. About SSIS, frankly I am not so...

Meanwhile, I created dynamic script to run EXEC sp_removedbreplication from all databasses on my server and ran it.

However,

EXEC sp_dropdistributor;

still generates error:

Msg 14121, Level 16, State 1, Procedure sp_dropdistributor, Line...

I ran both

USE [Database]; EXEC sp_removedbreplication 'Database'

GO

USE [Database1]; EXEC sp_removedbreplication 'Database1'

GO

But when I run EXEC sp_dropdistributor, I get the following error:

Msg 14121, Level 16, State 1, Procedure sp_dropdistributor, Line 211

Could...

Thanks, XML config file looks like good idea, I did not start reading the links provided, but first question that I have is : When a XML config file is...

Thanks, I figured it out. I had both (local) and server name before /instance name. Now I cleared .

Thank you all.

All 7 services are running:

1. Browser

2. SQL Srever instance

3. Agent

4. Full-text

5. SSAS

6. SSIS

7. SSRS

I also checkd client configuration:

1. Shared mmory

2. TCP/IP

3. Named Pipes

Should I check anything else ?

Yes, I know this. But my question is this: for example we have 100 partitions and we need to rebuild index only on 10 of them. We issue ALTER INDEX...

Here is an interesting aricle about why VB is better that C#:

http://www.simple-talk.com/dotnet/.net-framework/10-reasons-why-visual-basic-is-better-than-c/?utm_source=simpletalk&utm_medium=email-main&utm_content=vb10reasons-20120319&utm_campaign=.NET

If there is no technical difference between them, why C# is much more popular on the market, than VB ?

But can we restore a database in at least one connection is not closed ?