Database

B413 wrote: I would like to test the AlwaysOn Availability Groups functionality of SQL server to validate or not if this solution is good for my company. That would depend more if it actually does what you're buying it for. If it would not, it would fail as a product. B413 wrote: Is it possible to test this for free? There's a description to how you set it up on MSDN[^]. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

You're welcome - version control is your friend in these sorts of situations :) :thumbsup: “That which can be asserted without evidence, can be dismissed without evidence.” ― Christopher Hitchens

You need to reply to the right message - I had no idea you'd posted this reply! :doh: There are lots of reasons why a query that runs fast in SQL Server Management Studio can be slow in .NET: Slow in the Application, Fast in SSMS?[^] The most common reason I've seen is the ARITHABORT setting - it's ON by default in SSMS, but OFF by default in .NET connections. Adding SET ARITHABORT ON to the start of your stored procedure often helps. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Please do not crosspost; you already posted this question in the Android forum.

That's all it took. Of course, the project needs to add the library for SQLite. Now I am working to populate a combobox with unique values from a column in the database table. Thanks.

The text, ntext and image types have been obsolete for many years: ntext, text, and image (Transact-SQL)[^]: Important: ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead. Change your variable to varbinary(max). You should also change any columns using the text, ntext or image types to their supported equivalents. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

The answer is here Administer and Monitor Change Data Capture (SQL Server)[^]

Or get used to use EXISTS instead of IN. EXISTS does not use three valued logic. SELECT * FROM ao_campaigns WHERE NOT EXISTS ( SELECT * FROM orders WHERE orders.ao_campaign_id = ao_campaigns.id ) Wrong is evil and must be defeated. - Jeff Ello

Heikki welcome to CP, you have missed the usage of the forums, they are for asking questions and discussions. What you have posted is more suited to an article or Tip/Trick. An article gets peer vetted and released, it stays around and may be useful for a long time. A forum post will stay on the from page for only a short time and will not be a long term benefit. An article may attract comment, it can be downloaded and modified and it enhances your reputation (if it is worthy). I suggest you post this as an article or T/T, it will need some more structure and additional work but it will give much better value. Never underestimate the power of human stupidity RAH

If you had posted this in the correct forum - C# Discussion Boards - CodeProject[^] or even Quick Answers - CodeProject[^] then you would have probably had an answer much earlier. Please take more care in future. You could do it this way var arrSize = (from object c in Controls where c.GetType() == typeof(ComboBox) select c as ComboBox).ToArray();

Is this MS SQL Server you are referring to? If so you can use the SSMS Wizard to set up a package to export the data - very easy to use and once the package is in place you can tweak it if you need to use it again... We had a similar set up on our Test database (so that we could change it without having to have update permissions on Production)

May be this is not direct solution for you but should give you some idea. sql server - Delayed availability of historical data when using CDC - Database Administrators Stack Exchange[^]

This will explain it much better than I can -> clickety[^]. “That which can be asserted without evidence, can be dismissed without evidence.” ― Christopher Hitchens

Original type of field in Oracle Database is date.Now I select this and insert to SQL server.Then show in gridview. The question is How to get exactly data from oracle database link? And How to show exactly data to the user?

Query the sys.columns table for @TbleName and add if the CreatedBy, ModifiedBy columns exist on that table add that in to the dynamic SQL

Another benefit of changing the column name will be the opportunity to give it a semantically meaningful name. Just "Date" could be any sort of date anyone might ever think of. Calling it what it actually is (like "CreatedDate", "PurchaseDate", etc.) will make much more sense. If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

You should enforce INSERT/UPDATE triggers for these auditing purposes. You cannot reply on the developers to implement this.