SQL Server Tools

Good Afternoon Is it possible to set up a linked server in sqlsever2005 using a dot net provider driver? In particular can I link (linked server)to mysql using the .net provider for mysql version 5.1.3? If this is not possible, is there another way of using the .net provider to ...

Good after noon I've succesfully used a scaler valued function in a update query ie UPDATE ProductItemDH SET "ItemId"=get_itemid(ProductItemDH.field1) But now I need to set serveral fields ie UPDATE ProductItemDH SET "ItemId"=get_itemid(ProductItemDH.field1) SET "desciption"=get_description(ProductItemDH.field1) ...

In SQL Server 2005 Management Studio, the Connect to Server dialog has a combobox for "Server name" that remembers any servers I have ever connected to. Some of those servers no longer exist.  Is there a way to remove ...

We updated some servers from 05 to 08. We soon found out you couldn't do queries in 05 to an 08 server. So the DBAs installed SSMS on their xpp sp2 boxes.  Only SSMS not the database. Well if you try to edit a proc you get nothing but error squiggleys. ...

I have a request to run Statistics on a DB/Schema. This will improve response time and query performance for a clients data. I have never done this. New to SQL Server. Can some please provide me some ideas what needs to be done.  Also, ...

Hi When I start SQL Management Studio 2005 SP3 the following message comes up. Could not load file or assembly 'EnvDTE, Version=8.0.0.0, Culture=neutral, PublicKey Token=b03f..." or a one of its dependencies. The system cannot ...

I am using the management studio tool that came with SQL server 2008 Express Edition. Problem is the relationship button is greyed out on the toolbar. How do I create relationship (between tables) in SQL 2008 Express... also what do I need to set to enable the (greyed out) relationship button? ...