Linked server is Equivalent to Database link
in Oracle database.
It is
easy to create linked Server in SQL Server 2012 to any version till SQL Server
2008 using SQL Server management studio.
Challenges
are encountered while creating linked server for a DB from SQL2012 to SQL2000
While
creating a Linked Server, it throws following error reason being that SQL
Server 2012 does not support Native Client 11 to connect to SQL 2000.
Resolution
Steps:
- Downloaded and installed the SQL Native Client 10.
- Install the SQL Native client 10 and create Linked
Server as below.
EXEC
sp_addlinkedserver @server = N'TESTLNSVR',
@srvproduct=N'MSSQL',
@provider=N'SQLNCLI10',
@provstr=N'PROVIDER=SQLOLEDB;SERVER=xx.xx.xx.xx'
- This will create the link server but while accessing it could throw error as:
To
rectify the above error , following steps should be followed:
Define ODBC data source using SQL native client
10 in ODBC tool in Windows server.
Once the ODBC
Data source is completed ,perform the connectivity test and it should be
successful.
1)
Now
create the linked server using script.
EXEC
sp_addlinkedserver @server = N'TESTLNK_SVR',
@srvproduct=N'',
@provider=N'MSDASQL',
@provstr=N'DRIVER={SQL
Server};SERVER=xx.xx.xx.xx;UID=test;PWD=Test123;',
@catalog=N'DBNAME'
Server:
TESTLNK_SVR
is the link server name through which DB on target server is accessed.
Provider: MSDASQL is an OLEDB provider that connects to
ODBC, instead of a database.
Provider string: SQL Server Is the
OLE DB provider-specific connection string that identifies a unique data source.
Server in Provstr: Server name
where the SQL Server 2000 instance is setup
Catalog: DBName is the
database name that we are trying to access in target SQL Server instance.
Once the Linked Server is created, it can be accessed using
below SQL.
SELECT * FROM
OPENQUERY(TESTLNK_SVR,’SELECT * FROM TABLE’)
Author:
Mohammed Fazulullah
Kovaion Consulting-PeopleSoft Practice
The blog gave me idea to create linked server Thanks for sharing it
ReplyDeleteDot Net Training in Chennai
Very nice articles,thanks for sharing
ReplyDeletetamil actres latest cute
Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your.
ReplyDeleteDigital Marketing Company in India
seo Company in India
Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care and we take your comments to heart.As always, we appreciate your confidence and trust in us.
ReplyDeleteHome Cleaning Services Mumbai
You post explain everything in detail and it was very interesting to read. Thank you. nata coaching centres in chennai
ReplyDeleteVery Nice Blog I like the way you explained these things. I’ve been looking for ways to improve my website and overall rankings.I hope your future article will help me further.Take SEO Training in Chennai to mould yourself.
ReplyDeleteThis blog is having the general information. Got a creative work and this is very different one.We have to develop our creativity mind.This blog helps for this. Thank you for this blog. This is very interesting and useful.
ReplyDeletePest Control in Chennai
Really incredible and interesting article. Keep the good work. I really appreciate your effort on putting such thoughts in the post. Thanks for sharing with us. Latest php jobs in hyderabad
ReplyDeleteGood information, thanks for sharing your valuable information.
ReplyDeleteDot Net Training in chennai | Dot Net Training institute in velachery
Good one, very informative.. thanks for sharing your views and ideas.. it is very useful to me.. thanks once again
ReplyDeleteSoftware Testing Training in chennai
Really Good blog post.provided a helpful information.I hope that you will post more updates like this.
ReplyDeleteDigital marketing company in Chennai
Very nice articles,thanks for sharing
ReplyDeletePHP Training Institute in Chennai
Very nice articles,thanks for sharing...
ReplyDeleteAndroid Training Institute in Chennai
I have attended the PHP course. Course content is excellent. I would recommend this course anyone wants to make career in PHP. Instructor describes you course in detail. All Presentations are very good. The Course Material is truly great,and good thing is that you will get Real time Project Explanation with Case Studies.Thank you ASTERHR IT SOLUTION PHP training in chennai
ReplyDeleteThanks for your marvelous posting! It is very useful and good. Come on. I want to introduce the best aso services for you, I try it and I feel it is so good to rank app to top in app store search results, have you ever heard it?
ReplyDeleteGreat posting with useful topics.Thank you.
ReplyDeletePHP Online Training
Pega Online Training
Oracle Soa Online Training
This comment has been removed by the author.
ReplyDeleteGreat posting with useful topics.Thank you.
ReplyDeleteAbinitio Online Training
Hadoop Online Training
Cognos Online Training
What a really awesome post this is. Truly, one of the best posts I've ever witnessed to see in my whole life. Wow, just keep it up. wordpress
ReplyDeleteشركة نفخ المجاري بالقصيم
ReplyDeleteشركة مكافحة النمل الابيض بالقصيم
شركة مكافحة حشرات بالجبيل
There are three popular approaches to server virtualization: the virtual machine model, the paravirtual machine model, and virtualization at the operating system (OS) layer.
ReplyDeleteminecraft server hosting
Great Article
ReplyDeleteFInal Year Project Centers in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai
Excellent blog I visit this blog it's really awesome. The important thing is that in this blog content written clearly and understandable. The content of information is very informative.
ReplyDeleteOracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad
Very interesting blog Really excellent information and thank you for giving your valuable information
ReplyDeleteOracle Fusion HCM Online Training
Thank you for sharing such a nice and interesting blog.
ReplyDeleteOracle Fusion Financials Online Training
I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.
ReplyDeleteOracle Fusion SCM Online Training
Thank you much more for sharing the wonderful post. Keep updating here...
ReplyDeleteExcel Training in Chennai
Excel Advanced course
Pega Training in Chennai
Linux Training in Chennai
Graphic Design Courses in Chennai
Tableau Training in Chennai
Unix Training in Chennai
Oracle Training in Chennai
Soft Skills Training in Chennai
JMeter Training in Chennai
Excel Training in OMR
Божественно познавательныеда еще удивительно точнейшие интернет гадания для уточнении загадывания вашего ближайшего будущего: это именно то, с чем вы познакомитесь на сайте гаданий. Онлайн гадания бесплатно на картах, на ближайшее оказывается наиболее доступным и легким способом для получения нужных знаний из эмпирического поля земли.
ReplyDeleteHi buddies, it is great written piece entirely defined, continue the good work constantly.
ReplyDeleteData Science Course
It is extremely nice to see the greatest details presented in an easy and understanding manner.
ReplyDeleteData Science Training
I couldn't leave your website until I told you that I really appreciated the high quality information it presents to your visitors. I will come back frequently to check for new posts.
ReplyDelete360DigiTMG Data Science Courses
Hello! I just want to give a big thank you for the great information you have here in this post. I will probably come back to your blog soon for more information!
ReplyDelete360DigiTMG Data Science Certification
I will be interested in more similar topics. I see you have some really very useful topics, I will always check your blog thank you.
ReplyDelete360DigiTMG Artificial Intelligence Course in Bangalore
Hmm ... it's good to be here on your article or post, whatever, I think I should also work hard for my own website as I see some good and updated on your site.
ReplyDelete360DigiTMG Business Analytics Course in Bangalore
The regular visits listed here are the easiest way to appreciate its energy, which is why I go to the website every day for new and interesting information. Thank you so much!
ReplyDelete360DigiTMG Data Analytics Course in Bangalore
Fantastic blog extremely good well enjoyed with the incredible informative content which surely activates the learners to gain the enough knowledge. Which in turn makes the readers to explore themselves and involve deeply in to the subject. Wish you to dispatch the similar content successively in future as well.
ReplyDeleteartificial intelligence certification in bhilai
Extraordinary blog went amazed with the content that they have developed in a very descriptive manner. This type of content surely ensures the participants to explore themselves. Hope you deliver the same near the future as well. Gratitude to the blogger for the efforts.
ReplyDeleteDigital Marketing training
Impressive blog to be honest definitely this post will inspire many more upcoming aspirants. Eventually, this makes the participants to experience and innovate themselves through knowledge wise by visiting this kind of a blog. Once again excellent job keep inspiring with your cool stuff.
ReplyDeleteData Science training
Различные разновидности предсказания грядущего упоминаются как астральные науки. Определенный характер гадания исключителен и подготовлен для различных результатов. Гадание на картах на женщину и точность ворожбы напрямую зависит от практики человека. Всякий желает узнать собственную судьбу и представляет определенные типы хиромантии наиболее действенными.
ReplyDeleteFantastic article with valuable information found very knowledgeable and helpful waiting for next blog thank you.
ReplyDeleteData Science Course in Hyderabad 360DigiTMG
ReplyDeleteGreat article with top quality information, found very helpful thanks for sharing waiting for next blog update.
Ethical Hacking Course in Bangalore
It took a while to understand all the comments, but I really enjoyed the article. It turned out to be really helpful for me and I'm positive for all the reviewers here! It's always nice to be able to not only be informed, I'm sure you enjoyed writing this article.
ReplyDeleteCyber Security Course in Bangalore
Happy to chat on your blog, I feel like I can't wait to read more reliable posts and think we all want to thank many blog posts to share with us.
ReplyDeleteCyber Security Training in Bangalore
Fantastic blog extremely good well enjoyed with the incredible informative content which surely activates the learners to gain the enough knowledge. Which in turn makes the readers to explore themselves and involve deeply in to the subject. Wish you to dispatch the similar content successively in future as well.
ReplyDeleteartificial intelligence course in bhilai
Really nice and interesting blog information shared was valuable and enjoyed reading this one. Keep posting. Thanks for sharing.
ReplyDeleteData Science Training in Hyderabad
Really wonderful blog completely enjoyed reading and learning to gain the vast knowledge. Eventually, this blog helps in developing certain skills which in turn helpful in implementing those skills. Thanking the blogger for delivering such a beautiful content and keep posting the contents in upcoming days.
ReplyDeleteData Science certification in Bhilai
Truly incredible blog found to be very impressive due to which the learners who ever go through it will try to explore themselves with the content to develop the skills to an extreme level. Eventually, thanking the blogger to come up with such an phenomenal content. Hope you aarrive with the similar content in future as well.
ReplyDeleteDigital Marketing training in Bhilai
Tremendous blog quite easy to grasp the subject since the content is very simple to understand. Obviously, this helps the participants to engage themselves in to the subject without much difficulty. Hope you further educate the readers in the same manner and keep sharing the content as always you do.
ReplyDeleteData Science training in Raipur
Stupendous blog huge applause to the blogger and hoping you to come up with such an extraordinary content in future. Surely, this post will inspire many aspirants who are very keen in gaining the knowledge. Expecting many more contents with lot more curiosity further.
ReplyDeleteDigital Marketing training in Raipur
Fantastic blog extremely good well enjoyed with the incredible informative content which surely activates the learners to gain the enough knowledge. Which in turn makes the readers to explore themselves and involve deeply in to the subject. Wish you to dispatch the similar content successively in future as well.
ReplyDeleteai course in raipur
Top quality blog with very informative information found very useful thanks for sharing.
ReplyDeleteData Analytics Course Online
Fantastic blog extremely good well enjoyed with the incredible informative content which surely activates the learners to gain the enough knowledge. Which in turn makes the readers to explore themselves and involve deeply in to the subject. Wish you to dispatch the similar content successively in future as well.
ReplyDeleteartificial intelligence certification in bhilai
Tremendous blog quite easy to grasp the subject since the content is very simple to understand. Obviously, this helps the participants to engage themselves in to the subject without much difficulty. Hope you further educate the readers in the same manner and keep sharing the content as always you do.
ReplyDeleteData Science Course in Bhilai
Truly incredible blog found to be very impressive due to which the learners who ever go through it will try to explore themselves with the content to develop the skills to an extreme level. Eventually, thanking the blogger to come up with such an phenomenal content. Hope you aarrive with the similar content in future as well.
ReplyDeleteDigital Marketing Course
It's always nice to be able to not only be informed, but also entertained! I'm sure you enjoyed writing this article. PMP Training in Hyderabad
ReplyDeleteThis article is very useful. Thank you very much. I would recommend you to visit my website, online Converter - https://youtube-to-mp3-converter.com/. With this free Youtube 2 mp3 Converter, you can download your favorite song to your iPhone.
ReplyDeleteМногочисленное множество игр издается ежемесячно. Преимущественно верным путем достать ожидаемую игрушку является https://games9.ru/load/gonki/. Знать что к чему в элементах кибер игр не так просто по факту слишком большого их объема. Поставив игры с Torrent вы получаете пиковый уровень безопасности. Жулики попробуют использовать неосведомленность юзеров и прикладывать вирусы. Скачка торрента оказывается обыкновенной процедурой, подходящей к тому же для неграмотных пользователей.
ReplyDeleteGreat article with excellent information found resourceful and enjoyed reading it thank you, looking forward for next blog.
ReplyDeletetypeerror nonetype object is not subscriptable
Really nice and interesting blog information shared was valuable and enjoyed reading this one. Keep posting. Thanks for sharing.
ReplyDeleteData Science Training in Hyderabad
Really, this article is truly one of the best, information shared was valuable and resourceful Very good work thank you.
ReplyDeleteData Scientist Training in Hyderabad
I have read good things here. Definitely worth to bookmark again. I am amazed at how much effort you put into creating such an informative website. PMP Certification in Hyderabad
ReplyDeleteНиже рассмотрены глобальные достоинства кооперации с данной фирмой. Разнообразный ассортимент инвентаря для жилищной сферы. Воспользуйтесь наибольшими преимуществами исключительно здесь купить детские игровые комплексы от производителей.
ReplyDeleteThanks for sharing great information. I highly recommend you.data science courses
ReplyDeleteЧуть ниже рассмотрены наиболее важные преимущества кооперации с этой фирмой. Огромный сортимент оборудования для жилищной сферы. Получите максимальные выгоды именно здесь https://snabtop.ru/category/plastikovye-kontejnery/.
ReplyDeleteСосредоточьтесь не только на керамогранитной плитке западного изготовления, но и на наши образцы. Выбирая качественный продукт как например saloni необходимо рассмотреть максимальное число продуктов. Кафельная очень хорошо подойдет к каждому интерьеру. Оптимальный выбор настенного покрытия может приукрасить всякую кухню или ванную комнату.
ReplyDeleteImpressive blog to be honest definitely this post will inspire many more upcoming aspirants. Eventually, this makes the participants to experience and innovate themselves through knowledge wise by visiting this kind of a blog. Once again excellent job keep inspiring with your cool stuff.
ReplyDeleteDigital Marketing Course
Terrific post thoroughly enjoyed reading the blog and more over found to be the tremendous one. In fact, educating the participants with it's amazing content. Hope you share the similar content consecutively.
ReplyDeleteData Science Course in Bhilai
Stupendous blog huge applause to the blogger and hoping you to come up with such an extraordinary content in future. Surely, this post will inspire many aspirants who are very keen in gaining the knowledge. Expecting many more contents with lot more curiosity further.
ReplyDeleteData Science Course in Raipur
Truly mind blowing blog went amazed with the subject they have developed the content. These kind of posts really helpful to gain the knowledge of unknown things which surely triggers to motivate and learn the new innovative contents. Hope you deliver the similar successive contents forthcoming as well.
ReplyDeleteDigital Marketing training
Фирма «Skoro Dengi» предлагает своим заказчикам новые мфо онлайн займ на карту и возможность подбора финансовых групп. Сами оформляйте понравившийся коммерческий продукт на всевозможные цели. Никому более не потребуется посещать банк, чтобы получить необходимую сумму.
ReplyDeleteTruly mind blowing blog went amazed with the subject they have developed the content. These kind of posts really helpful to gain the knowledge of unknown things which surely triggers to motivate and learn the new innovative contents. Hope you deliver the similar successive contents forthcoming as well.
ReplyDeleteDigital Marketing training
Stupendous blog huge applause to the blogger and hoping you to come up with such an extraordinary content in future. Surely, this post will inspire many aspirants who are very keen in gaining the knowledge. Expecting many more contents with lot more curiosity further.
ReplyDeleteData Science certification in Raipur
Tremendous blog quite easy to grasp the subject since the content is very simple to understand. Obviously, this helps the participants to engage themselves in to the subject without much difficulty. Hope you further educate the readers in the same manner and keep sharing the content as always you do.
ReplyDeleteDigital Marketing training
I've read this post and if I could I desire to suggest you some interesting things or suggestions. Perhaps you could write next articles referring to this article. I want to read more things about it!
ReplyDeletedata science training in Hyderabad
I wanted to leave a little comment to support you and wish you the best of luck. We wish you the best of luck in all of your blogging endeavors.
ReplyDeleteArtificial Intelligence Course in Bangalore
Три в ряд – более чем известный слот средь виртуальных игр Kazino X. Подробное меню и стремительный поиск – это гарантированный способ выбрать интересующую азартную игрушку. Всего лишь на данной платформе казино х официальный посетитель может погрузиться в невероятные путешествия.
ReplyDeleteСервисная служба в любое время придет на помощь и оперативно разрешит самую непростую проблему. Имейте в виду, что казино x скачать на андроид никогда не спрашивает денег за проведение сеанса регистрации пользователей. Просмотреть оригинальность портала можно на центральной странице casino-x-oficialniy-sayt.com.
ReplyDeleteИспользовав игровые автоматы мистер бит вы попадете в удивительный мир игры на компьютере. Люди состязаются в реакции, организовывают настоящие команды и берут награды в турнирах. Развлечения молодого поколения с большими подарками. Киберспорт – это последний этап становления высокопрофессиональных чемпионатов.
ReplyDeleteReally wonderful blog completely enjoyed reading and learning to gain the vast knowledge. Eventually, this blog helps in developing certain skills which in turn helpful in implementing those skills. Thanking the blogger for delivering such a beautiful content and keep posting the contents in upcoming days.
ReplyDeleteData Science certification in Raipur
Truly incredible blog found to be very impressive due to which the learners who ever go through it will try to explore themselves with the content to develop the skills to an extreme level. Eventually, thanking the blogger to come up with such an phenomenal content. Hope you arrive with the similar content in future as well.
ReplyDeleteDigital Marketing training in Raipur
Highly appreciable regarding the uniqueness of the content. This perhaps makes the readers feels excited to get stick to the subject. Certainly, the learners would thank the blogger to come up with the innovative content which keeps the readers to be up to date to stand by the competition. Once again nice blog keep it up and keep sharing the content as always.
ReplyDeleteData Science Course in Bhilai
Wonderful blog found to be very impressive to come across such an awesome blog. I should really appreciate the blogger for the efforts they have put in to develop such an amazing content for all the curious readers who are very keen of being updated across every corner. Ultimately, this is an awesome experience for the readers. Anyways, thanks a lot and keep sharing the content in future too.
ReplyDeleteDigital Marketing Course
I have to search sites with relevant information ,This is a
ReplyDeletewonderful blog,These type of blog keeps the users interest in
the website, i am impressed. thank you.
Data Science Course in Bangalore
Цена покрытия существенно различается. Разновидность рисунков и форматов. Кафель клинкерная плитка cerrad cer реализуют в невероятном количестве, и каждая компания планирует запустить особый уникальный дизайн.
ReplyDeleteReally impressed! Everything is a very open and very clear clarification of the issues. It contains true facts. Your website is very valuable. Thanks for sharing.
ReplyDeleteBusiness Analytics Course
Любые методы предсказания будущего называются как астральные науки. Определенный род хиромантии уникален и необходим для разного рода задач. Гадание на картах онлайн любит ли он меня и чистота ворожбы прямо зависит от навыков гадающего. Любой стремится подсмотреть собственную судьбу и воспринимает определенные средства предсказания будущего более действенными.
ReplyDeleteКерамогранитная плитка http://otzyvoff.ru/index.php?subaction=userinfo&user=uhule используется почти во всех помещениях. Огромный ассортимент изделий, показанный в прейскуранте торговой площадки, доступен каждому по самой актуальной цене. На вебсайте компании Легенда Gres каждый желающий сможет выбрать кафель по оптимально приемлемой стоимости.
ReplyDeleteАссортимент материалов, выставленный в каталоге legendagres.ru https://metalverk.ru/forum/?PAGE_NAME=profile_view&UID=25518, правда обширен. Главными элементами при производстве являются светлая глина и незначительное количество прибавок, изменяющих оттенок и микроструктуру. Производством отделочной плитки занимаются очень многие компании на всех континентах.
ReplyDeleteРыбные деликатесы отличного качества есть в магазине на Бережковской набережной в любое время. Посещая наш магазин, вы приобретете именно качественную рыбопродукцию от надежных дилеров. Широкий ассортимент продукции http://www.apicarrara.it/modules.php?name=Journal&file=display&jid=16161 и своевременная доставка.
ReplyDeleteIt is so good to read a new article.
ReplyDeletejava interview questions and answers
selenium interview questions and answers
digital marketing interview questions and answers
hadoop interview questions and answers
oracle interview questions
data science interview questions and answers
Most helpful blog! It is the greatest comprehensive updates about this topic and Thank you for your sharing with us..!
ReplyDeleteAutomation Anywhere Training in Chennai
Automation Anywhere Online Training
VMware Training in Chennai
VMware Course in Bangalore
Automation Anyware Online Course
ReplyDeleteI see the greatest contents on your blog and I extremely love reading them.
business analytics course
Раскрыты подробности смерти актера Дмитрия Писаренко. Источник https://newstes.ru/2021/02/24/raskryty-podrobnosti-smerti-aktera-dmitrija-pisarenko.html
ReplyDeleteВ большинстве случаев сверла для механической дрели применяют для прямого исполнения отверстий в бытовых условиях. Стандартные сверла обладают достаточно приличной заточкой. Стандартным сверлом невероятно легко сверлить маленькие круглые пазы. Именно комплект закаленный SDS-PLUS бур по бетону купить – хороший вариант, проходит к твердым сплавам, как пример, для листового металла.
ReplyDeleteЗажарить сытную курицу без специфических сложностей на редкость легко https://trebuha.ru/442-svinaja-vyrezka-s-syrnoj-glazurju-i-sousom.html. Примените нужный элемент для создания нестандартного вкуса, допустим, красный лук. Припасы для готовки курятины недорогие, достаточно лишь курочка и незначительное число приправы. Главная причина заключается в самой системе жарки. Полезно вымочить вырезку и добавить особых добавок по душе.
ReplyDeleteImpressive. Your story always bring hope and new energy. Keep up the good work.
ReplyDeletedata scientists training
I really enjoy every part and have bookmarked you to see the new things you post. Well done for this excellent article. Please keep this work of the same quality.
ReplyDeleteArtificial Intelligence course in Chennai
Fantastic blog with excellent information and valuable content just added your blog to my bookmarking sites thank for sharing.
ReplyDeleteData Science Course in Chennai
i am glad to discover this page : i have to thank you for the time i spent on this especially great reading !! i really liked each part and also bookmarked you for new information on your site.
ReplyDeletebest data science courses in bangalore
I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
ReplyDeletebest data science courses in hyderabad
Самый наглядный случай – на любой кухне непременно есть чайник. Кухонную утварь возможно символично разделить на две крупные категории – декоративные и практические, для ежедневного применения. На сайте онлайн-магазина «МАКСИДЕН» запросто выбрать гладильная доска купить в нижнем новгороде по самой актуальной цене.
ReplyDeleteРазнообразные способы для гадания употреблялись людьми с древнейших времен. В некоторых направлениях хиромантия определяется ложной наукой. Цифрология - больше всего востребованные манипуляции для ворожбы https://gadanie.fun/gadanie-na-parnya-onlajn/.
ReplyDelete