“SET NOCOUNT ON” vs “SET NOCOUNT OFF”

Let’s try this out. First, open your SQL Query Analyzer. Then, run these three lines of code. (I assume your SQL Server 2000 has default Pubs database). Use Pubs SET NOCOUNT ON SELECT au_lname FROM authors Then, change from SET NOCOUNT ON to SET NOCOUNT OFF and run them. Use Pubs SET NOCOUNT OFF SELECT Read more about “SET NOCOUNT ON” vs “SET NOCOUNT OFF”[…]

Execute a stored procedure from another stored procedure

You can execute a stored procedure from another stored procedure. This means that you can create a common stored procedure so that any stored procedure which needs this common stored procedure can execute it. Example, you have these three stored procedures. One is a common one. The other two are normal one. sp_update sp_delete sp_common Read more about Execute a stored procedure from another stored procedure[…]

The service did not start due to a logon failure

When I go to SQL Server Enterprise Manager to create a New SQL Server Registration for localhost, I got an error message saying “The service did not start due to a logon failure“. So, I copy this error message and google it. And quickly I found the solution. The problem is I have changed my Read more about The service did not start due to a logon failure[…]

Some difficulties of learning ASP.NET

Difficulties 1: Tools Say, in your company, you are using Visual Studio 2003 and in order to improve your skill, you want to put give more time to learn it at home. But, the problem is you do not have Visual Studio 2003 at home. You went to check and realize that there is one Read more about Some difficulties of learning ASP.NET[…]

Server Application Error

Don’t know why suddenly when I run an ASP file from my local IIS, I got an error message saying Server Application Error The server has encountered an error while loading an application during the processing of your request. Please refer to the event log for more detail information. Please contact the server administrator for Read more about Server Application Error[…]