• Receive automatic SQL Server updates in Windows 10

    I recently upgraded to Windows 10 but I did notice when interesting thing. In my previous versions of Windows, SQL Server would always update itself through Windows Update. But when I did the upgrade, I haven't seen any updates happen in Update. Is this something I need to configure in Windows 10?...

    ITKE1,042,990 pointsBadges:
  • How to create a SQL database

    I want to create a SQL database. What are the software requirements and where do I get the software?

    DouglasMonaco45 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...

    elena78945 pointsBadges:
  • SQL SERVER 2005-MAX FUNCTION

    I have a stored proc1 which returns a list of dates for one particular job number.I execute this proc in an other proc2 ,to get the list of all dates. Then in my proc2 we can get the MAX of this list of dates. In the WHERE clause of my SELECT statement, i need to filter the result set by dates less...

    Beginner in IT5 pointsBadges:
  • Deleted Microsoft SQL Server 2005 compact edition

    How do I recover it from the recycle bin?

    viviene35 pointsBadges:
  • How to upgrade to Veritas Backup Exec 16

    Hi Databackup, I actually didn’t succeed to upgrade to Veritas 16. I have a problem with SQL Express. I already have MS SQL 2012 R2 but the process insists on installing SQL express and we receive error v-225-302. Regards.

    Amintek5 pointsBadges:
  • How to Repair WSS_Content Database in SQL Server 2008?

    Hi, We have SharePoint foundation 2010 and we were getting error on backup so we did run DBCC CHECKDB and found some error. Looks like I found 0 allocation errors and 55 consistency errors in database 'WSS_Content'. Now I'm not sure what i need to do to repair. How do I repair? Any drawback? How...

    GregoryGood5 pointsBadges:
  • DBA – SQL Server 2005 – Backups

    I am trying to figure out how SQL Server DBAs are doing their backups and verify in 2005. I use the Idera's free stored procs (which is no longer available to download btw) to backup and verify and have gotten around 65% compression. If there any other free alternative?

    leviya5 pointsBadges:
  • How can I get the queries history in SQL Server?

    Is there a way I can get the queries history in SQL Server?

    balachandr5 pointsBadges:
  • Always On SQL Server

    When we connect to AG listener in SQL 2016 can we see/view/visible others DBs which are not participating in Always on.

    subhani7865 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 Tidmarsh58,225 pointsBadges:
  • 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:
  • 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,042,990 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:
  • 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:

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