15,748,559 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View Javascript questions
View C++ questions
View Python questions
View Java questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Khorshed Alam, Dhaka (Top 11 by date)
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/
Show More