adspace


what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

Answer Posted / Krishna Gopal

Extended stored procedures are native system procedures that can call operating system functions or third-party applications. They provide a way to perform operations outside the scope of T-SQL. To instantiate a COM object in T-SQL, you would use OLE Automation (OLE DB provider for SQL Server or ADO).

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to remove duplicate rows from table except one?

1090


Does view occupy space?

1022


How to provide default values to function parameters?

1261


What are wait types?

1250


What is the primary use of the model database?

1151


How to convert character strings into numeric values?

1192


What is sql server query analyzer?

1131


What is a coalesce function?

1285


What are the kinds of subquery?

1109


How to rebuild the master database?

1167


What is a scheduled job or what is a scheduled task?

1040


What is the difference between upgrade and migration in sql server?

1185


what is spatial nonclustered index

1060


What is normalization and what are the advantages of it?

1057


What is in place upgrade in sql server?

1127