Monday, July 23, 2012

How to copy a table from remote server to another server?

exec sp_addlinkedserver '255.255.255.255,1433';
exec sp_addlinkedsrvlogin '255.255.255.255,1433'
    , 'FALSE', NULL, 'username', 'password';
select * into [newtablename] from [255.255.255.255,1433].[databaseName].[dbo].[tableName]

Validation In Razor

http://www.mikesdotnetting.com/Article/191/Validation-In-Razor-Web-Pages-2