can you instantiate a com object by using t-sql? : Sql server database administration



can you instantiate a com object by using t-sql? : Sql server database administration..

Answer / Indresh Kumar

No, T-SQL (Transact-SQL) is the query language for Microsoft SQL Server and it does not support creating COM objects. To interact with other components or automation, use stored procedures or CLR Integration.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1 Answers  


What are pessimistic lock and optimistic lock?

1 Answers  


what is the disadvantage of SQL Loder?

1 Answers   TCS,


Do you know what are the restrictions that views have to follow?

1 Answers  


How to convert binary strings into integers in ms sql server?

1 Answers  


What are the steps need to be take improve the speed of a SQLDATA Server?

2 Answers   IBM,


What are various aggregate functions that are available?

1 Answers  


Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,


How sql server enhances scalability of the database system?

1 Answers  


What is xml datatype?

1 Answers  


How to view existing indexes on an given table using sys.indexes?

1 Answers  


Explain mixed authentication mode of sql server?

1 Answers  


Categories