2

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?

3

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.

| improve this answer | |
  • 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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