Not all SQL-generated scripts are created equal (or correctly) for alternative schema-owned objects.
SQL Server Management Studio provides a wizard to generate script out of a database. Learn how to automate the process to generate and store the database script.
I too am having problems with VB6 SP6, not with SQL Server, just with VB6 in general. Seems to be a little more unstable than it usually is.I am only running MDAC 2.7 and not 2.8. So maybe it has something to do with VB SP6?I have searched numerous SQL Server websites and everything in […]
Hello. One possibility is to use a stored procedure for the more sensitive roles. A stored procedure can have more rights than the User executing it, and the stored procedure can be used to ensure appropriate use (assuming individual users can be identified, User A only can create tables on database A). Everett
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!