• Data Storage – SQL Server

    Hi Guys, I have a question. When I enter data into SQL server where it stores, I mean database file where can I find it? I'm unable to locate it in the C drive.

    prasanna1235 pointsBadges:
  • In Windows 8 – Uninstalling SQL Server Management Studio 2014

    I have a student who installed SQL Server 2014 with tools, but the Management Studio part did not install. There is no SSMMS.EXE on the machine. So I tried to reinstall it, and the Management Studio tools come up checked but grayed out, so the SQL Installer will not let me make any changes. So I...

    elena7895 pointsBadges:
  • Cannot install SQL Server 2014 on machine

    For the past few days, I've been trying to install SQL Server 2014 on my machine. But this error keeps popping up: The process cannot access the file 'C:\Users\user\AppData\Local\Temp\Sqlwep-uni-(96bf8744-d4b7-4205-920d-cf1b69b6ed88).mof' because it is being used by another process. Why is this...

    ITKE1,021,240 pointsBadges:
  • Create downloadable file that will install a virtual server and services

    How can I create a downloadable file that will install a virtual server and install certain services and programs to a PC? So a user must be able to download the file to the PC that will then when opened it will install A Virtual server and certain programs as well as a blank SQL database hassle...

    SilenT1100105 pointsBadges:
  • SQL Server 2016 error: Fail to retrieve data for this request

    SQL Server Setup has encountered the following error: fail to retrieve data for this request. Please help me. Thanks all.

    Hvphong031175 pointsBadges:
  • Info from .bak in SQL Server 2005

    I have a 6GB .bak file that, when check it in the file to use for restore, the file shows 'Incomplete'. I need to extract the .mdf part of the .bak file since I don't need the .log file. There should be some way to do this or some tool out there that will either repair the .bak file so it doesn't...

    aragao45 pointsBadges:
  • Data masking for iSeries and SQL server

    My team is searching for a data masking solution that would work for both iSeries IBM DB2 and SQL Server. Any recommendations of vendors?

    DaneTestManagement5 pointsBadges:
  • Restoring Database

    I accidentally deleted contents of a table and is now trying to recover the deleted rows.  I do not have a backup (how stupid of me).  I do have a .mdf file, however I believe i copied that file while SQL Server 2005 was running.  Is there anyway to recover this deleted data?

    Tyecom5 pointsBadges:
  • SQL Join keeps failing

    Hello everyone, This question comes from one of our power users: ToddN2000. I'm trying to join 2 tables and it keeps failing. I did not create the tables and I cannot change them. One has the order defined as NUMERIC(8) the other has the order defined VARCHAR(15). I have tried using CAST, CONVERT,...

    Michael Tidmarsh56,450 pointsBadges:
  • Design stored procedure with clause

    I have a rather large stored procedure to develop. The procedure is going to be used in a large crystal report. I was wondering if you can design a stored procedure using a with clause. I used CTE on SQL Server but that doesn't seem to be an option.

    jvichich5 pointsBadges:
  • Visual FoxPro Remote view

    Currently I'm doing SQL migration through remote view to my new product. In this, how to handle the following case. Single application will be access by each user and SQL DB in common server. Remote view [dbc] also common to all users. When one user add one record to a master table, how the changes...

    actramesh0015 pointsBadges:
  • How to connect my application using Visual Studio 2005 to a SQL Server database?

    how to connect my application using visual studio 2005 to a database using sql server?

    MissVeryLittleKnowledge5 pointsBadges:
  • Query for trigger in SQL Plus

    How can I define a trigger that will fired to calculate gpa at run time before the insertion of record into table?

    khan15053330 pointsBadges:
  • Trigger

    What is the use of the trigger?

    swamy00725 pointsBadges:
  • Building quiz application using ASP.NET/VB.NET and SQL Server

    Hello masters, How are you all doing? I just have a question. I am building this simple quiz application using ASP.NET/VB.NET and SQL Server for the database. Now what I want to happen is that when I click on submit button, it will count all the correct answers of the user based on the radio button...

    shawnturner10 pointsBadges:
  • Link to a MDF database

    So I created a MS SQL db , but now I cannot link to it. I would like to create a database in my C:/Cfusion/wwroot folder and not in ProgramFiles/MicsoSQL/Data folder. Is that possible? How? I cannot create a new database in anywhere but ProgramFiles/MicsoSQL/Data folder. Now I have an MDF in...

    BjornPorgilsson5 pointsBadges:
  • How to import Microsoft Excel data into existing SQL Server table

    We have a SQL Server table that currently has data in it. Can we import more Microsoft Excel data into this existing table? We already tried using the export wizard but we got a ton of errors.

    ITKE1,021,240 pointsBadges:
  • Deleted Microsoft SQL Server 2005 compact edition

    How do I recover it from the recycle bin?

    viviene35 pointsBadges:
  • Moving SQL Server instances from one data center to another

    Hi, I am working on to find some workaround for moving SQL Server 2005/2008 instances from one data center to another data center without changing database configuration setting at application end because application team is not sure what all places server name and database name is hardcoded. I...

    avsPrasad2615 pointsBadges:
  • SQL Server

    What is a tempDB in SQL Server?

    Sai5 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