Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 1 down vote favorite

I was planning to run "sdetable register" command to register a particular field as OID for an non-spatial table already created in a SDE database. I am with SQL Server 2008 R2.

I tried to run the command USE [{database}] GO sdetable -o register -t {table} -c {column} -C {database} -u {user} -p {password} from on a query window in SQL Server Management Studio.

But it logged "Incorrect syntax near 'o'." error.

Is there anything wrong with what I was doing? Any idea?

Thanks

Alex

share|improve this question

1 Answer

up vote 3 down vote accepted

That isn't a SQL Command, but a DOS/Command Line function you need to use to register the table. You need to launch a command prompt and use your command from after your 'GO' statement to register your table.

share|improve this answer
Thanks Mr Wright! – alextc Apr 12 '12 at 1:36
But just for curiosity: is there any sql command that can be run within SQL Server to register a table? – alextc Apr 12 '12 at 1:37
Im not aware of any single command from the TSQL syntax that could do this. As this process talks to several different tables and StoredProc; I doubt if you would want to attempt it manually. – D.E.Wright Apr 12 '12 at 15:25
thanks for your tips – alextc Apr 13 '12 at 5:22

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.