• Crystal Record selection

    I need to eliminate duplicate records by comparing two fields, if the data is the same, I only want it to appear once. "Select Distinct" report option compares the complete record. Please help

    Srustemeyer5 pointsBadges:
  • DTS

    Posted - 10/28/2008 : 18:52:31 -------------------------------------------------------------------------------- I am trying to schedule a DTS package . But its says nothing, no error displays and finally it does not execute and hence a job is not created . But when I execute it immediately it is...

    Metro1725 pointsBadges:
  • ORACLE DBMS vs. SQL sever DBMS

    What are some key differences between Oracle DBMS versus an SQL server DBMS? Also, What are factors that would make someone want to use an Oracle DBMS versus an SQL server DBMS?

    Ryzawack15 pointsBadges:
  • SQL Server 2005 vs SQL Server 2008

    When comparing SQL server 2005 to 2008, does 2008 hold more data, or is it just an upgrade on what you are able to do with the data?

    Ryzawack15 pointsBadges:
  • Problems from reindexing tables every day on a SQL Server

    We have a daily job running to reindex all the tables for all the databases on our SQL Server. If I reindex selective reporting tables everyday, take a transaction log backup right after reindexing and check if the transaction log is greater than 1GB, I think I should invoke a stored procedure to...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Upgrade SQL Server 2005 32-bit version to 64-bit Version

    Is it possible to upgrade SQL Server 2005 32-bit version to 64-bit Version?

    Reillyjj10 pointsBadges:
  • SQL server 2005 Expr Adv services – installing SP2

    Hi folks I have a 64-bit vista ultimate PC with all SP's applied. I have been attemting to upgrade the existing instance of SQL Server Expr to SP2, but it stops installing with an error dialog box saying: SQL BPA command line has stopped working Eventually I end up on a web page containing the...

    Rosspetersen5 pointsBadges:
  • Maintenance Plans SQL Server 2005

    I upgraded to SQL2005, and cannot get any Maintenance Plan to save, via Wizard, or regular creation.

    Ssutton910 pointsBadges:
  • Run scheduled job on SQL Server

    we do integrate SQL SERVER woth Oracle database, and its usually work withour problems. the last two days the intgration is not working and the following error displayed in the job history. Cannot create COM Server to load and execute DTS Package. Error -2147221008 (800401F0): CoInitialize has not...

    Kmadani35 pointsBadges:
  • How to backup a SQL Server on a different Domain.

    We have just upgraded our admin server, which has an SQL database running on it. This server is also on a different domain from the backup server, which is running Backup Exec 12. Has anyone got any ideas on how we can connect to this server from the backup server that is on a different domain ?

    YodaTrueOne20 pointsBadges:
  • Error message during SQL Server backup

    We have a backup command that runs from within a command job on SQL Server A, and extracts data from SQL Servers B, C, D at different times to create a file on a SAN Drive. This is a daily job and runs successfully. Over the last fortnight, we have got the following error once for each different...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error message on a VB.NET created program on SQL Server 2000

    I have developed an order management system program for my company, and I have 20 years using it. However, on a single system, I get an error that is either ‘time out expired’ or ‘max pool size’. I used VB.NET 2005 on SQL Server 2000 to create and use this program. When I restart the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • What type of Raid to use on Windows Servers and tempdbs?

    I have a SQL Server with eight disks, and I am not sure if I should use Raid 10 twice, one for Windows Server 2003 with NDFs and the other for the log file and tempdb, or apply Raid 1 for the Windows Server, Raid 10 for the NDF and MDF, and Raid 1 again for the tempdb and log. What would you...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Memory allocations for SQL and other server processes

    If I am correct, available bytes is the amount of memory available to the SQL Server at that point in time, working set is the amount SQL is actually using and total server memory is the total amount of all memory processes on that server. I have on a 4GB box with 3GB fixed and set aside for SQL:...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Bypassing an error messaging involving SQL Server 2005 Alerts

    I have a question regarding how to monitor a mirrored pair using SQL Server 2005 Alerts. Specifically, the question is on how to send an email to an operator via database mail to notify the operator of an error. The error Event ID is 32042, which occurs when the age of the unsent log exceeds the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Slow performance for a SQL query

    I have a SQL query I am running, but it is experiencing significant slowdown. The main table - has over 1 million records and a unique key of cusID. It has a one to many relationship with the other two tables mentioned. The query code is as follows: Select customer.cusID,customer.VisitDate,...

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

    I need to know if and if so how I can change the name of a flat file input and keep the column information?

    TheCiscoShow5 pointsBadges:
  • Error message while querying a linked server SQL database

    We have two remote servers, both with SQL Server 2000 databases. An ODBC data source was setup on the first server to point to the SQL Server database on the second server. Also, a linked server was setup on the first server between the SQL Server databases on both server. It was based on the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Updating Microsoft SQL Server tables from Oracle generates error

    i am not able to update table in ms sql2000 from oracle . can u sugegstyour views on this . the error i got is ORA-00904: "NAME": invalid identifier.

    Balecha10 pointsBadges:
  • Rolling back a SQL Server 2005 database while retaining data added

    I have a database that has been running for about six months in SQL Server 2005 on 64-bit Windows Server 2003. There are no backups, but recovery mode is set to full and I have never deleted the log file. I need to rollback to a recent point in time while also retaining data added since that point...

    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