• SQL Server 2016 error: Fail to retrieve data for this request

    SQL Server Setup has encountered the following error: fail to retrieve data for this request. Please help me. Thanks all.

    Hvphong031175 pointsBadges:
  • Info from .bak in SQL Server 2005

    I have a 6GB .bak file that, when check it in the file to use for restore, the file shows 'Incomplete'. I need to extract the .mdf part of the .bak file since I don't need the .log file. There should be some way to do this or some tool out there that will either repair the .bak file so it doesn't...

    aragao45 pointsBadges:
  • Data masking for iSeries and SQL server

    My team is searching for a data masking solution that would work for both iSeries IBM DB2 and SQL Server. Any recommendations of vendors?

    DaneTestManagement5 pointsBadges:
  • Restoring Database

    I accidentally deleted contents of a table and is now trying to recover the deleted rows.  I do not have a backup (how stupid of me).  I do have a .mdf file, however I believe i copied that file while SQL Server 2005 was running.  Is there anyway to recover this deleted data?

    Tyecom5 pointsBadges:
  • Design stored procedure with clause

    I have a rather large stored procedure to develop. The procedure is going to be used in a large crystal report. I was wondering if you can design a stored procedure using a with clause. I used CTE on SQL Server but that doesn't seem to be an option.

    jvichich5 pointsBadges:
  • Visual FoxPro Remote view

    Currently I'm doing SQL migration through remote view to my new product. In this, how to handle the following case. Single application will be access by each user and SQL DB in common server. Remote view [dbc] also common to all users. When one user add one record to a master table, how the changes...

    actramesh0015 pointsBadges:
  • How to connect my application using Visual Studio 2005 to a SQL Server database?

    how to connect my application using visual studio 2005 to a database using sql server?

    MissVeryLittleKnowledge5 pointsBadges:
  • Query for trigger in SQL Plus

    How can I define a trigger that will fired to calculate gpa at run time before the insertion of record into table?

    khan15053330 pointsBadges:
  • Trigger

    What is the use of the trigger?

    swamy00725 pointsBadges:
  • Building quiz application using ASP.NET/VB.NET and SQL Server

    Hello masters, How are you all doing? I just have a question. I am building this simple quiz application using ASP.NET/VB.NET and SQL Server for the database. Now what I want to happen is that when I click on submit button, it will count all the correct answers of the user based on the radio button...

    shawnturner10 pointsBadges:
  • Link to a MDF database

    So I created a MS SQL db , but now I cannot link to it. I would like to create a database in my C:/Cfusion/wwroot folder and not in ProgramFiles/MicsoSQL/Data folder. Is that possible? How? I cannot create a new database in anywhere but ProgramFiles/MicsoSQL/Data folder. Now I have an MDF in...

    BjornPorgilsson5 pointsBadges:
  • How to import Microsoft Excel data into existing SQL Server table

    We have a SQL Server table that currently has data in it. Can we import more Microsoft Excel data into this existing table? We already tried using the export wizard but we got a ton of errors.

    ITKE1,047,345 pointsBadges:
  • Moving SQL Server instances from one data center to another

    Hi, I am working on to find some workaround for moving SQL Server 2005/2008 instances from one data center to another data center without changing database configuration setting at application end because application team is not sure what all places server name and database name is hardcoded. I...

    avsPrasad2615 pointsBadges:
  • SQL Server

    What is a tempDB in SQL Server?

    Sai5 pointsBadges:
  • SQL Server Replication – Error 22022

    We have setup a database in one domain that needs to be replicated to another domain. we have a Metro E connection are able to access data from both databases. We have established the same username and password within SQL and AD for both domains. We have setup a publisher on Domain A but cannot get...

    cmessinger5 pointsBadges:
  • Active Directory group has permissions to SQL Server database

    We currently have a SQL Server database and also have a Active Directory account. The AD shouldn't have access to the database but it does. This account has several members with different permissions. Is there a way to find out which group has access to the database?

    ITKE1,047,345 pointsBadges:
  • SQL9010 is: RUNSQLSTM command failed.

    SQL9010 is: RUNSQLSTM command failed.

    Lllooloool5 pointsBadges:
  • Crystal Reports record selection

    I have a SQL view that links my contact table to my address table. In the view there is a field signifying "address_type". It could be mailing, location, business, home etc. When I run the query I get three records for this contact because they have mailing, location and business addresses. Is...

    DQuint5 pointsBadges:
  • Alternative to SQL Cross apply because of performance issues

    I am stuck in a bit rut. I have an XML and in SQL Server. I want to get all the values of FBC separated by commas. Name of the table is Table1 Name of the column in which XML is stored is FareDetails BookingID and ID are other columns of Table 1. SELECT (PTSD.PSTDNode.value('(FBC)[1]',...

    prakharrulzz5 pointsBadges:
  • Is it possible using Embedded SQL or something else in RPG to directly update and MS SQL DB

    I have a need to push data from the AS/400 to an SQL DB on an SQL 2008 server. I was wondering if there was a way to do this natively within RPG on the AS/400 without purchasing something. Was thinking embedded SQL or stored procedures might be able to accomplish this. Has anyone done this?

    Minidach15 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.

Thanks! We'll email you when relevant content is added and updated.

Following