• i want to develop a s/w in java and back end as sql server

    i want to develop a s/w in java and back end as sql server , what are the form creation menu bar program

    Paulgeo845 pointsBadges:
  • I need to replace a word in a Document through SQL Server 2008

    Hello  i'm using SQL 08 R2 to store my resume collection , i want Sql to find an Email  in the MS WORD document and replace it with an empty string  so far I've succeeded to find the word using fullTextSearch  this my example for finding the documents that contain an email  SELECT  document...

    Shayguri15 pointsBadges:
  • Email Notification If Scheduled Task In Windows Fails

    Hi All, I have scheduled an archiving process using the Scheduled Tasks in windows (2000 server). The task is running fine as per the schedule. But everyday I have to manually check whether it went fine or not. Is there any way by which I can send an email notification if the scheduled task fails...

    Bakash0 pointsBadges:
  • Execute trigger only on update of selected fields

    We have created some trigger programs in COBOL that should be executed only if certain fields change. When creating a SQL-After trigger and -program on a file I can specify that the trigger should run only when specified fields are updated by using: AFTER UPDATE OF {fields} ON {file}. Unfotunately...

    r.otto810 pointsBadges:
  • Backup solutions for VMware environment

    We've added VMware servers to our data center, and we're looking for a backup solution that works. There will be a mix of ESX 4.0 and ESX 3.5 hosts along with vCenter 4.0 with a mix of Windows Server 2003, Windows Server 2008, Red Hat 4.x and 5.x, SQL Server 2005 and Oracle database. TSM is...

    ITKE347,980 pointsBadges:
  • Migrating stored procedures from SQL Server 2000 to 2005

    after migrating store procedures from 2000 to 2005 sql server, how we can check the store procedures are migrated correctly without executing them?

    Parveshkaur5 pointsBadges:
  • Recursive Association with compound primary key in SQL database

    Hello, I'm afraid I'm very new to this and really struggling. I have a table with a compound primary key composing of Code, Date, Client to represent an attendee on a course. I need to include a 'Lead Client' column to represent a recursive relationship where one attendee can be nominated to lead...

    Littlegreen15 pointsBadges:
  • T-SQL Programming Tutorials

    I am looking for a website that is free and where I can learn to write better T-SQL views and stored procedures.  Also, would like to find some good books to learn more about managing a SQL 2005 database.

    Luby10 pointsBadges:
  • SQL Server 2005 query

    Hello sir I am new to sqlserver when retriving data like name gender sal deptno df F 100.00 10 mf M 1100.00 10 if M 1010.00 10 uf M 1000.00 20 yf F 1200.00 20 gf F 1030.00 20 hf M 1005.00 30 ff F 1040.00 30 from this i want retrive deptno maletotal sal female total sa 10 2110 100 20 1000 2230 30...

    Udaya5 pointsBadges:
  • Full and differential backup size same in SQL Server

    Hi, Sub:Full and differential backup size same. I am facing the following problem on production server,I am getting the full backup(600MB) and differential backup size(598MB).On off peak hours I have taken full backup and just after a min I have taken differential backup but the sizes of both...

    Abdulsamad20 pointsBadges:
  • SQL Server Plan Cache

    There is a bucket in plan cache with 75 objects in it and it is the same sql statement. Other than using DBCC FREEPROCCACHE what will clear out the cache? Restarting SQL SERVER Service? I use the code below to look up how many plans are in a bucket. SELECT   bucketid,   entries_in_bucket =...

    Rick Martinez585 pointsBadges:
  • Copy high volume of data between AS/400

    Neeed copy big file between iseries faster, this moment the requerided is 2 days? Need your coments to do the transfer more quicKly

    CRAMIREZ25 pointsBadges:
  • 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:

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