• 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,021,225 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,021,225 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,021,225 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,021,225 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,021,225 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,021,225 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,021,225 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,021,225 pointsBadges:
  • No tables available when importing CSV file into SQL Server database

    For the past few days, I've been trying and trying to import a CSV file so I can insert data into an existing database table. This is for SQL Server. Here's the issue: When I'm trying to select source tables / views for the destination, I don't see any at all. Nothing is coming up. It's basically...

    ITKE1,021,225 pointsBadges:
  • How to view content damaged MS SQL Server database?

    Help! Dead computer and all the information. Computer to reinstall formatting (otherwise failed). With the help of programs to restore files managed to pull Fail SQL database (.mdf). But on the other computer does not accept the file. Writes an error. Already tried everything. How do I restore the...

    hanamor11005 pointsBadges:
  • How can I restore a database from .mdf file?

    How can I restore a database from .mdf file? I only have .mdf backup file.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Creating a new database using an MDF file

    My database saves as MDF. I want to know what are the steps to restore or create a new database using a MDF file? I tried to restore as usual but it shows an error. Please help.

    Thrstorm5 pointsBadges:
  • Oracle SQL script to deactivate customers records with possible multiple debt some paid some not paid

    I want to write a Oracle SQL script that will only deactivate a customer record with no outstanding debt.

    lindadawes5 pointsBadges:
  • How to take a table-level backup in SQL Server 2008

    Does anyone know how to take a table-level backup in SQL Server 2008? Can we use the backup database command? Thank you!

    ITKE1,021,225 pointsBadges:
  • SQL database is crashed

    Hello, Our server was hit by some unknown virus which seems to have corrupted header information for many of our files including an important databases and some of its backups. However the log file (.LDF) for the live DB was not affected. We also have a relatively old .BAK backup file. Is it...

    morrisonn5 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