• 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:
  • 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:
  • 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,011,390 pointsBadges:
  • Deleted Microsoft SQL Server 2005 compact edition

    How do I recover it from the recycle bin?

    viviene35 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,011,390 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:
  • Oracle to SQL Server using SSIS

    Hi, I want to copy data from Oracle to SQL Server by using SSIS. I want a detail explain how to do that and which is best easy part to do that? Thanks in advance.

    saianand5 pointsBadges:
  • Cannot connect to SQL Server

    I recently changed by SQL service account to a AD service account. But now I can't connect to my SQL Server. Here's the error I'm getting: The target principal name is correct. Cannot generate SSPI context. What can I do to fix this?

    ITKE1,011,390 pointsBadges:
  • Change number in SQL Server

    How do I convert an English number to an Arabic number in SQL Server?

    elenahasooni5 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