• Logging SQL Server connection attempts

    Hello experts, I'm using SQL Server and I'm wondering if there's somewhere that my attempted login connections are stored. Is there an external log file for this? Thank you.

    ITKE1,042,030 pointsBadges:
  • How to schedule SQL query to run in Microsoft SQL Server

    I have a query that I want to automatically schedule to run daily. How do I do this?

    House5 pointsBadges:
  • Connecting to SQL Server through Emacs

    Would I be able to connect to SQL Server through Emacs? What are the steps I should take to do this? Any info would greatly help.

    ITKE1,042,030 pointsBadges:
  • Schedule a job in SQL

    I have no access to SQL Server Agent, am I able to get a SQL script run every morning 8am?

    SQL12345 pointsBadges:
  • How to replicate database between two SQL Server databases with Oracle ESB middleware?

    I have two SQL Server databases with the same version. There is a Oracle bus service between the two SQL Server database. I want transaction replication between two database, two database located in different cities. How do I configure Transactional Replication between the two Database?

    RezaBavafa13635 pointsBadges:
  • Best way to create a SQL Server ODBC data source

    What would be the best way for me to create a SQL Server ODBC data source? I know I can do this directly (Registry) but I need it to be programatically. Is there an API that can do this? Thanks so much.

    ITKE1,042,030 pointsBadges:
  • How to setup DSN on SQL Server Express

    How can I setup a DSN for SQL Server Express (I believe it's the 2012 version). This is installed on my machine. I tried to follow the wizard but when I get to which SQL Server it should connect to, my machine isn't there. What should I do?

    ITKE1,042,030 pointsBadges:
  • Log queries from SQL Server or ODBC

    Would I be able to trace or log queries that my application sends to SQL Server through our ODBC driver? Does ODBC have some sort of query logging? If there's another way, please let me know.

    ITKE1,042,030 pointsBadges:
  • Transfer data from SQL Server to Microsoft Access

    Hello, we need to move a large amount of data from a SQL Server database to a Microsoft Access database. The table structure is already setup. Is there anything from SQL I can use for the migration? Or do I have to use a ODBC data source? Thanks.

    ITKE1,042,030 pointsBadges:
  • Testing ODBC entry for Linux to SQL Server connection

    Hello, We have this ODBC entry that we need to test to see if it connects our Linux server to SQL Server. Before this, we need to make sure the entry is configured correctly too. Can anyone points us in the right direction?

    ITKE1,042,030 pointsBadges:
  • Connection of DSN to SQL Server has stopped working

    My Linux application uses DSNs to connect to our SQL Server. For some reason, the connection has stopped working and I can't find the DSN's credentials. What should I do here?

    ITKE1,042,030 pointsBadges:
  • How to split and later reunite a large MS SQL table

    Sir I am stuck in a logic. I have dynamic tables. Let's say one large data Big_Table is stamped with profile 1,2,3,....n So I create table profile1, profile2,... profilen (example profile1 :- select * from Big_Table where rule = profile1) table data example :- table_profile1 transaction_id profile...

    AshishMishra95605218565 pointsBadges:
  • Call stored procedures asynchronously on DB2 database

    I'm working on a DB2 database - would I be able to call my stored procedure from another procedure asynchronously? Thanks so much.

    ITKE1,042,030 pointsBadges:
  • SQLRPGLE Cursors and Recursion

    I'm trying to recursively call a PI in my SQLRPGLE program. Problem is, I get an SQLCODE error of -519 and I'm sure it has to do with cursors and the prepare statement in my PI. Here's the code: pprintPrograms    b      dprintPrograms    PI      d...

    Dcantwell480 pointsBadges:
  • ssma_oracle.to_char_date

    ssma_oracle.to_char_date function was missing in the conversion. Do you have the code for the function?

    ayso2976005 pointsBadges:
  • Types of JOINs in SQL

    What are the types of JOINs in SQL?

    vijaykumar110 pointsBadges:
  • Writing a hidden trigger against a SQL table

    How do I write a hidden trigger against a SQL table?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Convert Crystal Reports to SSRS

    What's the best way to convert Crystal Reports reports over to SSRS? Over the next few weeks, I have to convert a bunch of them but I'm not sure of the best way. I know how to do it manually but I was wondering if there was an automatic solution?

    ITKE1,042,030 pointsBadges:
  • How to fit SSRS report into PDF page

    Hello, I need my SSRS report as a PDF page. What's the process for this? Appreciate the help.

    ITKE1,042,030 pointsBadges:
  • How to upload CSV file into SQL Server

    I have a very large CSV files and it needs to be uploaded into SQL Server using C#. How can I do that? It has thousands of rows / roughly 20-30 columns. Thanks so much.

    ITKE1,042,030 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