Re: Strange Recordset/Query Problem ... > display in SQL Server. ... table names for each field in the SELECT clause, ON clauses, and WHERE ... Also, SQL Server is not case sensitive, so you can save your eyes by using ... the IF statement executes the first condition as it should, ... (microsoft.public.inetserver.asp.general)
Re: Need help on how to organize users and objects ... Yes Oracle is a bit different than Sql Server, but I think you will get the ... It doesnt become part of any schema until you assign it. ... a new developer started to work. ... need the COMMON database which stores tables with generic data and generic ... (microsoft.public.sqlserver.security)
Re: 3 Simple Security SQL Statements ... In SQL 2005, when you create an object, you specify the schema that the ... Kalen Delaney, SQL Server MVP... Schema for a database role, that seems like the best setup. ... EXEC sp_addrolemember 'WebUsersRole', 'WebUser' ... (microsoft.public.sqlserver.security)
Re: Model Driven Architecture, bussiness rules in DB? ...authorization schema.... neither does SQL Server. ... For instance when you grant access to a table you should be able ... accessing applications? ... (comp.databases.ingres)
Re: SQL Server to .xsd ... > output an XSD from an entire database schema,... > "Val Mazur" wrote: ... >> Do you need to get schema of specific table in a SQL Server?... (microsoft.public.data.ado)
