• How to mark a DTS package as complete even if it errors.

    I want to be able to mark a DTS package as though it completed, even if a particular task within it errors off. In other words, if a task errors off just because a file doesn't exist, I will email myself (which I know how to do) but I want the package to exit and mark it as 'complete'. The reason...

    MISProg5 pointsBadges:
  • PERFORMANCE ISSUE while inserting bulk data in a blank table from 2 different tables

    how to improve insert performance in insert into mis_fcr_all_txns_susp_temp (select * from mis_fcr_all_txns_combi a where exists (select acct_no from mis_fcr_all_txns_fraud3 b where a.acct_no = b.acct_no) and a.TXN_DATE BETWEEN (REPORT_DATE - 60) AND (REPORT_DATE - 30));

    031219805 pointsBadges:
  • Backing up a SQL Server 2005 database on SQL Server 2000 EE

    I have created a large database in SQL Server 2005 Developers Edition, and I intend to put my backup on SQL Server 2000 Enterprise Edition. Is there an easy way to go about this procedure?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2000/2005 Transaction Logs

    Quick Ques. Are transaction logs cummulative? If I have a database set to Full recovery mode; database being backed once a day and transaction logs being backed up hourly, if the database needs to be restored, can I just restore the last transaction log file? Will the last transaction log file...

    JCDBA20 pointsBadges:
  • Writing a query in SQL for use in SQL Server 2005

    I’d like to write a query that would allow me to view items with a characteristic of my choosing and filter out the others. Is it possible to write something like this in SQL and use it in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Linked server error message on a SQL Server 2005 machine

    We are installing a vendor-developed application that requires linked servers between the vendor database’s server and many of our other servers. It has been set up and tested effectively, but it should be noted that it is a double hop to the servers. Server A (which houses the application)...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Archiving a row of data into another database on SQL Server 2005

    I work on SQL Server 2005, and I need to archive a row and its relationship into another database. I know a script could be written to do this, but I would like to know if software exists that could be given the data row and then complete the archiving by itself. Is this possible?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Manually migrating databases from SQL Server 2000 to SQL Server 2005

    I am manually migrating a large number of databases from SQL Server 2000 to SQL Server 2005. What kind of issues should I expect, and do you have any readily available solutions?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Display Multi-Valued Fields In Views

    I have created an expense reports database where the user may enter the customer’s name when entertainment expenses are customer-related. I also have a hidden field where I create a text list of all customers entered (could possibly be 14 different customers). I can display this multi-valued...

    Mglist115 pointsBadges:
  • securing sql server database object

    I connect my access project to sql server. Is there as simple way to secure sql server object such as table, view, stored proc from editing or deletion since access let us to edit sql server object directly

    Ipong40 pointsBadges:
  • How to move a DTS from sql 7 to a server running sql 2005?

    I have several dts packages that are running on a sql 7 server, I need to move them to a server running sql 2005. Any suggestions on how to do this? Thanks

    Bubbanm90 pointsBadges:
  • Common User Interface SQL Serve Management Console

    Does anyone know a way to standardize the SQL Serve Management Console so that all of the DBAs will see the same list of servers as we used to have in the SQL 2000 Enterprise Manager?

    Jerry25 pointsBadges:
  • BCP Utility With Additional “INSERT VALUES” Clause

    I've nested 23 separate BCP commands into a single BAT file. Each BCP command pulls data from a separate text file and inserts the data into a single table. Here's the kicker, when inspecting the newly inserted rows in the table, I need to be able to associate each row with the BCP command that...

    Jdana15 pointsBadges:
  • Impact on TSM backups after an upgrade to SQL Server 2005

    What would the impact be on TSM backups if I undertook a side by side upgrade of SQL Server 2000 SP4 to SQL Server 2005 SP2?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Accessing SQL Server with a Visual Basic application

    I have an application in Visual Basic 6 with SQL Server as the back-end. It is supposed to be run on a server, but it will not access the server when installed and run on a client’s machine. I think it might be a code issue; I have used the following coding at form load: cnh =...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server Upgrade and Server Move

    I have an old Windows 2000 server running SQL 2000 and need to retire the server and move my SQL databases to a new server. The new server is a fresh install of Windows Server 2003 and SQL Server 2005. I am having a hard time finding a procedure for this complex conversion. Is this something that...

    RussGunther5 pointsBadges:
  • Moving SQL 2005 databases with no downtime between servers

    We have 2 SQL 2005 servers and would like to move the database and the logins and passwords from server to server. I ran backup and restored the full database with no recovery mode which allow me to copy the transaction logs then I transfered the logons and ran sp_change_users_login to associate a...

    Theitman25 pointsBadges:
  • Click Through Report in SSRS

    Hi, I have developed a click through report and scheduled it. When I go to History and see the last instance of the Report, the subreport which comes up is the latest one instead of the History instance. Can you please tell me how to get the subreport of the history instance. Thanks in Advance

    MD5 pointsBadges:
  • Read Only Table

    I create a table in sql server 2k5, the script is look like this: CREATE TABLE [dbo].[tb1PmtD]( [PmtDLU] [int] NOT NULL, [PmtDInvLU] [int] NOT NULL, [PmtDAmount] [money] NOT NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[tb1PmtD] WITH NOCHECK ADD CONSTRAINT [tb1Pmttb1PmtD] FOREIGN KEY([PmtDLU])...

    Ipong40 pointsBadges:
  • SQL Database Migration Process

    Hello, I would please like to know if someone could help me out with a database migration issue.I have a server and i need to migrate all of my data on my current database to a new database.It seems that the new database might be a little different in structure and the tables generally so i would...

    Absorbed5 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