The only thing that is "better" than the "Internally Documented Errors" is "This Feature is By Design" (Microsoft) and "Type of Defect: Defect-Customer" (Third-Party Vendor)

Don't let me go into examples....

Look, you may re-create a step when connecting as a user #3 and then use profiler to see who is trying to connect when you are excuting a step. Could...

It may happen if your step is trying to connect as a different user. Or all other steps use a qualified name like dbo.mytable and this step says "mytable". When...

Agree with all.

Moreover, coded names give a lot of room for the errors when you need to assure you are dealing with the correct database.

What I would not recommend at...

Alexey,

You English is OK. I say myself that my SQL is better than my English.

No, I did not add anything. There was no macros too. I also received a confirmation from...

THIS IS NOT CORRECT!!!!

"AUTO_CLOSE

When set to ON, the database is closed and shut down cleanly when the last user of the database exits

If the database was shut down...

It could be a lot of reasons!

Most probably something happened (not by itself) on the network: either an additonal firewalll rule was installed, protocol disabled, port changed etc. i also...

Now we can see that the error was posted by SQLClient Data Provider when trying to return results by DataReader which is basically read-only forward-only recordset as talking about it...

Go to here

https://www.microsoftelearning.com/sqlserver2005/default.aspx

and see what FREE courses are available. I think they will be free until November.

Also go here:

http://www.transcender.com/default.aspx

and get a pack or an individual exam preparation test...

Please post the whole error message here including who was posting the error: SQL Server, ODBC, your application etc.

It is not possible to find out why the timeout expired without...

Hi Terry,

I had to spend time finding it myself when I needed it.

I created a package using Maintenance Plan. Then I opened Visual Studio using either Visual Studio 2005 start menu...

I don't think we are loading assemblies into application domains.

We are creating assemblies with Create Assembly statement in a certain database and this action may be described as loading .NET...

I use WMI scripts for everything except for the disk drive space which I would like to implement next, just need an extra hour.

You most certainly can create a step...

Client Network Utility is a tool to specify connection properties for an alias (specific name). This connection properties includes the protocol for the first place, server name / IP, port...

I opened the package with Visual Studio 2005 that was installed for some types of the projects when SQL Server was installed.

Then I discovered that actually both shortcuts in the...