• Database Tuning Advisor “not permitted” error on SQL Server 2005 DE

    Hi! I've bought the Visual Studio 2005 Professional Edition and with it comes Visual Studio SQL Server 2005 Developers Edition. I've installed it and started developing my applications, but now when I try to tune it with the Database Tuning Advisor I get the error-message: "Tuning this edition of...

    Volrat0 pointsBadges:
  • Users/Roles/Schemas

    I'm trying to find some documentation or procedures that will allow me to xfer existing users' roles, etc from sql2000 to sql2005. When our sql 2005 database was restored on a new server (from sql2000), all of the database users were orphaned. I need to create identical server logins and then make...

    Wsyeager0 pointsBadges:
  • Executing a Function or Procedure from ouside Oracle

    I have verified the code below as a valid Function and it executes from TOAD. It does not work if called from: SELECT F_T_TOTALE_TO_T_SCRAP_SC(V_TIRE_ID_EXTRACT) FROM T_TOTALE The Error is 14551. I have researched this error and it states that a function cannot be executed from a SELECT statement...

    Moonmullins0 pointsBadges:
  • Oracle Parse – Instr

    I'm receiving a string pipe delimited I need to extract the data between pipes until the end of string. How do I do this? I currently have FUNCTION fParseValue (pValueMeters varchar2) return varchar2 is v_meter1 varchar2; begin v_meter1 := instr (pValueMeters, '|', 1, 1); v_meter2 := instr...

    Dava190 pointsBadges:
  • Sending Table Data From Oracle 9i To Sql Server 2005 using oracle 9i Trigger

    My aim is to send the data from oracle to sql server 2005 whenever there is data insertion, deletion or updation in the oracle table the same change needs to happen in the sql server having the same table structure as oracle.But I am not finding any way to accomplish this task.please help me. Have...

    Dhirendra100 pointsBadges:
  • MS SQL Server 2000

    Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?

    Sudh2k0 pointsBadges:
  • Subquery returned more than 1 value.

    I've got a SP that has the following line of code: SET @totalLateRecords = (SELECT COUNT(*) FROM tableName WHERE tableName.fieldName <= 61)) I get the error "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery...

    Bbonsall0 pointsBadges:
  • Urgent Help: web-Forms 6i don’t work after Upgrading the db from 8i to 10g

    Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server C....

    1081080 pointsBadges:
  • ODBC connections

    We have a database that is specifically designed for our industry. We want to be able to export the information into a mailing list. This is the email that I received from IT. "You cannot export to an access database, but you can connect to the KIDS database with Access or with Excel query to...

    Jade057110 pointsBadges:
  • VB.Net of Visual Studio.Net 2003 VS Visual Basic 2005 Express Edition

    Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and drag a table listed in the Server Explorer from a connected database to the form. This will add OleDbConnection control and OleDbDataAdapter control to the...

    Hunkgym5 pointsBadges:
  • Problems with underscore column names quering

    Hi I am having problems working with the PL/SQL, the thing is that I installed the oracle db 10g software wich i downloaded from the Oracle Site, now i am testing some queries, I have a table called GRP_GROUPS wich has some fields like ID, and GRP_Name, when i try to do a select like this: SELECT...

    Opereira0 pointsBadges:
  • Simple but not so

    I have 2 table 1) Product_Inf and 2) Product_attribute_details I have prod_key, dye_class, prod_range in both the table. Their is no relation exist between both the table than how can i find the records available in Product_Inf but not in Product_attribute_details?

    Ilink880 pointsBadges:
  • create table (record capacity, or Size)

    When using CRTPF we also use SIZE. Example: CRTPF FILE(MYLIB/NEWFILE) SIZE(10000 1000 9) I searched for the same possibility via SQL but can?t find it. Is there a way with a SQL statement 'CREATE TABLE' to do the same?

    Cenens0 pointsBadges:
  • Which is Better ? Filter condition in JOIN clause (OR) in WHERE clause ?

    We have an option to filter a result set of a select Query using a filter condition either in the WHERE clause (or) JOIN clause. Let us consider an example: ex1: SELECT * FROM TABLE1 INNER JOIN TABLE2 ON TABLE1.COLUMN1 = TABLE2.COLUMN2 AND TABLE1.COLUMN3 = 'N' AND TABLE2.COLUMN4 <> 'N' The...

    Shanmu19840 pointsBadges:
  • Trigger or something like that for Select sentence

    I need a trigger or something which will be launch when i open a table with a "select" sentence...i know that triggers per se only work with "update, insert or delete" (ddl or dml) but i want to know if i can do something that works like a trigger but only when i do a "select" command...i know also...

    JorgeVergara0 pointsBadges:
  • please solve this query

    Create Emp table containing an Empno column with the following sample data:- EMP ------- EMPNO ----------- 1 5 9 14 20 25 Write a SELECT statement to display the range of missing numbers. Your output should be as follows:- MISSING ------------ 2 ?- 4 6 ?-8 10 ?- 13 15 ?- 19 21 ?- 24 Don?t assume...

    Sairam170 pointsBadges:
  • Problem finding a column name.

    The following SQL is giving me the message: Server: Msg 207, Level 16, State 3, Line 1 Invalid column name 'ProductCode'. How can I correct this code. The column name does exist in the table. I also want to group by Product Code and not by Container Name. Thank you. SELECT a.ProductCode AS "Product...

    Captnskirk0 pointsBadges:
  • Visual Basic

    What is the difference between VBA and Visual Basic.Net...I want to learn how to write scripts to automate certain tasks.

    Idapsdst0 pointsBadges:
  • WITH clause not working.

    This is the first time I'm using the WITH clause, and am getting "missing expression". I am rewriting a MUCH larger query, so much of the code below that seems extraneous is needed for the pieces that aren't in there yet. Can anyone tell me what needs to be changed to make this work? WITH test AS (...

    Source0 pointsBadges:
  • Backup

    Hi Guys How can i backup data base and the accounts settings in MS SQL Thanks in advance

    Ajolis0 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