Posted by Erland Sommarskog on 09/20/07 21:40

alvinstraight38@hotmail.com (alvinstraight38@hotmail.com) writes:
> Ahh, I see now why I was lost. I right click on the SP, and there is
> no option for Properties. Yet, I can set permissions on tables. How
> stupid. You mention SP2. How can I tell which service pack I am
> running? I went to Help - About and it shows:
>
> Microsoft SQL Server Management Studio Express Version 9.00.2047.00

That's SP1.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Delete or detach a Suspect database
• Prev in forum: Re: Select statement help
• Thread view: Re: How Do I give EXECUTE Permissions on Stored Procedures?

[Reply to this message]