• How to repair backup of .mdf file database?

    One of our clients gets the following error when trying to backup a database:quote:________________________________________System.Data.SqlClient.SqlException: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x121db60d; actual: 0x521db60d). It occurred during...

    jordan26henderson5 pointsBadges:
  • RPG stored procedures

    Remote client calls RPG stored procedure which invokes RPG program. I am then calling another program from initial program but when I make this call it does not return result set. Can I call one program from the called program?

    junekotey45 pointsBadges:
  • Receiving undeliverable email we did not send

    Hi everyone, One of our users keeps getting undeliverable email messages. It looks like someone out there is sending mail and making it look like it is coming from him. Is there anyway to stop this? We are running Exchange 2007. I don't think it is relaying or a virus. It does this even when his PC...

    Fuddstud0 pointsBadges:
  • Why is SQL Server Management Studio taking so long?

    We're trying to do some offline maintenance work on one of our development databases but the "Take Offline" command (through SQL Server Management Studio) is working very slowly. We have no idea what might be causing it to run so slowly. There are no open connections too. Any ideas why this is...

    ITKE1,096,990 pointsBadges:
  • It seems our SQL database is corrupted

    Hi, Is there a way to completely check a SQL-Anywhere database (5.5.05) integrity? "Validate" won't help: we had databases that were broken but "validate"  always told us that everything is o.k. :-( I had the idea to simple read every record in every table (first "select count(*) from...", second...

    basrhaidi5 pointsBadges:
  • SQL Report Help

    Hi I'm dave and I'm new to the forum, SQL and SSRS. Thanks in advance for your assistance and patience. I have a recall report that produces letters for every patient who needs to return to the office on a certain date based on their recall plan (a plan that determines when they should return based...

    Blowinup5 pointsBadges:
  • Setting “SendAs” permission for SSRS

    I need to set the "Send As" permission for Report Server Windows Service so my SQL Server can send reports by email. How is this accomplished?

    rdbarnes5 pointsBadges:
  • Exporting to Excel – Sort doesn’t work due to merged cells

    How can I change my SSRS to allow exporting into EXCEL and eliminate the header portion of report which includes merged cells. These prohibit my user from being able to sort a column in the table data.

    Gma885 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,096,990 pointsBadges:
  • Export SSRS to Microsoft Excel without any headers

    I have a SSRS report that I need to export to Microsoft Excel. But here's the kicker - my header that's on the first page of the report has to be removed from Excel. How can I do that?

    ITKE1,096,990 pointsBadges:
  • Execute SQL Server Procedure from the iSeries

    I have an internal web address for a SQL Server application, where they want to run an iSeries stored procedure to connect to the SQL Server, call a SQL Server Stored Procedure, and receive resulting values back to the iSeries. Is this possible?

    sonorato15 pointsBadges:
  • Compound keys, anyone?

    In many cases, you have to join individually non unique keys that together, are unique and can be used as primary keys.

    amissor55 pointsBadges:
  • How to use LDF file

    What is the purpose and how can we see transactions made database using this file?

    steel10105 pointsBadges:
  • SQL update a column to remove a certain character

    I have a table (book) where there is a column that contains number in some rows and numbers with an addition *infront. I want to be able to perform some calculation with the table but the '*' is preventing me from doing this. So how do I update or alter the table so that I can remove the * and keep...

    Lazy16755 pointsBadges:
  • Unable to connect to voyager SQL Server instance

    I am installing Voyager2017patch10 but I'm getting this error: Unable to connect to voyager SQL server instance, while the server is running. So ,what is probably causing this error and what possible solution.

    EMMY485 pointsBadges:
  • SQL server query to search for table and column data in database

    I want to find the data in a table,but i dont know the table name and column name.All I know is the data and the database name .Is there a query to find the table and column

    Linu438910 pointsBadges:
  • Delete duplicate records in MySQL database

    One of our clients asked us to delete duplicate records in a SQL Server database and a MySQL database. We did it in SQL but MySQL is giving us issues. It says the format of the query is not correct. Does anyone know of a way to do this? Thank you so much!D

    ITKE1,096,990 pointsBadges:
  • Cannot export database from Microsoft Access to SQL Server

    I have to export a database from Microsoft Access to SQL Server. Here's the issue: When there's attached files, I can't export it because SQL does not recognize it. Any other ideas on how to export this?

    ITKE1,096,990 pointsBadges:
  • SQL database page level corruption

    Hello Experts, We are facing page level corruption in SQL database. The database size is 650 GB. What should we do?

    DBAPriya30 pointsBadges:
  • Starting a career as SQL database developer

    I recently have finished my btech 3rd yr via cse. I am quite interested in SQL so I want to be a SQL database developer. So please guide me in what other languages I should learn and what other skills I should learn too.

    Rajiv62535 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