Use YourDatabase SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID WHERE c.name LIKE '%MyColumn%' ORDER BY schema_name, table_name;
SQL SERVER – Unable to Attach Database – File Activation Failure – The Log Cannot be Rebuilt Error: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) Could not open new database 'MyLostDB'. ...
- Disable all table constraints ALTER TABLE YourTableName NOCHECK CONSTRAINT ALL -- Enable all table constraints ALTER TABLE YourTableName CHECK CONSTRAINT ALL -- ---------- -- Disable single constraint ALTER TABLE YourTableName NOCHECK ...
When the sub branch code is not selected while entering Proposal, this error gives So enter the sub branch code. Sub Branch codes can be added through Branch Menu
Use YourDatabase SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID WHERE c.name LIKE '%MyColumn%' ORDER BY schema_name, table_name;
Steps 1.Right click on My computer 2.Properties>>hardware>>device manager>> ports>> disable lpt1 3.start>> settings>>printers &faxes 4.right click>> add printer 5.select local>>next 6.create a new point>>next 7.enter a port name(path e.g ...