• Sticker giveaway: Ask a great question, receive a free IT Knowledge Exchange sticker

    We've recently received some spanking new IT Knowledge Exchange stickers and we'd like to send them to you, our steadfast question-askers. The rules are simple: Ask a question in the community, then send me an e-mail with: Link to the questionYour preferred mailing address We'll mail you a free IT...

    JennyMack4,280 pointsBadges:
  • Is it possible on iSeries that an index is defined keeping in mind an sql select criteriea however when the queryis run this index does not get used.

    Is it possible on i series that an index is defined keeping in mind an sql select criteriea however when the queryis run this index does not get used. We had an issue wherein an entire library had to be cleared and all files from had to be restored from a previous backup, after the backup was...

    JohnsonMumbai1,160 pointsBadges:
  • Sample Test Data from Production in SQL Server 2008

    Is there a data generation tool that can populate tables in a test database with a percentage of actual data from a production database? For example, to extract data based for a date range from a specific table, and all related tables to be populated based on the corresponding related referenctail...

    Teguma15 pointsBadges:
  • Hibernate with clob type

    I am using clob of oracle 10 g in hibernate. When i tried to insert 5000lines of HTML code to the variable in jave, i am getting the following error; Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.citi.gicap.bpm.ver.domain.Notes];...

    Arunpmk5 pointsBadges:
  • SQL servers merge transactions

    In vb.net windows application,i used sql server 2008 for database. For deployemnt and implementation process, we used currently the sql server is in the web.client have different locations and want to access application from any where. The problem is at some rural area the internet down time is...

    Qqqqqqqqqqqqqqqqqqqq20 pointsBadges:
  • Two SQL server synchronization

    How can I merge two SQL Server databases? One sql server is in web  and another in local machine  both sql servers will have daily data transactions entries. how to merge those daily data transactions between the two sql server?  i am new to sql synchronization and merging. could you kind...

    Qqqqqqqqqqqqqqqqqqqq20 pointsBadges:
  • SQL Server 2005 with SAN storage problem

    i have a very strange problem: - i have an  windows 2003 server - a SAN storage attached to that server - i installed SQL server 2005 proffesional into the server - database files in the san storage - when i attach the database into the san storage it gives an error that it cann't see the drive E...

    Masterofpcs5 pointsBadges:
  • SOLAP in SQL 2008R2

    IS there SPATIAL OLAP implementation in SQL 2008R2

    JiriJ5 pointsBadges:
  • SQL I/O Best Practice

    I just inherited a SQL SERVER 2005 32-bit attached to a SAN Server. I want to use SQLIO for performance testing and stress testing. The database is in production. Would it be a good idea to run SQLIO on a production sql server during non-work hours?

    Rick Martinez585 pointsBadges:
  • Value of() in SQL Server?

    what is the equivalent statement of valueof() of oracle in sql server?

    Prcvjr220 pointsBadges:
  • Create QA database with only some production tables

    I have a large database with some tables that have largely static data. I need to make a new database on a different server with the same table structure with the static data tables intact (keys, etc.). The other tables must be empty. They're all in the same filegroup in the original database. I've...

    Rwaltz5 pointsBadges:
  • Adding New Parameter to a existing Crystal reports 9.5

    I have a exsiting crystal rpt that passes 5 parameters to a stored proc.  We have added 1 more parameter to the procedure now when attempting to run the crystal rpt it errors out with proc expects parameter "new" (new being the added parameter).   I have been unable to get around this. Can...

    Ftrucks015 pointsBadges:
  • What are the best tools for SQL monitoring and SQL diagrams?

    we have SQL 2008, and looking for tools to monitor sql and get sql diagrams. do you know any good tools?

    Persa5 pointsBadges:
  • Access or SQL Server tables

    Yes I am consultant for a small business, and currently they have a Access database that works pretty decently. At the current situation, the owner needs another database. I really do not want to have to ask the developer to keep creating different databases that includes him having to put more...

    Imjnice15 pointsBadges:
  • Exchange Server auto-reply setup

    We have an exchange server that has been servicing records as follows: user1@alpha.company.com is an alias for user1@bravo.company.com. All mail destined for alpha is forwarded to bravo e-mail address. We now need to only use the @bravo.company.com e-mail and set up an auto reply on the...

    FlyNavy0 pointsBadges:
  • Using a variable in the LABEL ON SQL statement

    Is it possible to use a variable in the label-string of the LABEL ON sql statement so that the variable can be changed dynamically in an SQLRPGLE program ?

    aderene180 pointsBadges:
  • Find missing numbers with SQL

    In a large logfile I have records containing the field INVNO (invoice-number). The lowest and highest values are easy to find, BUT it looks like some numbers in between are not there. Anyone got a trick with SQL, which can tell which numbers are missing within the numberrange (step 1) ?

    DanTheDane2,555 pointsBadges:
  • How to create data security in SQL server 2005 so that the code will not be opened

    how to create data security in sql server 2005 so that the code will not be opened

    Gkhlhlhjhhghgg15 pointsBadges:
  • Recovering lost SQL Server 2000 data

    I lost a LDF file for SQL server 2000 -- but I have the MDF. How can I recover my data?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I use SQL codes in delphy7?

    I am going to use the sql code below in a query in delphy7 SELECT     left(edit1.text, 5)+'0 ' FROM        edit.text2

    Ramin5 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