sp_tableoption is used to turn on/off features on tables like turn on the text in row feature for datatype text, ntext, or image columns, pinning a table, table lock on bulk insert. Example: Enables the 'text in row' option on customers table inline limit to 1000 EXEC sp_tableoption 'customers', 'text in row', '1000' Using “OBJECTPROPERTY”…
Using the following SQL statement, it will list triggers on database. It also prints trigger name, table the trigger is on, is it a insert, update and delete triggering event, after and instead of trigger, if the trigger is enabled or disabled SELECT trigger_name = name , trigger_owner = USER_NAME(uid) , table_name = OBJECT_NAME(parent_obj) ,…
In Oracle there is CREATE TABLE…AS to backup table into a new table and the syntax on SQL Server is a bit different to copy table. So the syntax on SQL Server is SELECT * INTO newtable FROM sourcetable Additional documentation from Microsoft http://msdn.microsoft.com/en-us/library/ms190750.aspx
