Mar 06 '12 at 01:22 PM
The actual snippet is quite simple
sp_addrolemember 'db_datareader', 'youruser'
Mar 06 '12 at 01:42 PM
Mar 06 '12 at 01:52 PM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Mar 06 '12 at 01:22 PM
Seen: 1078 times
Last Updated: Mar 06 '12 at 03:13 PM
Scripting groups & permissions from SQL 2000 to SQL 2005
Setting up a linked server from SQL 2005 to SQL 2000 and keep getting timeout error
compatibility of publisher, subscriber and distributor
SQL Server 2008 R2 installation
Can you run Sql Server 2000 & SQL 2005 Express simultaneously on the same server without any issues?
Select query---Show table rows in columns
A severe error occurred on the current command. The results, if any, should be discarded.
SQL 2000/2005 on same server
Is it possible to simulate older versions of SQL Server without having them installed?
Is this normal for indexes from SQL 2000 to SQL 2005?