Comments by Khorshed Alam, Dhaka

Khorshed Alam, Dhaka 6-Mar-13 23:21pm View

1. Press Windows Key, Type "SQL Server Configuration Manager" in the search box.
2. Open SQL Server Configuration Manager.
3. Select SQL Server Service from Left pane.
4. In the right Window you will be able to see all available instances.

Khorshed Alam, Dhaka 6-Mar-13 10:01am View

Download "windows6.1-KB976932-X64.exe" this one and install it. Afterwards try to install SQL 2012. Hopefully you will be succeeded.

Khorshed Alam, Dhaka 6-Mar-13 5:41am View

you have Windows 7 SP1 instelled? Id not get it from http://www.microsoft.com/en-us/download/details.aspx?id=5842

Khorshed Alam, Dhaka 6-Mar-13 4:55am View

What OS you are using WIN7 if so please check you have the latest service pack.Another think, it seems you are attempting to install 64bit version of SQL 2012. Is your OS also 64 bit?

Khorshed Alam, Dhaka 6-Mar-13 4:49am View

As the table's other columns already contains data so you need to update the newly added columns with proper values. like
UPDATE [Table]
SET NewCol1 = 'Value1',
NewCol1 = 'Value2'
WHERE Id = 1

Khorshed Alam, Dhaka 5-Mar-13 4:44am View

Please post your query. Crating proper index on appropriate colums will reduce the Logical reads significantly.

Khorshed Alam, Dhaka 28-Feb-13 0:22am View

You are welcome!, to be honest, the way you are following to transfer data from completely different environment is not the most preferable way .Trigger based solution is preferable to work with the same environment. Better to export data in Flat file (.csv, or fixed length) from SQL Server via Export Import Wizard or SSIS packge. I am not an expert of MySQL, If there any facility of job scheduling then you can schedule a job to pull the data from the files. This solution will work if you do not need any real time in both places. In SQL server there are another feature called SSIS using this features you can expert SQL server data to another data source. There are also several ways but all are not top of my head right now. I will let you inform If I can think of any better solution. Hope you will get your job done soon!

Khorshed Alam, Dhaka 28-Feb-13 0:02am View

I am not sure though, but ppl says it is a bug of MySQL. See the link
http://social.msdn.microsoft.com/Forums/is/sqldatabaseengine/thread/5c312706-5144-4a71-83b4-af63dec6810a

Can you test it out of the trigger? Create a stored procedure and test your work like
Create Procedure TestInsertMySQL
AS

INSERT OPENQUERY(MySQLLinkedSvr,'SELECT * FROM Table')
SELECT * FROM SomeTable

Khorshed Alam, Dhaka 27-Feb-13 23:15pm View

Dear Ram7 sorry to answer you being late.It seems the RAMU-IBX server's Microsft Distributed Transaction Co-Ordinator is off. Please follow the link for the workaround.
http://blog.sqlauthority.com/2010/03/24/sql-server-fix-error-8501-msdtc-on-server-is-unavailable-changed-database-context-to-publisherdatabase/

Khorshed Alam, Dhaka 22-Feb-13 6:32am View

Check your database AutoShrink property. If it is set to True, set it to False. Couple years ago I faced an issue like you and that happened because of AutoShrink property.

Khorshed Alam, Dhaka 22-Feb-13 1:12am View

Dear Ram7,
Please have a look on the link, it may help you.
http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/

Comments by Khorshed Alam, Dhaka (Top 11 by date)