• Incompatibility issues between SQL Server 2012 and Visual Studio 2012

    I am hitting a strange error while trying to create an SQL Database project in Visual Studio 2012. Unable to open Database Project This version of SQL Server Data Tools is not compatible with the database runtime components installed on this computer. I am using SQL Server 2012 Developers Edition...

    ITKE1,142,780 pointsBadges:
  • Email Trigger failing in SQL Server 2012

    I'm having trouble getting a trigger to work.No errors are being thrown, but nothing is being email either. Is it my nested select? Use ABCTRAINING SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO alter TRIGGER TAXPERCENT ON [dbo].[AP101_VOUCHER_DISTR] AFTER update AS declare @VAT numeric(15,2),...

    ITKE1,142,780 pointsBadges:
  • SSIS on SQL Server 2012

    We're in the middle of upgrading from SQL Server 2005 to SQL Server 2012. However, there's a good amount of SSIS running on this server. Can we re-deploy these packages on the new SQL instance? Will we have to go through Visual Studio upgrade for each? Thanks!

    ITKE1,142,780 pointsBadges:
  • Cannot connect to SQL Server 2012

    I'm having trouble connecting to SQL Server 2012 database using C#. I get the following error message when I try to connect: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance...

    ITKE1,142,780 pointsBadges:
  • Need to delete tons of records in SQL Server 2012?

    I have over 740 million records in a table and I need to delete all records with two field values. I can’t find a way to do it automatically and of course manual makes no sense at all. Is there any way I can do this?

    ITKE1,142,780 pointsBadges:
  • How to paginate and view results in SQL Server 2012?

    I’m trying to set pagination within SQL Server 2012 so that you can follow the total number of pages while adding data. Anyone know how to do that?

    ITKE1,142,780 pointsBadges:
  • Need to generate automatic IDs for SRSS Reports

    I am running almost 75 SSRS reports. IS there a way to assign a unique ID to each report? Is there a way to leverage system generated information somewhere in the SQL Server 2012 databases rather than manually assigning each report an ID, for example using spreadsheet?

    ITKE1,142,780 pointsBadges:
  • Items keep hanging in SQL Server Management Studio 2012

    When I'm using SQL Server Management Studio 2012, I'm clicking on the "Databases" node in Object Explorer but it just keeps loading items until it finally hangs. This is only happening when I'm connected to a remote server, not when I'm accessing it through my PC. Does anyone know what the problem...

    ITKE1,142,780 pointsBadges:
  • SSRS reports in SQL Server 2012?

    I’ve been working with SQL Server 2008 R2 in conjunction with Visual Studio 2008 and 2010. I just installed SQL Server 2012 and have SQL Server Data Tools running. Now I’m trying to create SSRS reports in SQL Server 2008 R2, but I can't find them in Programs. I realize that common advice is to...

    ITKE1,142,780 pointsBadges:
  • Trying to ID SSRS reports

    Our company currently has over 50 SSRS reports. We're trying to assign an unique ID to each report and we're wondering if there's a way to leverage system generated information in SQL Server 2012 databases rather than manually assigning each report one-by-one.

    ITKE1,142,780 pointsBadges:
  • Uninstall error using SQL Server 2012

    I just went ahead and uninstalled an instance from SQL Server 2012. However, when I tried to uninstall a second instance but I keep receiving an error message saying I don't meet the requirements. What's the problem here?

    ITKE1,142,780 pointsBadges:
  • Security for SQL Server 2012 SSAS

    So I just installed an instance with SSAS only. Now, I'm curious how security (login) will be maintained. I've created one instance with engine and SSAS (Dimensional) and another instance with just SSAS (Tabular).

    ITKE1,142,780 pointsBadges:
  • Using JOIN in SQL Server 2012

    I’m trying to create a list of all our employees by last name with their dependents by first name, and birth dates. My output columns are emp_last_name from the employee table and dep_name and dep_date_of_birth. Here is what I’ve specifically been tasked with doing: Use alias table names. Name...

    ITKE1,142,780 pointsBadges:
  • Encypting a customer table in SQL Server 2012

    I have a customer table with contains several columns (names, address and contact info). Now, there are over 15000 records so I'm trying to figure out if I should encrypt the entire table of just several specific columns. How can I do this on a production database? Thanks!

    ITKE1,142,780 pointsBadges:
  • Backup and Restore different SQL Server 2012 Editions

    Does anyone know if it is possible to backup a database on a SQL Server 2012 Enterprise Edition and restore it to a SQL Server 2012 Business Intelligence Edition using SQL Server Management Studio? I would like to go the other way as well.

    TLMercer45 pointsBadges:
  • Best practice when using a shared table across multiple databases

    Hi everyone! I thought I would easily find a discussion on the internet about this subject but I didn't find anything to really help me. I have many applications that need to share common tables. Think about an Employee table for example. I don't want to have this table duplicated in each project's...

    skoub5 pointsBadges:
  • Importing data into SQL server from Intersystem Cache Database

    I have been trying to import data to SQL Server 2012 R2 from Cache database (Inter system Cache). How could I do it? I have tried by using SSIS through which I can export data to Cache? Am I going in the right way? Please help me? Thanks in advance

    nagakrishna5 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