• Sql Search

    Hi, I have a Search box on my site at top. Where visitor can enter any keyword. I have Full Text Search enabled on my DB and index the Columns. I have one Columns SalesTitle in one of Table Catalog.Product, which contains almost our required keyword, like ProductNumber, Description, BrandName,...

    Mr. SEA130 pointsBadges:
  • how do I cause a field to be null, using DFU?

    how do I cause a field to be null, using DFU to update/insert a record?

    tegarvey35 pointsBadges:
  • Career change RPG/ILE to ASP.net

    After almost 30 years of RPG (from the old RPG I days) I am making the change to .Net. I felt that ASP.net would offer more of a challenge and reflect more of today's business needs. I am still working for the same company so no real risk in the move. My question is what do you think will be the...

    ToddN200011,820 pointsBadges:
  • Remote Connection to SQL 2005 Express running on Windows 7

    I have a Windows 7 machine running SQL 2005 Express. I am able to connect to the SQL from the local machine. However, I am not able to connect from other machines. This machine will connect to a SQL 2005 running on Windows XP but the Windows XP will not connect to the Windows 7 SQL. I have ensured...

    Goofy90 pointsBadges:
  • Query timeout expired – State:S1T00,Native:0,Origin:[Microsoft][SQL Server Native Client 10.0] on production server

    Hello, I am getting the below error on customer production error, Query timeout expired - State:S1T00,Native:0,Origin:[Microsoft][SQL Server Native Client 10.0] The queries are forming on the fly using MFC's record sets. if I try to run that queries on SSMS directly I am not getting that error. How...

    Narasimhulu10 pointsBadges:
  • java

    i need to include N number names into the database from single textbox at the run time of the program using java

    SABARISHJAGANATHAN15 pointsBadges:
  • Trigger Perormance Issues when Journalling Started

    I have an external trigger program (RPGIV) that is added to about 50 files. Its task is to store record images upon insert, delete, update in any of the 50 files. It stores the images in another file (the monitor file) which also contains an identity field (generated always as identity). All files,...

    FrankWM110 pointsBadges:
  • 2003 Sever Domain Issue

    Currently my customers running a Windows 2003 server with 2005 SQL and a Active Server.We just put a 20 meg Fiber service into the Office. The issue we are having is it will still take 1-3 mins to load a web page. The DHCP on the router has been placed inactive for a block of IP and the Server has...

    greatjubee165 pointsBadges:
  • Internet Connection Battle in windows 2003 Server.

    My customer currently is using a Windows 2003 server with 2005 SQL server, and an active directory in place. The server is set to do DHCP and DNS on the LAN. We have a Cbeyond Cisco Fiber router recently installed. All workstations are set to Static IP address same Sub net with Default Gateway...

    greatjubee165 pointsBadges:
  • Restore SharePoint 2003 database/s on SQL Server 2005

    I am not sure if this should be addressed by the SQL Server group or SharePoint Server group. Since I am more familiar with SQL Server than SharePoint I started here. We have SharePoint Server 2003 installed on Windows 2003 server running SQL Server 2005. We have been backing up daily, two of the...

    TLMercer45 pointsBadges:
  • Recursive CTE With UNION gives error

    why can’t we use , just “UNION” instead of “UNION ALL” in the recursive CTE’s. If I use just UNION in the recursive CTE it is throwing error. Can you please help me out? Example, CREATE TABLE te (sno int) Go INSERT INTO te VALUES (1),(4),(10) Go ;WITH ctemax(maxsno,minsno) AS (SELECT...

    RecursiveCTE15 pointsBadges:
  • Restore SQL Server 2008 database backup error specified cast is not valid

    Received a SQL Serer 2008 database backup newdatabase.bak from a site in UK and attempted to restore it onto my server in USA. Receive error . I assume this is a Server Collation difference issue. Can anyone help me overcome this so that I may be able to restore this backup on my SQL Server 2008...

    TLMercer45 pointsBadges:
  • How to retrieve tables?

    My SQL Server 2005 database get corrupted because of a virus infection. No tables are showing now. My database folder contains .mdf, .ldf and file (3 files) can I retrieve my tables using one of this. Any solution please? I don't have any other backups. Please get a solution.

    DatabaseRecovery35 pointsBadges:
  • Database Recreate

    My SQL server 2000 Database is corrupted because of a virus infection. No tables are showing now. My database folder contains .mdf, .ldf and file (3 files) can I retrieve my tables using one of this. Any solution please? I don't have any other backups. Please get a solution.

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

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