How to Create / Insert Table Data From Remote server in Sql Server 2005 to local server

OPENROWSET can be used to access remote data from OLE DB data sources only if the DisallowAdhocAccess registry option is explicitly set to 0. When this option is not set, the default behavior does not allow ad hoc access.

To set DisallowAdhocAccess :-

Execute below script:

EXEC sp_configure 'show advanced options', 1;
GO

RECONFIGURE;
GO

EXEC sp_configure 'Ad Hoc Distributed Queries', 1;
GO

RECONFIGURE;
GO

After that execute following statement

select * into Destination_table from

(SELECT a.*

FROM OPENROWSET('SQLOLEDB','SERVER';'USER';'PASSWORD',

'SELECT * FROM Database.dbo.SourceTableName') AS a ) a

first it will create Destination_table in our local server , and after it will copy all data from Remote server database "Database.dbo.SourceTableName" into Destination_table.

How to select number of rows from table in sql server

Hello

Here are two ways to select number of rows when count is passed in parameter

1. using TOP

declare @count int

set @count = 5

select top(@count) * from temp_Users


2. using ROWCOUNT


declare @count int

set @count = 5

set rowcount @count

select * from temp_Users


Please comment more ways of performing this functionality.

set rowcount 0

Silverlight Tutorials, Silverlight Videos, Silverlight Articles, Silverlight Blog, Silverlight Example and Application

Good Website consist of plenty of links for Silverlight Introductions and Overviews :

It consist of Silverlight Introduction Resource, such how to get started with.

Silverlight Sites - It consist of Silverlight Site from microsoft.
Silverlight Blogs - It consist of blog post on silverlight from well known authors.
Silverlight Articles - It consist of various articles on silverlight
Silverlight Videos - It consist of Silverlight Videos.
Silverlight Applications - It consist of Silverlight Examples and Demo Applications.
Silverlight Downloads - It consist of different Silverlight Version to download.
Silverlight Resources - And more on Silverlight Resource.

Logon to get Silverlight Resource and Information

I found this interesting post on http://dotnetguts.blogspot.com/

I feel that i must share this with you.

About the School of the future

Hello

I found something very interesting effort by microsoft.

Yes its the school of the future which is being raising by Microsoft with the help of local authorities.

to know more visit

http://www.microsoft.com/Education/SchoolofFutureDocumentary.mspx

Enjoy!

Silverlight Tutorials

Hello

Good Website for Silverlight Tutorials

• Silverlight with Java Script Tutorial
• Silverlight Examples and samples

http://www.wynapse.com/Silverlight_Tutorials.aspx

Enjoy!

Show JavaScript Message While Closing IE Without Saving

Hello Friends

Following is the script to show message while navigating away from the current screen in browser.

var blnConfirmNavigation=true;
window.onbeforeunload = function (evt)
{

blnDeleteForum=false;
if(blnConfirmNavigation)
{
var message = 'You have not save the content of the page. Your changes will not be saved.';
if (typeof evt == 'undefined')
{
evt = window.event;
}
if (evt)
{
evt.returnValue = message;
}
blnDeleteForum=true;
return message;
}
}

Enjoy!

.NET Framework 3.0 Versioning and Deployment Q&A

Hello Friends,

I have found some Q&A related to .net framework 3.0 Versioning and deployment.

You can find answers to some questions like

• What is the .NET Framework 3.0 (formerly WinFX)?
• What happens to the WinFX technologies?
• How does the .NET Framework 3.0 relate to the .NET Framework 2.0?
• Will the name change be reflected in any of the existing .NET Framework 2.0 APIs, assemblies, or namespaces?
• How does "Side by Side" work for the .NET Framework 3.0?

You can find answers to these and many other questions on following link.

http://msdn2.microsoft.com/en-us/netframework/aa663314.aspx

Hope this will help

Enjoy!