Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Opinions needed
Message
From
16/05/2003 13:45:22
 
 
To
15/05/2003 16:30:40
Keith Payne
Technical Marketing Solutions
Florida, United States
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Miscellaneous
Thread ID:
00788801
Message ID:
00789358
Views:
46
Hi Keith,

Thanks for the response.

Thanks for the suggestion about the prefix, actually we are doing this now for any objects that we create on the database, if not it would be a total mess.


"Not to mention inserts, updates & deletes, which would require some sort of quasi-referential integrity checks being performed on the client."

What do you mean by quasi-referential(hispanic here), you mean that you have to do your own referential integrity instead of using SQLS2000's Diagram? Well, we wouldn't include any tables from the accounting software in the diagram regardless if the custom database is in the accounting database or not. So if this is not an issue, then the only issue would be the query time and maybe transaction processing. Does joining one table to another table in another database (within the same server) take a big hit as compared if both were on the same database? How about transactions?


Thanks.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform