adspace


How do you create a data source?

Answer Posted / Ashish Srivastava

To create a data source in SQL Server, you can use the 'CREATE DATABASE' command or 'CREATE SYNONYM' based on whether it is a database or synonym.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can one drop a column from a table?

1089


Why we use the openxml clause?

1079


How to connect php with different port numbers?

1189


What is acid mean in sql server?

1245


What is sql server query analyzer?

1128


What are the properties of the transaction?

1073


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2295


How can you append an identity column to a temporary table?

1070


How to provide default values to function parameters?

1258


What is clustered index

1086


What are the kinds of subquery?

1107


What is subquery? Explain the properties of a subquery?

1059


Why should you use or avoid select * statements?

1109


explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1133


List out the different types of locks available in sql server?

1050