• 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?

    ITKE997,745 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?

    ITKE997,745 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?

    BalaRaja25 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!

    ITKE997,745 pointsBadges:
  • Pass data from SSRS to Microsoft Excel

    I need to pass along data from SSRS to Microsoft Excel. But I'm not sure of the process. Could I create a link in the SSRS report that opens up into an Excel spreadsheet (with all of the data included in the cells)?

    ITKE997,745 pointsBadges:
  • MS SQL Server

    I want to rename SQL Server i.e give name other than the name of the machine on which installed.

    98484200940 pointsBadges:
  • Import of Microsoft Access database file to SQL Server is slow

    I've noticed that there's an issue whenever I'm trying to import my Microsoft Access database file into SQL Server. My Access file has a ton of data but whenever I try to do the import, it takes a long time. Is there a way for me to speed it up? Thanks very much.

    ITKE997,745 pointsBadges:
  • Trigger events in SQL Server

    How do I find trigger name with table name and trigger events in SQL Server?

    MaD1435 pointsBadges:
  • Import text file data into SQL Server table

    My table in SQL Server has several columns and a text file. Now, I need to import information from the text file into that table. It's basically two columns that need to be imported. How can I do that? What's the best approach?

    ITKE997,745 pointsBadges:
  • Get SMS jobs status in SQL Server 2014

    I have several SQL Agent jobs that are running on SQL Server 2014. Now, I need to get the SMS once a job has completed. This would include the job status and if went successfully through. How can I get that?

    ITKE997,745 pointsBadges:
  • ERP form error message on a SQL database

    We have a problem with the ERP system on our SQL database. Whenever an ERP form at our client’s end remains idle for 15 minutes, an error message pops up when the form is made active again. This message is: “FRM-40733: PL/SQL built-in DBMS_ERROR_CODE failed.” Our DBA team is blaming it on a...

    SQL Server Ask the Experts2,585 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