• Exporting SSRS Report in Simple Excel sheet(not formatted)

    Hi All, when I export and ssrs report in excel, it gets exported in excel but in a fancy format. I want to export the data in a simple excel sheet format so that I could apply filters or formulaes. If any one of you are aware of this do let me know please. Avhilash.

    Avhilash5 pointsBadges:
  • Export SSRS Report to Microsoft Excel

    Hi, I am a beginner in SSRS. Please guide me to export SSRS report i.e. .rdl report to an excel sheet.

    AmitJoshi14310 pointsBadges:
  • SQL Server 2008: Job was invoked schedule 188

    After execution, it says job was invoked schedule 188. How can this be solved?

    ike66045 pointsBadges:
  • Rotate keys in SQL Server encryption for PCI compliance

    I understand that PCI compliance needs an annual rotation of keys. It's for decrypting your data, followed by re-encrypting it with a new key. So we have around 16 databases that are across 3 servers and multiple tables. It's only going to get bigger. Could I write something for this? Or should I...

    ITKE371,580 pointsBadges:
  • Reading COBOL indexed file in SQL procedure in iSeries

    How do I read a COBOL indexed file in SQL procedure in iSeries?

    Bhusha40 pointsBadges:
  • Encrypt SQL Server 2008 database for PCI compliance

    I'm pretty new to PCI compliance and from what I understand I need to secure a person's credit card info, expiration date and the card holder's name. There's not going to be storage of security codes ever. So in my SQL Server 2008 database, I would need to encrypt these 3 columns? Also, do I need...

    ITKE371,580 pointsBadges:
  • SQL Server rotation of keys for PCI compliance

    I understand that PCI compliance requires annual rotation of keys. So, I have 16 databases across 3 servers (with multiple tables in each database). And it's going to get bigger. If I did this manually, it would make my data unreadable. Is there a software to do this?

    ITKE371,580 pointsBadges:
  • Documentum Stops Processing

    During import of Excel files, documentum just stops processing & disappears. There's nothing in the log, other than 49 files were processed & no errors. EMC cannot duplicate the error in their lab. Installation gone awry? CC me at morgans@southcoastplaza.com with solution.

    CMSteven5 pointsBadges:
  • Converting from RPGLE to DB2/400 SQL

    My shop just announced that it intends to convert from RPGLE on the ISeries 400 platform, to SQL, such that the procedures will be portable to other hardware platforms. What documentation to I need to acquire to train on writing SQL procedures; initially within DB2/400?

    SeaRancher5 pointsBadges:
  • Detailed analysis on index seek and index scan

    I want to know detailed analysis on index seek and index scan and its importance in tuning query and also reading and identifying each and every counter in an execution plan.

    vivekghag525 pointsBadges:
  • Would SQL Azure be PCI DSS compliant?

    I'm using a separate Windows Server that is PCI-DSS compliant, is it still compliant if I had SQL Azure hosting the backend? I'm currently only storing permitted values. Thank you very much!

    ITKE371,580 pointsBadges:
  • Control-M version on SQL Server

    What is Control-M version certified on SQL Server?

    Dackeret20 pointsBadges:
  • How to write this code in T-SQL?

    How do I code this T-SQL: Write a summary query that returns three columns named CustLastName, CustomerID, and DollarValueOfOrders.  The dollar value of the orders is to be the sum of the dollar value of the orders associated with the customer with the lastname of ‘Spaller’ and firstname of...

    Jamieh0815 pointsBadges:
  • How to use a SQL Server 2008 database on a NAS

    We've been working on a project using Visual Studio. We need to create a local database file with our project directory so we can check into a SubVersion and have configuration management. But we keep getting an error when trying to create or attach a database on a network share. Just to clarify,...

    ITKE371,580 pointsBadges:
  • Big trouble with importing Excel sheet to SQL Server 2012

    Hi, I have following scenario: Installed SQL Server 2012 on WIN 2012 Server Installed SQL Management Studio Installed Visual Studio 2012 Installed SQL Server Data Tools Installed SQL Server Integration Services Everything is related to Express version. I have a software program running on a SQL...

    dkanthony5 pointsBadges:
  • Count the times that = Smith is present in SSRS

    I want to count how many times a certain word is used is a column on a SSRS report

    Vickis5 pointsBadges:
  • In a single CL Program, can we read a database file more than once?

    In a single CL Program, can we read a database file more than once

    Chraghuveer25 pointsBadges:
  • Is it important to backup the transaction log?

    Over the past few months, we've been putting in a backup solution for a client. Their ERP solution uses SQL Server but ERP was set up by a different company. They have told us multiple times that it's really important to backup everything and truncate the transaction log. Is the log that important?...

    ITKE371,580 pointsBadges:
  • How to restore a SQL Server 2008 database

    Dead database. Looked at backups but the last backup made three weeks ago, then the operation was executed with an error and I didn't notice: - (mdf and ldf aren't copied by the conductor. errors in the file. using Active File Recovery had copied the mdf. then I passed Windows Check Disk. Windows...

    gioacchinolupi15 pointsBadges:
  • Using iSeries as linked server in SQL Server 2012 Express

    I downloaded SQL Server 2012 Express in order to attempt to create a database on a PC which has links to data living on our iSeries. I can't use the OLE DB2 extension from Microsoft since it doesn't work on SQL Server Express. So, I figured out (with Google's help) that I could run this script to...

    Koohiisan5,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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.