• Check if a column exists in SQL Server database

    In a SQL Server database, is there a way to check if a column exists in a table? This is what I came up with but it keeps returning false: IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTableName' AND COLUMN_NAME = 'myColumnName') Thanks!

    ITKE366,930 pointsBadges:
  • How am I blocking connections to SQL Server 2008?

    This is a fairly specific issue, but I'm at a loss for reasons to what might be happening. We have SQL Server 2008 running on what we'll call ServerA. We can RDP in ServerA, we can ping ServerA. If we RDP into ServerA, we can open up SQL Server Management Studio and connect to all of the database...

    edwinjhoffer3,005 pointsBadges:
  • Recovering a truncated table on a SQL Server

    How can I recover a truncated table on a SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Grant permissions to user for backup/restore in SQL Server

    Can anyone tell me what permissions must I give to a user inside SQL Server 2005 so that this user can backup and restore a database without given him sysadmin server role?

    edwinjhoffer3,005 pointsBadges:
  • 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,005 pointsBadges:
  • Remove duplicate rows from a large table in SQL Server

    For SQL Server, does anyone know the best way to remove duplicate rows from a large table? Here's what I have so far: MyTable ----------- RowID int not null identity(1,1) primary key, Col1 varchar(20) not null, Col2 varchar(2048) not null, Col3 tinyint not null Thanks!

    ITKE366,930 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,005 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...

    ITKE366,930 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...

    ITKE366,930 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?

    ITKE366,930 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:

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.

Following