• New user permission to SQL server

    Hi all, I have created a new local user on the sql server. Now when i access the sql enterprise server, it fails and gives error as " login failed to user, check SQL registration properties. Thank you.

    Mutallib5 pointsBadges:
  • Alternatives to ODBC

    Our db group wants to remove ODBC access. My application relies on ODBC to get data. What are the alternatives?

    Chany25 pointsBadges:
  • rpg sql concat

    Our database was designed with separate fields for cc, yy, mm and dd. I'd like to know if and how these fields can be combined into one field then order by on that field. Is this possible? I would need to know the syntax also. If this is not possible, then is there a another way to order by...

    mcg15 pointsBadges:
  • Truncate or not Truncate SQL

    What are the pros/cons of truncate a table export/import to just drop table?

    Jay Dog5 pointsBadges:
  • What more do I need to do to get instant client working with IIS?

    I have installed instant client on my XP computer and am able to connect to a remote Oracle 10g server with SQL plus using this string: sqlplus myid/mypassword@//server:port/svc I have also been able to make a DSN file that connects, and have been able to connect with Visual Basic. I HAVE NOT been...

    OracleATE190 pointsBadges:
  • MySql Query

    Hi Gurus i have a problem in MYSql Query Browwser there is a table "jiuser" in "jasperserver" database. this table has a column "username". there is another table " jiresourcefolder" in the "jasperserver" database. this table has a column "uri". now i wana find out which user can access which uri....

    Abhi Here20 pointsBadges:
  • Are there any issues with setting up SQL Server 2005 log shipping with TDP & TSM?

    Are there any issues with setting up SQL Server 2005 log shipping with TDP & TSM?

    SQL Server Ask the Experts2,585 pointsBadges:
  • DATETIME calculation

    Hi there, this is probably very simple but i just can't get it working. I want to subtract one month from a variable month. So if the datetime variable is equal to 10 Feb 2008 the result should be 10 Jan 2008. Please help. Thanks

    Barend IT15 pointsBadges:
  • list sales by year

    You are to generate a set of sales reports using the tables above. 1) Build a rpeort of sales by year (you can use order total colum) 2) Expand this to include the employee name of the sales rep so now you will show sales by rep by year 3) Also get the sale reps job descriptio and see what type of...

    Kkd7775 pointsBadges:
  • Converting from 2000 to 2005

    I was given an existing application/database with stored procedures to work on. The existing database is in 2000 however the manager would like it converted to 2005 (she thought it already was a 2005 database). My system is only configured for 2005 so my analysis tools are not working on the...

    GUI Girl5 pointsBadges:
  • Duplicate Spatial Data

    I"m looking for some help on how to find duplicate geometry for area, line and point features that are stored in an spatial SDO database. Any help would be greately appreciated. Regards, Sam

    SamAvella30 pointsBadges:
  • SAP HR

    Hi, what are the tables in SAP HR to select the name and salery with sql on oracle

    Wolloc5 pointsBadges:
  • Stored Procedure Problem

    Hi Greg, I am using SQL queries as in-script and now decided to use them as stored procedure. I am facing some problem while converting them into stored procedures. It’s a book search functionality based on book name and author name. My Old SQL query, which I was using with asp. SQL = “Select *...

    Anilak singh5 pointsBadges:
  • HOw to Find Duplicate Geometry in Oracle Spatial

    If anyone knows a SQL statement for Oracle spatial on how to find duplicate geometry for area, line and point features, I would much appreciate it if she\he can share this with me. A million thanks in advance... Regards, Sam

    SamAvella30 pointsBadges:
  • SQL multiple files

    On our iSeries I need to find out if fld01 or fld02 or fld03 in file "C" contains a value that is obtained from file "B" using a value from file "A". How would I do this using SQL?

    Floyd02320 pointsBadges:
  • Using Case Statement Inside SQL Join

    Hi, I am trying to convert dynamic sql into static sql due to permission issue, I faced a challange when i am trying to convert this part of code given below -- join to ADDR_DETAIL SET @join_sql = 'inner join ADDR_DETAIL on ADDR_DETAIL.GRP_CONTACT_ID = pm.GRP_CONTACT_ID AND ' IF (@ChannelEntity =...

    Bmdayal5 pointsBadges:
  • maxdop hint

    I have encountered the bug with MS and the processor issue with Mutlitple processors, the solution is to put the MAXDOP hint. SInce I have never used this and all the MS KB say to use it but not where and how, what is the proper syntax. ( I have a dual processor quad-core new dell)

    tcstl95 pointsBadges:
  • Tagged text in Windows to be inserted into Db2 Clob column on Mainframe

    I have a string-combinatino of rich text and tagged test: ex: "test msg <p><STRONG></P>" on Windows machine. How i can insert data 'AS IS' without any data loss into a Db2 clob column. Db2 is residing on mainframe and we are using Db2 version 8.

    Narayananv5 pointsBadges:
  • Daily trigger in SQL

    I'm trying to create a trigger to execute daily and calculate a few averages for me. Please help!

    Barend IT15 pointsBadges:
  • SQL (Oracle) Date Constraints

    Can someone tell me how to create a constraint to prevent entering a date prior to 1 Jan 2007? I am tryin g to do it in a create script. Thanks Lock

    Lock10 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