Legal/illegal characters in table name

Question

Viewing 7 posts - 46 through 52 (of 52 total)

You must be logged in to reply to this topic. Login to reply

ram@digisource.co.in Old Hand Points: 360 More actions · Answer 1

This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

in this question have a schema in the database named "dbo" instead of" tmp" . The table is created with out errors

Carlo Romagnano SSC-Insane Points: 22783 More actions · Answer 2

SSC-Insane

Points: 22783

April 12, 2015 at 11:20 am

Try to answer this one:

Table Array[/url]

m mcdonald Hall of Fame Points: 3264 More actions · Answer 3

MyDoggieJessie (4/7/2015)
This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

+1

Guessed correctly that that important piece was omitted...

julienchappel 38298 SSC Eights! Points: 838 More actions · Answer 4

Executing your script in SQL 2008 R2 and SQL 2012 SSMS without the "tmp" schema is created I was getting the following message:

Msg 2760, Level 16, State 1, Line 1

The specified schema name "tmp" either does not exist or you do not have permission to use it.

So in the view is this "Sorry but you are wrong". your script returns error in two environments.http://www.sqlservercentral.com/Forums/Skins/Classic/Images/MessageIcons/ExclamationMark.gif

Bhushan Kulkarni SSCrazy Points: 2829 More actions · Answer 5

It gives error unless tmp schema is crated in the database

Arno Kwetters Hall of Fame Points: 3899 More actions · Answer 6

I did not expect that, but I will not use it that way either.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 7

Good to know. This doesn't seem very practical though.