Hi There, I have a query that has drastically different execution plans when run as an ad-hoc query vs. a stored procedure, is this normal? The reason I ask is because it causes the stored procedure to run extremely bad when one parameter changes. Here are some details about the query... - ...more >>

I seem to be spending too much time "Googling" for info on what should be a a fairly straight forward task - porting an mySQL db schema over to SQL Server. The T-SQL documentation I have seen so far do not give any useful (i.e. detailed enough) examples. My tables generally tend to have ind...more >>

I'm writing a C# app that needs access to a remote SQL database. The issue is that I don't want users of the app to have directly access to the database because of security reasons. I do not have permissions to run any application on the server to write some interface so I don't know what t...more >>

Hey folks. I used to use studio 2005 with my sql databases. HD crashed, and I don't have it anymore. Is there a good program that is free, or relativly inexpensive that I could use?? any help would be appreciated Jeff ...more >>

I've created a new project in SSIS. I've saved the project to c:\DBProjects\DB1 All of the sql files are located in c:\DBProjects\DB1\sprocs When I right click the project name and select to add existing item, I point to the sprocs folder and add one sql file. When I look at the fold...more >>

I have an SQL database table that I need to perform some updates on. What I am trying to do is update one field in one table based on the information found in another table. I can run the query in Access, but I need to do this in SQL Server so that I can schedule it, either in a stored proce...more >>

I setup up an SQLExpress instance on a dedicated server. I configured the surface area to allow TCP remote connection. But I just can't connection from my laptop over the internet. I use IP address + INSTANCE as server name (like 123.123.123.123\SQLEXPRESS) and use sa account always get th...more >>

Dear all, I found SQL Server (either 2000 or 2005) Backup & Restore functions have a great problem Windows 2003 : They can't see shared network drives ! For example, a server machine has C:, D:, E: local drives and a F network drive mapping to another machine. In Windows 2003 File Explore...more >>

We're developing an app that will have multiple remote client servers, receiving a subscription from a central SQL2005 box. Our Sysadmin is saying we must use Vista on the remote, because we won't be finishing development for at least 6-8 months and Vista is what we'll get on the new hardware...more >>

I tried to migrate a SQL Server 2000 DB to Sql Server 2005. I am using SQL SERVER 2005 Express Migration Tools, however it seems the express version does not support DTS. My websites are on a shared server administered by my ISP. Is there a seperate download for the Management Tools (not Exp...more >>

Hi all, I have an existing server that I wish to replace with new hardware. What I would like to do is to take backups, move them to the new server, take the old server offline and rename the new server to match the old server's name. I've read this article (http://msdn2.microsoft.com/en...more >>

Publisher/Distributor: Windows 2000 SP4 SQL Server 2005 Standard Edition SP2 Subscribers: Windows XP Tablet Edition SP2 SQL Express 2005 SP2 - on clients Replication topology: Merge replication with client subscriptions Most articles replicate both ways but we have a few ...more >>