• Crystal Report using SQL 2005 Stored Procedure with DateTime Data type variable

    I want my Crystal Report parameter calendar pick to display date only

    LrdByron5 pointsBadges:
  • Security Awareness training for FTI

    I am responsible for the Security Awareness program and I’m trying to put together my IRS Security Awareness training. I work for a government agency and we have to have annual training for security FTI (federal tax information) data, which is required by the IRS. I am looking for a video that we...

    mizblue10 pointsBadges:
  • SQL table connectivity via odc

    Can a user create a Microsoft .odc file from a SQL database (eg Visual Manufacturing, Dynamics, etc.) without a special tool? Looking to design refreshable Excel reports.

    tswanson3005 pointsBadges:
  • SQL Server 2005 on Windows 2008 64 bit SP2. Installation issue

    I have tried to install SQL Server 2005 on Windows 2008 64 bit SP2. I have installed SQL server 2005 and SQL server 2005 SP2, however only the SQL Server 2005 configuration tools appear. (Everything was selected to install) I have found these posts which have the same issue, but they are for web...

    Jabba12310 pointsBadges:
  • 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...

    ToddN200013,310 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:

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