• SQL Server 2012 error message when restoring database

    I keep getting this odd error message in SQL Server 2012 when I'm trying to restore a backup that was made from a previous version. Here's the error message I'm getting: System.Data.SqlClient.SqlError: Directory lookup for the file "C:\PROGRAM FILES\MICROSOFT SQL...

    ITKE413,725 pointsBadges:
  • How to export SQL Server 2012 database with data

    Can I import my SQL Server 2012 database (including the data) to a .SQL file so I can import it into my 2008 server. For some reason, I've never been able to export the data. Only the structure goes through.

    ITKE413,725 pointsBadges:
  • Convert SQL Server 2014 database to 2012

    Does anyone know of a way to convert SQL Server 2014 database to 2012? I tried the Generate Script but I have too much data and SSMS didn't go through with it. Thank you very much

    ITKE413,725 pointsBadges:
  • Can I restore my SQL Server 2012 database backup to SQL Server 2008?

    This probably isn't possible but can I restore my SQL Server 2012 database backup to SQL Server 2008? I'm assuming I can only go forward, not backup.

    ITKE413,725 pointsBadges:
  • Step-by-step procedure creation of SQL Server 2012

    How can I create a version of SQL Server 2012 for myself? I need the step-by-step process.

    nkvasani5 pointsBadges:
  • SQL Server 2012: CASE statement evaluates all conditions

    Does anyone know if SQL Server 2012 CASE statement evaluates all WHEN conditions or just exits when it finds the first TRUE condition? So basically, if it goes through all of them, then does the last condition overwrite the first condition? Thank you.

    ITKE413,725 pointsBadges:
  • SQL Server 2012 query errors

    In SQL Server 2012, I'm running several queries but not all of them are working. The first one goes through but not the second. Also, when I try to run it without the WHERE clause, everything fails. The queries are below. Thank you. create table #temp (id int primary key) create table #temp2 (id...

    ITKE413,725 pointsBadges:
  • SQL Server 2012 – Profile stored procedures

    I'm currently using SQL Server 2012 and I'm trying to figure out if I can profile stored procedures. I need to capture each SQL Statement in my stored procedures (basically how long it takes to run). Thanks so much.

    ITKE413,725 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:
  • Best load testing software for VB 6 and SQL Server 2012

    What's the best load testing software for VB 6 and SQL Server 2012?

    Udayarajan5 pointsBadges:
  • SQL Server 2005 upgrade to SQL Server 2012

    How can we upgrade SQL 2005 to SQL 2012

    Khaledzayed5 pointsBadges:
  • How to open a RDL file in SQL Server 2012

    Hi I'm using SQL Server 2012, I'm download the RDL file in my location but the RDL file is not open. If open the RDL file, I have the error message. The error message is “unknown error”. Please help me open the RDL file.

    selvakumarrk5 pointsBadges:
  • Need SQL 2012 alert to run when job step fails

    I have a mutli step SQL Server job that when one of the steps fail an alert needs to be sent out, however the job can't fail on this step it needs to continue. I have tried a trigger on sysjobshistory but that has gotten kind of ugly. So for example: 3 step job step 1 completes goes to step 2 step...

    tcstl95 pointsBadges:
  • complexity for shell script migration

    we have approx 700 shell script which is written for sybase ASE. and we have to make them compatible to work for SQL SERVER 2014 as we are migrating our database from SYBASE ASE 15.7 to SQL SERVER 2014. could you please tell me what should be my checklist in every shell scripts?

    mayurigupta915 pointsBadges:
  • Clustered index in SQL Server 2012

    A clustered index is created automatically in SQLserver 2012 while creating a table with primary key. The index is created on the primary key field. My queries which are not using the primary key for search are costing 100% on clustered index scan. Should I create covered index for each and every...

    dhanam115 pointsBadges:
  • Problems installing SQL Server 2012

    I am having problems installing SQL Server 2012 on 64-bit windows 8. Here’s what I’ve tried: Click setup.exe and wait for the installation center to come up. Click "New SQL Server stand-alone installation" and then the Setup Support Rules page comes up. I click OKInput the product key and click...

    ITKE413,725 pointsBadges:
  • How do I convert SQL Server 2012 files to SQL Azure?

    Currently, I’m running SQL Server 2012 with Visual Studio Beta 11 as well as SQL Server 2008 R2 version of the .mdf file because the staging server uses R2. I’ll be moving up to SQL Azure for a project I’m working on. What is the best way to port files over? Do I actually need to make changes...

    ITKE413,725 pointsBadges:
  • Import CSV file to SQL Server 2012

    I'm looking to import roughly 10,000 rows (this is from a CVS file) into an existing SQL Server 2012 table. I only have 1 column to import but there's another table in my column titled "TypeID". For this column, I need to set a static value like this: 99E05902-1F68-4B1A-BC66-A143BFF19E37INSERT INTO...

    ITKE413,725 pointsBadges:
  • Use SQL INSERT to Create Directories with FileTable

    This is my first experience with SQL Server 2012 and I'm not familiar with the limits of the FileTable from within SQL Server. Is there a way to create directories in a FileTable without using File I/O APIs? Is it just as simple as creating a SQL INSERT statement?

    ITKE413,725 pointsBadges:
  • SQL Server 2012 Question: How to find last executed queries by database?

    Is there a way to find the last executed queries for a specific database in SQL Server 2012? I am able to find them using SSMS, but I don’t want to use SQL Profiler if I don’t have too. This is the query I’ve used to get the complete list of last executed queries. SELECT...

    ITKE413,725 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