• Connecting to SQL Server using proxy server

    Can I actually connect to my SQL Server using a proxy server? If it is possible - how can I specify the proxy address and the port in the connection string. Thank you so much.

    ITKE969,840 pointsBadges:
  • Connect LINQpad to SQL Server

    I'm pretty new to LINQpad and I also have SQL Server installed on my other machine. It's on the same domain. But I'm having issues connecting to my server from LINQpad. It said the server is not found or not accessible. What should I do?

    ITKE969,840 pointsBadges:
  • Error message when connecting from TCP/IP to SSMS

    I'm using an older version of SQL Server (2008 to be exact) and I keep getting this error when I'm trying to connect with TCP/IP from SSMS. How can I solve this? A network related or instance specific error when a connection to SQL Server... (provider: Named pipe-provider, error: 40 - SQL Server)...

    ITKE969,840 pointsBadges:
  • 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.

    ITKE969,840 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.

    ITKE969,840 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.

    ITKE969,840 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?

    ITKE969,840 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.

    ITKE969,840 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.

    ITKE969,840 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?

    ITKE969,840 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?

    ITKE969,840 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.

    ITKE969,840 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:
  • 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!

    ITKE969,840 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:

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