Hi, I have a requirement to restrict user to create objects (Table, Function, Sroted Procedure etc) to specified length. We are working on project which will be on both SQL Server and Oracle and there is restriction in Oracle that an object name cannot exceed length of 30 characters and same as Column names for a table. Please help me in this regard. Thanks.
IF you are using SQL Server 2008 then, Policy based management will be doing the job. If your sql server is 2005 or below then probably you may need to create Database Triggers or DDL Triggers to check the length of the Database objects name that the users are creating.