Showing posts with label workflow. Show all posts
Showing posts with label workflow. Show all posts

Friday, March 30, 2012

Problems with tables named 'User' and 'Workflow'

Downloaded an app that scripts a Sql Server db. It works well--except with
the two aforementioned tables. These show no INSERT statements. I know
there are problems with a table named 'User'. For example, one cannot SELEC
T
* FROM User. One must SELECT * FROM [User]. I guess something similar is
happening with 'Workflow'.
Q 1: Where do I find a list of the table names that will give me trouble?
Q 2: I do I generate INSERT scripts for these tables?
Thanks,
JerryRJerryR (JerryR@.discussions.microsoft.com) writes:
> Downloaded an app that scripts a Sql Server db. It works well--except
> with the two aforementioned tables. These show no INSERT statements. I
> know there are problems with a table named 'User'. For example, one
> cannot SELECT * FROM User. One must SELECT * FROM [User]. I guess
> something similar is happening with 'Workflow'.
> Q 1: Where do I find a list of the table names that will give me trouble?
Look in Books Online under "Reserved Keyword".
However, Workflow is not a keywords, so that one is funky.

> Q 2: I do I generate INSERT scripts for these tables?
Without knowing that app, it's quite difficult to tell. Maybe you should
ask the vendor/author of the app.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx