Thanks Michael, it works fine, however I'm puzzled why my code didn't and I think the problem may lay in this:
In your connection string, it is like this: Server=(local) and in mine it was Server=localhost, maybe this was the problem, also what is this: Create Database [{0}] whats the funny 0 doing there?
I gave this user permissions to create databases, as it stands this user is also a dba, I will remove priviledges untill the user can only create databases and do all the normal operations with it. I don't think the user need access to the master database, but will try removing it, if he does this could be a problem as users could then access this crutial database just to create another database.
Thanks guys.
Topic Options
Post Options
Thanks(0)
