Database

I have no help for you in the replication area, however this does sound like a really bad design. Some questions come to mind Why do you need the data on a local machine Why every 5 minutes Never underestimate the power of human stupidity RAH

Well I'm guessing that the emailed report is identical, so it must be something changed in the client config or the Exchange server. Have you been through the various Outlook options relating to encoding? Also it seems like your mid upgrade too, maybe somebody changed something on the Exchange side? As a test could you send an report to a completely different address (i.e. gmail).

You set the default collation of SQL server to a different value than was in your previous installation. Change the default collation for your SQL server to the value which you explicitly set for the column which results in the error shown.

The XML data will be put on my ftp server and I need to read the data. I have created the tables in SQL but now need to write a stored procedure to read the XML. All examples I found only use the 1 table so I still haven't managed to get the data into multiple tables. Also in the child elements there is a field that include the foreign key [/int] added to it. I suppose I could do a substring once I read the data but for now I'm still stuck.

Oh yeah, there's that, I never use it so I didn't think of it. A console app could be written to do it.

Thank you very much...

Or Change your stock table to have an allocated field and increment/decrement that as the request is processed or cancelled/completed. It will depend on your business process, if the sales process takes minutes or a longer period this may suit. You have to deal with crash edge cases where you have orphaned allocated values. Never underestimate the power of human stupidity RAH

ASP.NET forum[^] ASP.NET Articles[^] and on the home page you will lists of the latest articles, tips and questions which you can filter to asp.net Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

I'd advice to not use the "in" operator with a user-defined varchar, but to name the values individually. SELECT * FROM tableName WHERE ColumnId = 1 OR ColumnId = 2 You can simply concatenate "OR ColumnId = @value" to the query and set the parameters. Bastard Programmer from Hell :suss:

my Vote +5 for good example and nice explaination... Happy Coding... :)

Yes thanks .. I'm also thinking the same.

obarahmeh wrote: Is this option (Transactional Replication) the most useful and best solution for mu purpose? Actually there are several ways of doing this, but if your way works for you then it is the best way. Sorry I do not remember how to fail-over. Currently we use log shipping but not the High Availability of it as we manually switch (not my idea). Good luck, and do not forget to practice the fail-over every so often.

Aha I found the problem and it works. I put mm for minutes - it should be mi. :)

yes that is correct Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa[at]dotnetfunda.com http://www.Dotnetfunda.com

You can use asp.net data-grid option control to populate your data into browser in the right side property explorer limit property set to as you want In this case your data populate into pagination Kumar Ashish

Here it is select t2.c1,t2.c2,t1.c12 as c3,t11.c12 as c4,t111.c12 as c5 from table2 t2 inner join table1 t1 on t1.c10 = t2.c3 left join table1 as t11 on t11.c10 = t2.c4 left join table1 as t111 on t111.c10 = t2.c5 I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.

jschell wrote: originated internally within the company. Which is my point too. Generally, more people have access to the file system than to the database. A no-longer-gruntled sys admin could replace individual files, but not alter the contents of the database.

I understand what a mathematical symbol in mathematics means. However that has nothing to do with how you represent the idea on a computer. For example I could use a paint program to create a formula and then store it in a database. Or, as I suggested, unicode has mathematical representations. There are other possibilities. It is up to you, based on your business needs, to first determine the form (the data on the computer) that your representation will take.

You can also check out replication.[^] Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions