"Ilamparithi" <ilamparithi@msn.com> wrote in message
news:f5606ff9.0404140542.53a286ea@posting.google.com...
> Hi all,
>
> How to determine whether a user has the right to create a databse in
> MS SQL Server programatically.
>
> With Regards,
> A.Ilamparithi.

"Simon Hayes" <sql@hayes.ch> wrote in message news:<407d490a$1_3@news.bluewin.ch>...
> "Ilamparithi" <ilamparithi@msn.com> wrote in message
> news:f5606ff9.0404140542.53a286ea@posting.google.com...
> > Hi all,
> >
> > How to determine whether a user has the right to create a databse in
> > MS SQL Server programatically.
> >
> > With Regards,
> > A.Ilamparithi.
>
> See the PERMISSIONS() function in Books Online:
>
> IF SELECT PERMISSIONS() & 1 = 1
> PRINT 'Can create a database'
>
> Note that you must be in the master database for this to work.
>
> Simon