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.

I'm afraid you won't be able to directly create a task through SQL Server, but I'm not an absolute expert at your requirement. However, this is how I might approach the problem. 1) In TSQL, there is a command called, xp_cmdshell, which allows you to execute a command shell 2) Create a command-line application that would take as command line parameters the values you need to create a Task. There are significant security issues related to enabling xp_cmdshell, so you may want to evaluate those issues first.

This problem is related with your outlook installation, please check if you are able to search ‘00061032-0000-0000-C000-000000000046’ in your registry if not then run the outlook setup again

obarahmeh wrote: SecondDataTable= FirstDataTable; This means both tables are referring to the same object in memory. What you can do is, create a deep copy of the FirstDataTable. You can find a lot of examples on web for doing this. 50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

It is not a stupid question, because the SQL Server is installed on the server, and the client login with a user name and password which have read access into the database. Kind Regards OBarahmeh

RemovePreviousVersions[^] No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced. This message is made of fully recyclable Zeros and Ones

Thanks a lot man...sometimes we think that most cases can not be solved simply, but always I see that there is a simple solution. :zzz: :wtf: :~:rose::rose::rose: Kind Regards OBarahmeh

Would you like an ugly option? How about: CREATE FUNCTION DoFunction ( @Op1 BIGINT , @Oper NVARCHAR(2) , @Op2 BIGINT ) RETURNS BIT AS BEGIN IF ( @Oper = '>=' AND @Op1 >= @Op2 ) RETURN 1 ELSE IF ( @Oper = '<=' AND @Op1 <= @Op2 ) RETURN 1 -- More RETURN 0 END select * from test where dbo.dofunction ( VOLUME_TRADED , '<=' , @Volume )=1 Otherwise, I might suggest: SELECT * FROM test WHERE CASE WHEN @Oper='<=' AND VOLUME_TRADED <= @Volume THEN 1 WHEN @Oper='>=' AND VOLUME_TRADED >= @Volume THEN 1 ELSE 0 END = 1

Ok, I've found the solution: USE yourDB; GO -- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE yourDB SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (yourDB_Log, 1); GO -- Reset the database recovery model. ALTER DATABASE yourDB SET RECOVERY FULL; GO Kind Regards OBarahmeh

obarahmeh wrote: But are you sure that this method (Transactional publication with updatable subscriptions) makes update conflict The method doesn't make them, your application (modifications) may cause conflicts. obarahmeh wrote: why SQL 2008 contains this method if there is a problems when we use it For example: you have the same row on two different SQL Servers which then replicate the modifications to each other. The replication interval is, let's say 15 minutes. Now you update the same record on both SQL Server. Next time the modifications are replicated, SQL Server sees that the exact same row has been modified on both ends. Now the question is, which modification is correct? There's no simple answer to that. In some cases it may be the earliest or the latest or perhaps it's both modifications combined. So the problem isn't in the technology. It is something that you as a designer must be aware of and model the data and the applications so that conflicts do not occur or that they are rare. The same conflict situation concerns all modifications (update, insert and delete). obarahmeh wrote: what is the ideal solution for making replication in SQL server 2008? This depends fully on the requirements. The need to optimize rises from a bad design.My articles[^]

Of course I tried that, butt still having the same problem Kind Regards OBarahmeh

Looks like framework configuration issue. Check the event viewer to see what is the error. Navaneeth How to use google | Ask smart questions

Thank you very much, I did not knot that there is a CASE option in SQL Thanks a lot Kind Regards OBarahmeh

obarahmeh wrote: Why or where do we need to use such type of Classes? As Pete explained, serialization transforms object(s) to/from raw data for the purpose of transmitting or persisting them. Another good thing to know is that one can use Google to find things out[^] led mike

Who is? :confused:

OR do you want to retrieve all rows when you give a 'where' condition also. :doh: EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE. How to post a question

obarahmeh wrote: using the local IIS Is that on another server yea? i.e. not your local machine? Is there an error when you see no data? Have you tried displaying data in another control or creating a simple form to test the connection?