Need some help with Stored Procedure -- sql server new users

sql server new users : Need some help with Stored Procedure

Thanas
7/6/2006 10:40:40 AM

Hi I am pretty new to SQL Server 2005 and I have already learn so much.
I had a quick question. Where is the "Assisted Editor" for stored
Procedures. I can edit them on my own but there are other on my team
who have never even hear of stored procedures and it would be helpful
to them. If you don't know what I am talking about, below is a link
describing it. I thought it looked intersting. Did they do away with
it?

http://msdn.microsoft.com/sql/learning/prog/tsql/default.aspx?pull=/library/en-us/dnsql90/html/tsqlqueries.asp

Any help would greatly appreciated.

-Thanas

Arnie Rowland
7/6/2006 11:48:22 AM

In that article, in reference to 'Assisted Editors':

Object Explorer also lets you directly and interactively edit Transact-SQL
code using a new tool called the Assisted Editor. When you drill down into
the Programmability node in Object Explorer and right click over one of the
Programmability nodes, the New and Modify options on the resulting popup
menu invoke an appropriate Assisted Editor. Assisted Editors are available
for stored procedures, functions, triggers, and views.

SQL Server Management Studio is required on the desktop of the user.

--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."

[quoted text, click to view]

Arnie Rowland
7/6/2006 12:26:45 PM

Oh yeah, right. Forgot about that.

--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."

[quoted text, click to view]

Sue Hoegemeier
7/6/2006 12:55:55 PM

It was dropped from the product during the beta.

-Sue

On 6 Jul 2006 10:40:40 -0700, "Thanas"
[quoted text, click to view]

Gail Erickson [MS]
7/7/2006 8:14:13 AM

Hi Thanas,
You might want to point the others on your team to the Books Online topic
"How to: Create a Stored Procedure (SQL Server Management Studio)." This
topic provides step-by-step instructions for creating a stored procedure
using Object Explorer in SQL Server Management Studio. The topic was added
to Books Online in December, so make sure they have the latest version of
Books Online. The download the updated Books Online is
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Regards,
Gail
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
'
[quoted text, click to view]

Thanas
7/7/2006 9:21:31 AM

Thanks Gail. I have it already. Got it yesterday. I'll share it with
rest of my team.

-Thanks again everyone.
-Thanas

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

home · blog · groups

Questions? Comments? Contact the dn