• Filter SQL Replication Deletes by user

    I am in the process of setting up replication from sql 2008r2 to Oracle 11. I have one requirement that is giving me some issues. My sql db is the publisher and currently maintains data from year 1. The Oracle subscriber will maintain 7 years data. After the initial snapshot the sql db will only...

    john26025 pointsBadges:
  • Select Statement & Where Clause ….

    On an ASP web page there is a Text Box with default Values for different records. The records are stored in a SQL2008 table called dbo.SOFTWARE and have been type in manually over time and contains many duplicates. The field is called 'BUSINESS_UNIT'. On the same page i have created a Combo Box...

    JKJK45 pointsBadges:
  • Image capture and store into Sql Server 2005 code in vb 6

    how to store image in Sql Server 2005 by using visual basic 6

    nishantganapa0 pointsBadges:
  • collation discrepancy issue

    how to fix the collation discrepancy issue while upgrading an application. In mssql 2005 database server, tried to create a database with windows authentication and manually provided sql authentication and ran three queries ALTER DATABASE djbadmin SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER...

    Tigerravi5 pointsBadges:
  • Recovering a truncated table on a SQL Server

    How can I recover a truncated table on a SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Binary Math windows server 2008 sql server 2008 r2

    Operating System: Windows 2008 2 Database: SQL Server 2008 Enterprise R2 issue: I am trying to creat a binary matrix that manages user permissions. My largest number at present is 135069719 the binary representation is : 101001001110000101001 The largest number I eventually have to handle is a 20...

    m768535 pointsBadges:
  • New member contest: ASK, Answer and Win a $50 Amazon gift card

    As 2008 winds to a close, IT Knowledge Exchange has one more fun contest to end the year. From today until December 23rd, you can enter to win one of ten $50 (US) Amazon.com gift cards. There are two things, however, that you must do in order to enter: 1. Ask 2 questions 2. Answer 2 questions...

    ITKE350,195 pointsBadges:
  • File server

    I have a server 2008 R2 that while in Explorer on the left navigation pane show "Network" and under that a list of workgroup computers (it’s a file server) I have one computer in that network thats name is blue and underlined. Is there significance to this?

    Thenmen5 pointsBadges:
  • Soon you can redeem knowledge points for Amazon.com gift cards

    Yes we are coming up knowledge points and will be announcing the ability to redeem all the points you have earned thru december this year for amazon.com gift cards. Next week we will be sending out an email with all the details but it should be fun to see who ends up asking and answering to beef up...

    ITKE350,195 pointsBadges:
  • SQL server

    i want to copy  the store peocedure from one database to another . iam using sql2005

    Pannudeshmukh0 pointsBadges:
  • SQL server backup sqlvdi.dll not loaded into SQL memory

    We have receiving SQLVDI.dll error when we try to take the SQL backup on EMC Networker.We checked the sqlvdi status as suggested in http://archive.msdn.microsoft.com/sqlbackupsim . But we have the status in simulator that [em]"VDI dll not loaded into SQL Memory yet" .[/em]We register the vdi dll...

    asenthil175 pointsBadges:
  • CL/QMQRY

    i hav code   STRQMQRY QMQRY(SQLPROC) OUTPUT(*OUTFILE) + OUTFILE(QTEMP/SQLDT)   In SQLProc txt file i am callin a sql procedure , developed using i series navigator and return data set using cursor. i want this cursor output in qtemp/sqldt file. in sqlproc if i mentioned SELECT statment , then it...

    Sanashakeel15 pointsBadges:
  • Recovering .mdf and .ldf files from SQL Server

    I backed-up our SQL Server yesterday around noon, and we then added more data in. Today, when we tried to start our application, we found that the database is in SUSPEND mode. We stopped our SQL services and tried to copy the newer data, but there was a data error. It seems that our .mdf file is...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Crystal 8.5 export trouble

    My Application is developed in Vb6,Sqlserver2003 and crystal report 8.5.this application is well run on windows XP,Server2003 etc. but now we are Shift our OS to Server 2008 R2 32 bit. application running well but when I trying to export reprot(i.e click on export button of the crystal report)...

    Sam45 pointsBadges:
  • SQL Query

    how to select only those table name from database that have a two field in table like PID amd EID table that have PID also have a EID in a single table those table i want to select

    SDN15 pointsBadges:
  • Getting SQLCODE -518, while running EXECUTE Statement after PREPARE Statement in COBOL

    I am executing a dynamic SELECT query (No CURSOR- Normal SELECT) WS-STRING - SELECT MEMBNO FROM ENBMAS WHERE MEMBNO = "3535"  EXEC SQL                                     PREPARE SQLSELX FROM :WS-STRING...

    COBOL400Praveen30 pointsBadges:
  • Recovering the MySQL database

    In the process of editing my database, I accidentally deleted the MySQL database. I thought I recovered it, but when I opened MySQL Query Browser, it was not there. Is there an easy way to recover it for good?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error on Transaction log Backups

    Getting error -1073548784, when trying to run a backup of transactions logs ( SQL SERVER 2008, STD ed). Can anyone help?  

    SQLGUMBO5 pointsBadges:
  • Scrip an select from linked Oracle database in Management studio gives multiply fields

    In SQL Server 2008 R2 Management studio under Linked servers I want to script a select from an Oracle database table. The result is that many of the fields occur three times. What can the reason for that be? See this example: SELECT [RATETYPE],[RATETYPE],[RATETYPE]            ...

    AnnaLena5 pointsBadges:
  • Changed Foxpro 2.6 .dbf file and change doesn’t show up when I run the .exe

    Hi, I am hoping I am posting this in the correct forum. I work for a company that is running a simple tickets database program to track who uses what sports tickets. There is a .exe file and a few .dbf files, etc. About 10 files in a folder to run this Tickets program from Dos FoxPro 2.6 version....

    Djr6004135 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