• 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:
  • Trigger

    What is the use of the trigger?

    swamy00725 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:
  • 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,004,935 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,004,935 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,004,935 pointsBadges:
  • Change number in SQL Server

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

    elenahasooni5 pointsBadges:
  • Enabling Profiles on AS/400 machine

    I have an IBM model 600 which has not been off for about 4 years. When I tried to bring it up, I had a fan assembly that was bad, replace the fan assemble. Then I had a bad disk drive, replaced disk drive. Now when I try to start the machine I get "disk drive missing from the configuration", I then...

    rhicksjhicks5 pointsBadges:
  • Get files from folder using command prompt

    How do I get files from folder using command prompt?

    BalaRaja30 pointsBadges:
  • SQL Plus is not working on my computer

    I have successfully installed Oracle 10g but SQL plus is not working on my computer

    adeel0075 pointsBadges:
  • How to make new field available in Crystal Reports

    Hello, Before I ask my question, I just want to let you know that this is for Crystal Reports. I recently added a new field to my stored procedure. How do I get that available in CR? I don't want to reset the data source. Thanks!

    ITKE1,004,935 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