• 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:
  • Date Parameters in SSRS – showing total by day as well as by total by parameter chosen

    I have a date range parameter set up in SSRS. I need to show the total for each day chosen in the data range parameter as well as the grand total of the entire filtered selection. Is this possible?

    Ericamorrison5 pointsBadges:
  • SQL Server 2008 compression experiences?

    We are about to migrate a database from SS2005 32-bit to 2008 64-bit. One of the biggest drivers for this is the compression capability in SS2008. We expect to shrink our 2TB database down to about 500GB (proven in testing), and get the comparable IO performance improvements (4x faster reads - also...

    Dschwant175 pointsBadges:
  • Data updation issues in a SQL Server table

    I have accidentally updated all data in a SQL Server table according to one data source, and now all my data is a copy of that data. How can I make a command to allow all data in that table to search for other data and update, according to another reference table?

    SQL Server Ask the Experts2,585 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:
  • What are the most overused tech buzzwords for 2008?

    I'm the editor for whatis.com and I'm trying to put together a list of the most overused tech buzzwords for 2009. Can you help? Cloud is #1 on my list (and all its variations). Green will be on the list too. What else belongs on the list?

    Margaret Rouse1,725 pointsBadges:
  • Passing an array into a Stored Procedure

    is there a possibility of passing an array into a Stored procedure i am using java and sqlserver 2000

    Khperi5 pointsBadges:
  • Notes rich text field to BLOB/Memo field in SQL Server using ADOdb

    I have an agent that uses ADODB to connect and insert a row into a SQL Server database. I want to store the contents of the Body field in the memo (rich text) into a Memo field in the SQL Server database (or Blob field). I'm finding examples of reading this kind of data back into a Notes...

    tjarman90 pointsBadges:
  • AS/400 to SQL Server 2008

    Hi, Is there a way to pull an AS/400 File into SQL server 2008? From within SQL 2008 we do not see an ODBC connection that will work for the 400(??) I am not familiar with SQL server and we need to get some data to it. Can anyone shed some light on what I may be missing in regards to the link to...

    Rmason335 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:
  • SSL on SQL 2005 Express

    Hi, I am attempting to encrypt the connection string to/from my database server. I cannot seem to find guidance on where [what directory] to place the CA certificate. I am working with a Windows Form application that call to the data store. Any assistance will be appreciated.

    ETCGMan40 pointsBadges:
  • Migration from SQL Server 2000 to SQL Server 2005

    Hi EveryBody, I am new to SQL SERVER 2005, I have migrated my SQL SERVER 2000 database to SQL SERVER 2005 and it has degraded my site performance. A Page that opens in 10 seconds is now opening in 30 seconds. I have updated the STATISTICS of the database using UPDATE STATISTICS command but no gain....

    Nitin19835 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:
  • SQL divisions

    Hi All, I'm trying to make a calculation through SQL code but this is resulting in a 0. Example: declare @activities as integer declare @days as integer declare @media as float --my queries that extracts data and sets values to @days, @activities; in this case they return @activities=51 and...

    alessandro.panzetta9,725 pointsBadges:
  • Permissions for writing stored procedures in MySQL

    Hi Friends, I have been using navicat to connect MySql5.0 in my local evironment.I connect my java project to MySql database as backend. Now my problem is, I generated an sql script to backup my local database. I run the script in server. Tables were created. But in the case of stored procedure, I...

    Ktrramu5 pointsBadges:
  • Shortening the generation time for a SQL Server 2000 report

    I have 516 different functions in SQL Server 2000 that are used for different calculations. These functions will operate on more than a thousand Microsoft Excel files. Each Excel file has 960 rows, and generating the report took over four hours. Is there a way to shorten this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Pulling rows from SQL Server and loading the data into column textboxes

    I am trying to load data into 13 column textboxes, and I need the ability to pull any number of rows from the SQL Server based on these parameters: control group number, accounting period and posting date. The results will be about 50 lines of transactions, and I want those loaded to textboxes on...

    SQL Server Ask the Experts2,585 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:
  • Transferring a database and writing a database script in SQL Server 2008

    I want to transfer a database from one server to another server using SQL Server 2008, and then I want to write a script which i can update the database daily automatically. How can these be done?

    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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following