SQL Help on Users and Authentication page 149

seanmayhew · May 26th, 2004, 09:14 AM

I have little experience with SQL Server as I have a MySQL background so pardon me if this is a newbie question but this query

Code:

CREATE TABLE[dbo].[Accounts.PermissionCategories]...
ON [PRIMARY]

Is creating the table in the "master" database and NOT in my Phile Database. Any help would be greatly apprecated

seanmayhew · May 26th, 2004, 09:30 AM

Nevermind I got it. Needed a "USE" statement.

USE PhileDB