Linked Server in SQL Server?
If your linked server allows it, then you can run sp_executesql remotely and by that means you can do absolutely anything on the linked server. Eg. Create a database: exec .master.sys.
Sp_execute_sql N'create database foo.
See: MSDN: Linking Servers You basically need to call the sp_addlinkedserver stored proc: sp_addlinkedserver @server= 'server' , @srvproduct= 'product_name' , @provider= 'provider_name' , @datasrc= 'data_source' , @location= 'location' , @provstr= 'provider_string' , @catalog= 'catalog' Something like: EXEC sp_addlinkedserver @server='S1_instance1', @srvproduct='', @provider='SQLNCLI', @datasrc='S1\instance1' For details, see the MSDN docs - it's really pretty good!
Configure a linked server to enable the SQL Server Database Engine to execute commands against OLE DB data sources outside of the instance of SQL Server. Typically linked servers are configured to enable the Database Engine to execute a Transact-SQL statement that includes tables in another instance of SQL Server, or another database product such as Oracle. Many types OLE DB data sources can be configured as linked servers, including Microsoft Access and Excel.
The ability to access data from outside of SQL Server. The ability to issue distributed queries, updates, commands, and transactions on heterogeneous data sources across the enterprise. The ability to address diverse data sources similarly.
You can configure a linked server by using SQL Server Management Studio or by using the sp_addlinkedserver (Transact-SQL) statement. OLE DB providers vary greatly in the type and number of parameters required. For example some providers require you to provide a security context for the connection using sp_addlinkedsrvlogin (Transact-SQL).
Some OLE DB providers allow SQL Server to update data on the OLE DB source. Others provide only read-only data access. For information about each OLE DB provider, consult documentation for that OLE DB provider.
Yes you can. Setup the LinkServer on the SQL Express then just pass your query in the four part name format server . Database .
Schema . Object example select * from LinkServer.mydatabase.dbo.Table.
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.
Related Questions
Linked server setup between SQL Server Express and SQL Server?
Linked Server In SQL Server Express?
How to specify MS Access workgroup file in Sql Server linked server?
Execute sybase stored procedure as linked server procedure sql server 2008?
How do I configure an Excel file as a Linked Server in SQL Server?
SQL SERVER 2008 R2: How to add a linked server using OLE DB Data Provider for Oracle?