December 21, 2003 at 8:24 pm
Howdy a couple of our tables when in design mode in enterprise manager does not show date/time columns? Yet the fields exist when you do a select *. Has anyone seen this type of problem before?
Thanks
December 22, 2003 at 5:55 am
- are you sure nobody changed the tablestructure when you were looking at it with EM ? (You will need to refresh the tables-tab) Refreshing at the correct position in EM is many times cousing confusions.
- what does EM generate when you want to script this table ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
December 22, 2003 at 6:29 pm
When I script out the table it does
all the fields except the ones that cannont be viewed in em?
Found a work around. Copied table to another server then copied it back. Table structure can now be viewed in em? Go figure.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply