Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dani_M
Starting Member
7 Posts |
 Posted - 2011-01-13 : 07:09:36
|
| Please help me with this.We updated from SQL Server 2000 to SQL Server 2005.In SQL Server 2000, when I had to write a SP, I double click on the SPIn SQL Server 2005, in the right click menu, I have just modify.I tried to go in modify, copy the code from there, and write Create instead of Alter but then the SP doesn’t appear in Summary; when I do that again, it says that the object exists! I am lost.Is it a simplier and a better way to write new SP? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-01-13 : 07:14:56
|
Click on the node where the SP's are listed in object explorer to mark it and then hit F5 key to refresh.Now your created SP is visible...
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-01-13 : 07:15:05
|
You have to refresh the object explorer before it will appear after creating it. After you run the Create script, click in the object explorer and hit F5 and hit F5 to refresh the list.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-01-13 : 07:20:35
|
| you can see the details of how to create a stored procedure on: http://msdn.microsoft.com/en-us/library/ms187926.aspxIn SQL Server 2005, in the right click menu, I have just modify.I tried to go in modify, copy the code from there, and write Create instead of Alter but then the SP doesn’t appear in Summary; when I do that again, it says that the object exists! I am lost. Just Refresh the parent node of that object in the Summary Window (explorer), and you will find it once you refresh. |
|
|
|
Dani_M
Starting Member
7 Posts |
Posted - 2011-01-13 : 07:56:02
|
| I didn't think that I have to refresh. Thank you all! |
|
|
|
|
|
|
|
|
updated from SQL Server 2000 to SQL Server 2005