juur questions

• How to automate script generation using SMO in SQL Server?
• Difference between stored procedures and extended stored procedures
• SQL Server data types equivalent to Oracle?
• How to use transactions (begin transaction, commit transaction)?
• SQL Server: sys.master_files vs. sys.database_files
• SQL Server: Why do use SMO?
• SQL Server: how to query when the last transaction log backup has been taken?
• SQL Server: Native client vs. ODBC?
• How to do database unit testing?
• SQL Server: should I use information_schema tables over sys tables?

juur answers