SQL Help on Users and Authentication page 149

seanmayhew · #1 (**permalink**) 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 · #2 (**permalink**) May 26th, 2004, 09:30 AM

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

USE PhileDB

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem with authentication users	hcusto	BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0	2	August 9th, 2006 02:32 PM
Authentication users	hcusto	ASP.NET 2.0 Basics	0	August 9th, 2006 04:44 AM
users and authentication	raja_699	BOOK: ASP.NET Website Programming Problem-Design-Solution	1	February 1st, 2005 07:04 PM
Users and Authentication p. 179	chiefg	BOOK: ASP.NET Website Programming Problem-Design-Solution	3	June 28th, 2004 01:19 PM