Cannot perform bulk insert. Invalid collation name for source column 1 in format file ‘C:bcp.fmt’.

It took me a while to finally figured what what went wrong to fix the above error. The problem is my bcp.fmt needs to have an empty line at the last row. The first screen capture is the one before I added the empty line and the second screen capture is the one after I Read more about Cannot perform bulk insert. Invalid collation name for source column 1 in format file ‘C:bcp.fmt’.[…]

“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[…]