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 |
|
vicki
Posting Yak Master
117 Posts |
 Posted - 2002-08-23 : 13:18:51
|
| HAS_DBACCESS ( 'database_name' ) is sysntax from BOL to Returns information about whether the user has access to the specified database. I try to run this query HAS_DBACCESS ('Physician') but I got the error:Incorrect syntax near 'Physician' Is any one know why?ThanksEdit : Moved to proper forumEdited by - merkin on 08/23/2002 23:04:08 |
|
|
joshb
Yak Posting Veteran
52 Posts |
Posted - 2002-08-23 : 13:33:41
|
| Did you use it in a select?SELECT HAS_DBACCESS('Northwind') |
 |
|
|
|
|
|
Database Access