• VSS Backup Fails On Servers Running SQL Server 2005

    I have 2 servers running SQL Server 2005. One has Standard and the other has Express. Both are running on Server 2003 w/SP1. Since I installed SQL 2005, Backup Exec (through Remote Agent) has been unable to backup VSS on either computer most of the time, although it's occasionally worked for a day...

    Vurbal0 pointsBadges:
  • VMware ESX 2.5 or 3.0 Virtualizing SQL (2000 or 2005)

    First thanks for weighing in on this.... I support a department whose deployment of several department size SQL 2000 systems needed overhauling. I have recommended virtualizing their SQL because: 1. this is a department level database that has at best moderate use 2. It is currently and comfortably...

    GEdwards0 pointsBadges:
  • Removing a node from a working SQL Server 2005 cluster

    I have Windows Server 2003 with SQL Server 2005 Standard Edition. We have seven divided instances, with each using only two of the three nodes. However, node one has to be taken out of the cluster; what steps should be taken to insure no significant loss in performance?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Update trigger

    I am working in SQL 2005 and need help creating a trigger that will update fields in a record with the user/login and system date after a field in the record is updated.

    Dkrueger40 pointsBadges:
  • SQL Server 64-bit Memory Requirement

    We are replacing an existing SQL Server 2005 32-bit environment with a new SQL Server 2005 64-bit Enterprise High availability environment. The new solution will be a 2-node Microsoft Cluster with SQL Server Cluster Server, all 64-bit Enterprise additions. What I have a problem determining is what...

    ITcar5 pointsBadges:
  • Migrating data from a SQL Server 2005 database to SQL Server 2000

    I am looking for advice on what technology to use to migrate data from a SQL Server 2005 database to SQL Server 2000. We are currently phasing out our old help desk ticketing system in SQL Server 2005 to a new ticketing system in SQL Server 2000. The tables in the databases are not identical...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Linked Server Question

    I am trying to link an existing Access 2003 password protected database to a newly installed SQL Server 2005 Express database engine. I am using the ‘Add Linked Server Access MDB’ template in Management Studio to create the linked server. The linked server is created without error, however when...

    AN5gel675 pointsBadges:
  • SQL SERVER 2000, 2005 & 2008

    Can Sql Server 2000/2005/2008 exist on the same machine

    Sdonthi5 pointsBadges:
  • Storing large data files in SQL Server

    What are the alternatives to store data more than 2 GB in SQL Server 2005 or 2008?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Investigating SQL Server 2005 memory issues

    We have a data warehouse server running SQL Server 2005 Enterprise Edition. Lately, after a restructure, we're seeing some performance hits. If this is due to what was added during that rebuild, we have no problem with it. However, we are not sure. When a query is run, the disk queue fluctuates...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Syncronizing between Distributor and Subscriber in Merge Replication

    HI everybody, i am using merge replication. my concept is that: a publisher publishes a file and then it synchronized with distributor in a schedule (publisher and distributor are in same server). Then Subscriber subscribes (Sync) from (with) distributor not publisher. I want distributor to act as...

    Jah5 pointsBadges:
  • Concatenating two note fields into one, but need them to be on their own line

    sort of like update table set master_note = Note1 + CRLF + Note2. result should be Note1 Note2 I cant find the syntax fir the CRLF part. Any suggestions?

    Macsterling5 pointsBadges:
  • Differences between SQL Server 2005 and SQL Server Express

    How much does it cost to buy SQL Server 2005 Standard or Enterprise Edition, and how do they differ from SQL Server Express Edition?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Upgrading to SQL Server 2005

    I have a question regarding SQL Server upgrades. We have two active/passive clusters on which SQL Server 2000 resides. I want to install SQL Server 2005. How would I go about doing this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • sql server 2005 mirroring

    i have 2 servers, with sql server 2005 standar version, running mirroring, can i see if the data is being updated? how know that? can i make backups while running my mirroring?

    RaulZ5 pointsBadges:
  • Importing SQL Server 2005 tables from one server to another

    My developers want to make a copy of a SQL Server 2005 database from one server to another, but due to company policy, I cannot give them the restore permission. So, as of right now, they are importing each table, one by one, from one server to other. Is there a way to import all of them at once?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Spoolersp.exe Error occuring frequrently in Windows 2003 environment running a VB application.

    We are running a VB Application in Windows 2003 environment. The database Server is SQL 2005. The Application runs in a separate server and the database in another. Remote Users connect to the application through the Remote Desktop facility. Users can go for direct print as well as save to PDF and...

    Ravikswamy35 pointsBadges:
  • Convert SAS to Stored Procedure

    How do I convert a SAS job into a Stored Procedure to run on MS SQL Server 2005?

    VelameLaCosa110 pointsBadges:
  • Restoring a database after migrating from SQL Server 7 to SQL Server 2005

    I am trying to migrate from SQL Server 7 to SQL Server 2005, but when I try to restore the database I get this error: "Processed 120424 pages for database 'COAST', file 'Coast_Data' on file 1. Processed 1 pages for database 'COAST', file 'Coast_Log' on file 1. Converting database 'coast' from...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Figuring out the SA password in order to upgrade to SQL Server 2005

    I am upgrading my firm’s legal software to a version that uses SQL Server 2005. We are on a Windows 2003 Small Business Server, and SQL Server was installed before I started at this firm. My new software needs me to login as the System Administrator. I cannot seem to do that, as I do not know...

    SQL Server Ask the Experts2,585 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following