I'm new to SQL SMS and need help. I have been asked to check that .BAK files restored be checked using SELECT queries in SQL SMS. I have tried to create a new database but get the error "CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262)". It does not give much information so I can find out and Googling it didnt help either. Also if I drag and drop the .bak file into the SQL SMS window, I am told that there is no editor available??
Any help is greatly appreciated! Also, if you have any links to good tutorials, that would help too.