• Problem with SQL Server Database File(.mdf)

    I am using SQL Server 2008 R2 and I want to check my master database file (.mdf) but failed to open it.

    edwinjhoffer3,045 pointsBadges:
  • How to disable SQL Server Management Studio for a user

    Is there a way to prevent users from getting into SQL Server Management Studio so that they can't just edit table rows manually? They still need to access the tables by running my application.

    edwinjhoffer3,045 pointsBadges:
  • Report having more than 240 columns in SSRS 2005

    Hi folks, I am using SSRS 2005 BI. As per MSDN standards SSRS 2005 will not support more than 240 columns in excel (while exporting, will get error). Now I am having more than 240 columns though I am using SSRS 2005, I am not getting any errors. However there is an error here: Reporting Services...

    BhakthaprahladaReddy2,030 pointsBadges:
  • Migrating SQL Server 2005 back to SQL Server 2000

    How would I go about migrating SQL Server 2005 back to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to copy complete database architecture, SP’s and function except data in SQL Server

    I am have a database called Database1 having 100 tables with 1lack records. Now I want the same architecture and sp's and functions present under this database, expect data into newly created database called Database2? How can I achieve this?

    BhakthaprahladaReddy2,030 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:
  • 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,890 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,890 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,890 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,890 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,890 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.