September 16, 2013 at 2:43 pm
In the SQL command what is the correct syntax for creating a schema....
I have tried both double and single quotes in the authorization owner_name but continually getting message saying user does not exist
September 16, 2013 at 2:46 pm
todd.ayers (9/16/2013)
In the SQL command what is the correct syntax for creating a schema....I have tried both double and single quotes in the authorization owner_name but continually getting message saying user does not exist
Apostrophes are the proper quoting operator in SQL.
If it's saying that the "user does not exist" rather than a syntax error, then its probably either spelling, or you're in the wrong database/server.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 16, 2013 at 3:02 pm
If I am the Database owner.... wouldn't creating the schema with an authorization of db_owner get the same result?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply