Dear All, We are planning to have a complete solution for SQL Server disaster situation. We will have two servers, one is locally and the other is in another country where we have VPN connections between the two offices. I planned to build a transactional replication with fail over options to redirect our applications to the subscriber server. My question is: Is this option (Transactional Replication) the most useful and best solution for mu purpose? And if it is the best solution, how can our applications redirect to the subscriber server if the primary server is down??? Is there any thing to use that may check the primary server availability and redirect the applications to the subscriber server automatically??? Your help is very very very appreciated Best Regards

Kind Regards OBarahmeh

Hi, I need to create the tasks through an SQL Server procedure and not using .NET Do u have any ideas about how to do this in a procedure inside the SQL Server? Regards

Kind Regards OBarahmeh

Dear All, I need to create a procedure that creates an outlook task for a set of domain users when some condition in the data base is fired. Is this possible? I am using SQL Server 2008 R2, Exchange Outlook 2010 Regards

Kind Regards OBarahmeh

Good morning, First, I am sorry for posting in two places. The exception is thrown in the following line: TaskItem OutlookTask = new TaskItem(); And thank you for your replies. Regards

Kind Regards OBarahmeh

Dear All, I am developing a windows application which has a feature that when press on some button, it will do an outlook task, my code is C#: using Microsoft.Office.Core; using Microsoft.Office.Interop.Outlook; private void button1_Click(object sender, EventArgs e) { Microsoft.Office.Interop.Outlook.TaskItem OutlookTask = new Microsoft.Office.Interop.Outlook.TaskItem(); OutlookTask.Actions.Application.CreateItem(OlItemType.olTaskItem); OutlookTask.Assign(); OutlookTask.Recipients.Add("email@domain.ps"); OutlookTask.Subject = "Testing The Tasks from my application"; OutlookTask.Body = "Body: Testing The Tasks from my application"; OutlookTask.DueDate = DateTime.Today; OutlookTask.ReminderTime = OutlookTask.DueDate; OutlookTask.Save(); } The Error: Retrieving the COM class factory for component with CLSID {00061032-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)). note: I added the reference to use Outlook which is: Microsoft Outlook 14.0 Object Library I am using VS 2010, and my outlook is Outlook 2010 Any ideas Plz???

Kind Regards OBarahmeh

Dear All, We are using Share point in our institution, and we are facing a problem which is: there are many document libraries and custom lists, and many files have been stored in. All meta-data for these files have a field called Document_Code which is a sequence. my question is: Is there an ability to change the sequence for all documents using some script or any thing else? example: I wanna add 100 for all document_code in all files. Regards

Kind Regards OBarahmeh

Dear All, I have two DataTables. The first (FirstDataTable) is filled by a query and the second is filled by: SecondDataTable= FirstDataTable; after this equal operation, the two DataTables are connected and any change is reflected between the both. I mean when you change the data in the FirstDataTable by a different query, this change will be reflected to the SecondDataTable automatically. The question here: How can I stop or reject the connection between the two DataTables. I mean I do not want to reflect the changes after the equal operation. this is to make a copy of the first data returned by the first run of the query. Regards.

Kind Regards OBarahmeh

Dear All, I have a combo box which get its data from SQL data source. I need to add one row to the columns got from this Sql Data source at run time. How can I do this?

Kind Regards OBarahmeh

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

Dear All, I am using windows 2008, VS 2008, and SQL Server 2008. I built a windows application which reads data from SQL 2008. when I install this application into windows 2008 , it runs successfully and read the data successfully. But when I install this application on windows XP, it runs successfully but it does not read any data in its forms. I installed Dot Net framework 3.5 SP1 on the windows XP machine, and it did not work. I searched google with no results. Please help

Kind Regards OBarahmeh

modified on Monday, November 2, 2009 3:41 AM

Dear All, I am tired because each time I want to install the new upgraded version I have to go to add/remove programs to uninstall the last version. Is there a way when we build the setup project we can do to make the setup project detect if there is a pre installed version for the same app., it automatically uninstall this pre-installed version?

Kind Regards OBarahmeh

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

sorry for posting the same question in two places. I tried your solution as the following: declare @operator bit; set @operator = 1; ( SELECT DISTINCT T.TICKET_NUMBER AS TicketNum, A.DESCRIPTION AS Action, O.SYMBOL_CODE AS Symbol, T.TRADE_PRICE AS Price, T.VOLUME_TRADED AS FillVol, T.EXTENDED_PRICE AS TotalValue, T.SUBMITTED_TIME AS ActTime, T.SUBMITTED_DATE AS TransDate FROM TSDETL AS T INNER JOIN TSORDR AS O ON O.SUBMITTED_DATE = T.SUBMITTED_DATE AND O.TICKET_NUMBER = T.TICKET_NUMBER INNER JOIN TSORDA AS A ON O.ORDER_ACTION = A.ACTION_CODE WHERE (T.SUBMITTED_DATE = '20090405') AND (CASE WHEN @operator = 1 THEN T.VOLUME_TRADED >= 500 ELSE T.VOLUME_TRADED <= 500 END) AND (T.TICKET_NUMBER IS NOT NULL) AND (O.SYMBOL_CODE= 'BOP') ORDER BY ActTime DESC ) but this did not work , it gives me an error : Msg 102, Level 15, State 1, Line 10 Incorrect syntax near '>'.

Kind Regards OBarahmeh

Dear All, I have a query that has some parameters: ( SELECT DISTINCT T.TICKET_NUMBER AS TicketNum, A.DESCRIPTION AS Action, O.SYMBOL_CODE AS Symbol, T.TRADE_PRICE AS Price, T.VOLUME_TRADED AS FillVol, T.EXTENDED_PRICE AS TotalValue, T.SUBMITTED_TIME AS ActTime, T.SUBMITTED_DATE AS TransDate FROM TSDETL AS T INNER JOIN TSORDR AS O ON O.SUBMITTED_DATE = T.SUBMITTED_DATE AND O.TICKET_NUMBER = T.TICKET_NUMBER INNER JOIN TSORDA AS A ON O.ORDER_ACTION = A.ACTION_CODE WHERE (T.SUBMITTED_DATE = @SUBMIT_DATE) AND (T.VOLUME_TRADED >= @Volume) AND (T.TICKET_NUMBER IS NOT NULL) AND (O.SYMBOL_CODE= @Symbol) ORDER BY ActTime DESC ) I passed the three parameters (@SUBMIT_DATE, @Volume, @Symbol) successfully, but I want to read the operator (>= or <=) as a parameter...I have a combo box with >= and <=, and I want to pass the value of this combo into the query. How can I do this??? this is because the operator may be >= or <=, and I don't want to write two queries.

Kind Regards OBarahmeh

Dear All, I have a query that has some parameters: ( SELECT DISTINCT T.TICKET_NUMBER AS TicketNum, A.DESCRIPTION AS Action, O.SYMBOL_CODE AS Symbol, T.TRADE_PRICE AS Price, T.VOLUME_TRADED AS FillVol, T.EXTENDED_PRICE AS TotalValue, T.SUBMITTED_TIME AS ActTime, T.SUBMITTED_DATE AS TransDate FROM TSDETL AS T INNER JOIN TSORDR AS O ON O.SUBMITTED_DATE = T.SUBMITTED_DATE AND O.TICKET_NUMBER = T.TICKET_NUMBER INNER JOIN TSORDA AS A ON O.ORDER_ACTION = A.ACTION_CODE WHERE (T.SUBMITTED_DATE = @SUBMIT_DATE) AND (T.VOLUME_TRADED >= @Volume) AND (T.TICKET_NUMBER IS NOT NULL) AND (O.SYMBOL_CODE= @Symbol) ORDER BY ActTime DESC ) I passed the three parameters (@SUBMIT_DATE, @Volume, @Symbol) successfully, but I want to read the operator (>= or <=) as a parameter...I have a combo box with <= and >=, and I want to pass the value of this combo into the query. How can I do this??? this is because the operator may be >= or <=, and I don't want to write two queries.

Kind Regards OBarahmeh

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

Dear All, I need to reduce the log file size... I've created a maintenance plan for shrinking the DB in my local machine, I've created every thing ok and scheduled it to work daily. and when I right click and then execute, the dialog displays successful process, but when I check the DB Log, it still huge size (about 20 Gb). I do not know why the log file size still huge after shrinking the DB. Any help, plz???

Kind Regards OBarahmeh

Ok I will adda an Identity column. But are you sure that this method (Transactional publication with updatable subscriptions) makes update conflict??? So, why SQL 2008 contains this method if there is a problems when we use it? And then what is the ideal solution for making replication in SQL server 2008?

Kind Regards OBarahmeh

Dear All, I have a table that has a huge number of data, this table has no primary key. I need to create a replication that replicate this table and any new transactions applied to this table. And so, I think I should choose either "Transactional publication" OR "Transactional publication with updatable subscriptions", but in both options it does not accept to create this replication because the source table has no primary key. How can I solve this problem to create a good replication? :sigh:

Kind Regards OBarahmeh

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

Kind Regards OBarahmeh