• tell me why I’m getting the message “The multi-part identifier “134062-DB1.netFORUMSTaging.dbo.Individual.individualKey” could not be bound”

    I'm trying to process this SQL statement select cxa_cst_key, cxa_key, cxa_key from [134062-DB1].netFORUMSTaging.dbo.Individual LEFT JOIN dbo.co_customer_x_address ON [134062-DB1].netFORUMSTaging.dbo.Individual.individualKey = co_customer_x_address.cxa_cst_key where delete_flag = 0 and source not in...

    Calvin606165 pointsBadges:
  • Copying our disaster recovery database on a SQL Server

    We are using log shipping on our SQL Server as our disaster recovery solution. When we want to test our disaster recovey with a test transaction, not production, we need to use the secondary copy. However, we don't want to stop it and lose consistency between disaster recovery and the production...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2000 backup problem using batch file

    i have written a batch file to backup sql server database and it holds the data of CRE.the batch file is running successfully. but, after running i am unable to login to CRE (cash register express). i doubt if my batch file is corrupting my database please answere me what may be the problem

    Mesunny5 pointsBadges:
  • iSeries to SQL Server via SSIS 2005

    We have multiple DB2 Schema's that are indentical. iSeries tables built using DDS. Looking for a way to use a varible to declare schema vs. having hard coded SQL Statements in SSIS.

    Oldmickey65 pointsBadges:
  • Finding the average of a data type on a SQL Server

    I am trying to figure how to find the average of the data type datetime on my SQL Server. This is my code: SELECT CONVERT(varchar, Tanggal_Produksi, 3) AS Tanggal_Produksi, Target, Actual, Balance, CONVERT(varchar, Waktu_Proses_Awal, 8) AS Waktu_Proses_Awal, CONVERT(varchar, Waktu_Proses_Akhir, 8)...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Upgrading to a 64-bit SQL Server 2005 environment

    We are replacing an existing SQL Server 2005 32-bit environment with a new SQL Server 2005 64-bit Enterprise Edition environment. The new solution will be a 2-node Microsoft Cluster with SQL Server Cluster Server, all 64-bit Enterprise additions. The only issue we are having is determining a good...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Log shipping and replication

    I'm using log shipping for my DR. When I want to test my DR, I need to access my DR database and do my tests (and modify it). My problem is I don't want to stop my log shipping and lose integrity between my prod DB and DR DB. I'm looking for a solution to quickly get a copy of my DR DB to my test...

    Dsicard20 pointsBadges:
  • Preparing a report on a SQL Server database

    I have a SQL Server database of customers that called our company, and now i want to prepare a report that indicates which ones are new to our database. How would I do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Looping Queries in Oracle using data from SQL Server

    I have a table of entries from SQL server called PID. Each of this entry should follow the following select * from HR.TABLES a START WITH a.SID = '0' CONNECT BY PRIOR a.parentid = a.sid' Where I have '0' in the query above, should take all the values from PID. Is there a easy way to write this? or...

    Sreedhar775 pointsBadges:
  • Processing XML files with SQL Server functions

    Hi I read through your tip on Processing XML files with SQL Server functions. It's great but what happens when the XML file exceeds 4000 charcters? I'm using SQL Server 2005 and the XML file that I try and import is too big. Do you have any ideas to how I can use SQL to import an XML file that...

    HughFox105 pointsBadges:
  • Converting data to SQL Server data with the DTS wizard

    I need to convert my Sybase data to SQL Server data. I tried using several methods for a single table that contains 1357 records. When I used the DTS wizard, the tranfer completed sucessfully but the data in the column with data type "money" was not correctly transferred. For an example, the value...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Slowdown in SQL Restore on SQL Server 2000

    We are running SQL Server 2000 on Windows 2000 Server SP4, and our SQL Restore takes at least 10 minutes to launch in Enterprise Manager. We had to roll back after an upgrade, and we find that when selecting "Restore Database", Enterprise Manager runs remarkably slow. I'm sure we could run the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server password issues

    How can I access a SQL Server without a password, how can I change a SQL Server password, and what is an SA on a SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How do I refresh the Stored Procedure used for Crystal Reports datasource

    I have an existing Crystal Report that uses a Stored Procedure as a datasource. The requirements have changed and the Procedure has been updated to have only one parameter instead of two. How do I refresh the Stored Procedure without removing it. I have tried to Verify the Database but just get an...

    Flyght55 pointsBadges:
  • CMPPFM, Space offset error.

    Hello, I'm using the IBM CMPPFM utility for a file comparision process. I monitor for msg SPC5010 (file is too big ), if this occurs I submit an SQL EXCEPT to compare the files. This has been working fine until recently, now I'm getting the following error on one file, Space offset X'00FFF026' or...

    Xtreme1145 pointsBadges:
  • SQL DB MIRRORING ACROSS VPN?

    Can SQL 2005 DB mirroring work if the mirror server is to be in another building (building networks connected via VPN router)? We just want employees to be able to remote into the mirror server from home if power is lost at the main building.

    Kareemr695 pointsBadges:
  • Job permissions in SQL Server Agent

    Hi, I'm using SQL Server Agent which is running on SQL Server 2000. My question is, is there a way to give permissions to users to simply view the jobs and not change/execute them? I've read that this is possible in SQL 2005 with SQLAgentReaderRole, but what about 2000? Thanks in advance.

    Dreadnought30320 pointsBadges:
  • Choosing a version of SQL Server on a laptop with Windows Vista

    What version of SQL Server would run back on a laptop with Windows Vista?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Mapping files into SQL Server databases

    I have used the split function utility in UNIX to split large files into multiple files of small length. However, the time it takes to map these files into my SQL Server databases has been reduced performance-wise but not tremendously well. To load 50 milion records, it is taking seven hours of...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Find out what is in dbms_sql cursor

    I am trying to put in a 5500 character query into dynamic sql, and then use the Oracle dbms_sql function to execute the sql. However, there is an error in the sql statement that is being generated, but the error message doesn't help me identify where the error is, as it pertains to the dynamic sql...

    Darryn765 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