Error Number 7320
360 games PC games Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums General SQL Server Forums New to SQL Server Programming SQL Error 7320.......Using linked servers Reply to https://support.microsoft.com/en-us/kb/270119 Topic Printer Friendly Next Page Author Topic Page: 1 2 of 2 flextera Yak Posting Veteran 50 Posts Posted-09/17/2014: 15:13:49 Msg 7320, Level 16, State 2, Procedure selectlogHistory, Line 68Cannot execute the query "SELECT Tbl1001.DateTime Col1009,Tbl1001.TagName Col1010,Tbl1001.Value Col1011 FROM Runtime.dbo.AnalogHistory Tbl1001 WHERE Tbl1001.TagName=? AND Tbl1001.DateTime=? AND Tbl1001.wwRetrievalMode=N'Delta'" against OLE DB provider "INSQL" for linked server "INSQL". I get http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=196263 this error message when running a query. Keep in mind that this query is using linked servers in SQL. Thanks in advance tkizer Almighty SQL Goddess USA 38200 Posts Posted-09/17/2014: 15:28:33 Show us the actual query and not just the error.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ flextera Yak Posting Veteran 50 Posts Posted-09/17/2014: 15:49:16 I'm not looking for a fix in my query code. I am looking for information regarding this certain error. tkizer Almighty SQL Goddess USA 38200 Posts Posted-09/17/2014: 16:07:47 My point is that we need to see the query in order to help you with the error.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ flextera Yak Posting Veteran 50 Posts Posted-09/17/2014: 16:50:47 Here is my stored procedure tkizer Almighty SQL Goddess USA 38200 Posts Posted-09/17/2014: 16:56:30 I don't see INSQL anywhere in that stored procedure.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ flextera Yak Posting Veteran 50 Posts Posted-09/17/2014: 16:59:32 Exactly why this is so confusing... James K Flowing Fount of Yak Kn
contain at least one valid tagname 0 Hi this is my query SELECT AnalogHistory.DateTime https://ask.sqlservercentral.com/questions/138860/sql-error-7320-history-queries-must-contain-at-lea.html ,AnalogHistory.TagName ,AnalogHistory.[Value] ,AnalogHistory.Quality FROM AnalogHistory .....and This is Error http://dba.stackexchange.com/questions/43942/sql-server-2012-linked-server-to-sql-server-2000 OLE DB provider "INSQL" for linked server "INSQL" returned message "History queries must contain at least one valid tagname". Msg 7320, Level 16, State 2, Line 2 Cannot execute the query "SELECT Tbl1001.DateTime Col1004,Tbl1001.TagName Col1005,Tbl1001.Value Col1006,Tbl1001.Quality Col1007,Tbl1001.QualityDetail error number Col1008 FROM Runtime.dbo.AnalogHistory Tbl1001" against OLE DB provider "INSQL" for linked server "INSQL". more ▼ 1 total comment 596 characters / 66 words asked Jun 10 at 03:11 PM in Default whussain6 1 Are you using Wonderware?http://stackoverflow.com/questions/29279915/sql-show-only-the-most-recent-datetime-values Jun 10 at 03:20 PM Kev Riley ♦♦ add new error number 7320 comment (comments are locked) 10|1200 characters needed characters left ▼ Everyone Moderators Original poster and moderators Other... Viewable by all users 0 answers: sort voted first ▼ oldest newest voted first Be the first one to answer this question toggle preview: Attachments: Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total. Follow this question By Email: Once you sign in you will be able to subscribe for any updates here By RSS: Answers Answers and Comments Follow @Ask_SSC Follow Ask SSC on Facebook Find Ask SSC on Google+ Find us on LinkedIn Need long-form SQL discussion? SQLserverCentral.com is the place. Topics: sql server 2012 x89 asked: Jun 10 at 03:11 PM Seen: 74 times Last Updated: Jun 10 at 03:20 PM