Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Wednesday, October 30, 2013 6:35 PM
I am trying to install the sample Northwind Database from the file Northwind.sql. When I run the script on SQL Server Express Management Studio I get an error message that says:
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'U'.
I have searched the net but cannot find an easy to follow means of resolving it. Any ideas, please? I am using Windows 8/SQL Server 2012 Express.
Only performance counts!
Wednesday, October 30, 2013 10:44 PM ✅Answered | 1 vote
SOLVED!
1. I Created a Database with the name Northwind (CREATE Database Northwind)
2. Opened the northwind.sql in Notepad
3. Copied it unto the SQL Server Management Studio
4. Executed the query (ie 3 above)
5. And that's it...
I hope that other users will find this entry useful. I have searched/spent over 6 hours trying to figure this out.
Only performance counts!
Wednesday, October 30, 2013 9:06 PM | 1 vote
I am trying to install the sample Northwind Database from the file Northwind.sql. When I run the script on SQL Server Express Management Studio I get an error message that says:
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'U'.I have searched the net but cannot find an easy to follow means of resolving it. Any ideas, please? I am using Windows 8/SQL Server 2012 Express.
Only performance counts!
It looks like there is an extra character somewhere in your script. I would suggest posting the script you are using to do this so that I can give you a more direct answer.
Wednesday, October 30, 2013 9:09 PM
Northwind is no longer supported. Adventureworks is the current sample database. I would highly suggest you use it instead.
Please see:
http://msftdbprodsamples.codeplex.com/
Wednesday, October 30, 2013 9:34 PM
All attempts to paste the script have failed. Each time I try to paste it all I see is only "U"!
In its place, there is a clue at the end of this page (but I don't understand it): Codeplex Northwind Database Home
**"**I had to reduce the rating because of the following: When you bring up the code in SSMS, the code is not color coded and there is some problem with the script (background text). When you run it will say there is no stored procedure 'U'. What I really did was to copy this into NotePad and save it with a different name. I called up the saved file in SSMS. Now it works. In SQL Server 2012 another ..."
Only performance counts!
Wednesday, October 30, 2013 9:37 PM
Maybe, but I still need it because most tutorials/books use it.
Only performance counts!
Wednesday, October 30, 2013 11:04 PM | 1 vote
SOLVED!
1. I Created a Database with the name Northwind (CREATE Database Northwind)
2. Opened the northwind.sql in Notepad
3. Copied it unto the SQL Server Management Studio
4. Executed the query (ie 3 above)
5. And that's it...
I hope that other users will find this entry useful. I have searched/spent over 6 hours trying to figure this out.
Only performance counts!
I am still curious why you are getting a U when trying to paste. Can you post up a link to the script?