• 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,153,200 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,153,200 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:
  • 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,153,200 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,153,200 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:
  • How to restore a SQL Server 2000 database using a backup

    Could you please educate us on how to restore a database using a backup? We have a Mambilla PR software (.NET application) and SQL Server 2000 back end. We run the backup before any major change to the database.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Can any one post IKM online test questions (SQL Server 2008) please?

    IKM online test questions SQL Server 2008.

    IKMsql1235 pointsBadges:
  • Code for bulk insert and upload data of EMD File in SQL Server

    Can someone please provide me the stored procedure for bulk insert EMD File in SQL Server?

    HIREKHAN5 pointsBadges:
  • Cannot connect from Access 2016 to SQL Server

    Hello, I'm trying connect from Microsoft Access 2016 to SQL Server though ODBC connection. But I keep getting this error message: The SSPI context can not be generated. What does that mean? How can I fix it? Thanks so much.

    ITKE1,153,200 pointsBadges:
  • SQL function value is null

    We needed a change recently as more shipments going international. I needed to make changes to our function to return the new motor prefixes. The old worked fine as if it was not US or CA we used XX to show international. We had just the three country values. Now each country has it's own code and...

    ITKE1,153,200 pointsBadges:
  • Overnight performance metrics

    Should the overnight performance roll into the whole day's results?  We staff overnight for customer satisfaction.  The inbound calls are low/sporadic, and sometimes impacts the day's results.  Overnight is not a priority right now.  It is my belief that we should report the overnight results...

    adbrown35 pointsBadges:
  • T-SQL: Find the first and last date (+1) for each price change

    I have a table of price and date like: Price Date 3.20000000 2018-01-14 3.20000000 2018-01-18 3.20000000 2018-01-19 4.00000000 2018-02-10 4.00000000 2018-02-11 4.00000000 2018-02-12 5.10000000 2018-02-16 3.20000000 2018-03-11 4.00000000 2018-03-15   I wish to get the first date for every time the...

    modan20185 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