Re: Stored Procedure Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Andrea,
On 2/19/2006 10:30 AM, Andrea Montanari wrote:
hi Charles,
Charles E Finkenbiner wrote:

Yes, that works great. Now for my next question. :) If I use a SQL
database tool to view/design my SQL databases will using the 'MS_'
format bite me? Should I use both forms of the property name? Or
will the 'MS_' form take care of both?



if you use, say, Enterprise Manager, then you're out of luck...
for instance, Access names the "description" "MS_Caption" where Enterprise Manager names it "MS_Description"...
the other properties are not directly available in EM as it is not a front-end for tasks like that, thus you do not have "input mask" or "cormat" at all, as these are Access specific..

Ok, thanks for the information. As of right now using Access to design my SQL databases is all I need, since the user interface is handled by ASP web pages.


Thanks for your help,

Charles
.

Relevant Pages

  • Re: SQL Enterprise Manager
    ... Installing SQL Enterprise Manager on workstation ... I need to create backups of SQL databases and was told I can do this from ... Windows XP Pro machine and run scheduled database backups. ...
    (microsoft.public.windows.server.sbs)
  • Connect to Client SQL
    ... We happily connect to a couple of SQL databases on ISP servers using our ... Enterprise Manager. ... We now have a client who wants us to connect to his ...
    (microsoft.public.sqlserver.security)