I am getting a syntax error in SQL 2005 with the command "Grant Select to user". I get "Incorrect syntax near the keyword 'to'". This worked in the previous version, and according to what I can find in the documentation, it should work in this version. I hope I don't have to specify each table individually. Anybody know any more about this
Grant Select
Hot Topic
- Synchronizing Very Large Database from PDA to SQL Server 2005.
- how to do "format with multiple columns" in reporting services.
- Upgrading SQL2000 active/active 2-node cluster to SQL 2005
- cube processing error - perhaps someone can explain
- A little MDX problem
- MSDE subscription expiration
- Edit Xml data in ntext Field
- Database locking issue
- missing notifications
- Cannot connect to sqlexpress from ssmse (ctp)
SQL Server
- Upgrading to Sept CTP - any BKM?
- management studio how to change where my projects resides
- Insert into select question
- 264] An attempt was made to send an email when no email session has been established
- Unable to use Books Online search function
- Linking Tables
- Export to excel from ReportViewer control
- Some kind of row versions in triggers?
- Still a problem with Report Refresh Icon
- AS2005 - Displaying time calculations in a Perspective
Grant Select
greycats