• Process that causes full server memory in SQL Server 2014 database

    How can I find the process that causes my server memory is full used?

    ankurbhalani235 pointsBadges:
  • Export SSRS to Microsoft Excel without any headers

    I have a SSRS report that I need to export to Microsoft Excel. But here's the kicker - my header that's on the first page of the report has to be removed from Excel. How can I do that?

    ITKE1,047,980 pointsBadges:
  • Where to find SQL Server 2017 Standard edition

    I'm trying to test out SQL Server 2017 Standard edition but can't find it anywhere (don't see a trial). I've already downloaded the Developer edition but it's the same as the Enterprise edition. Can someone point me in the right direction?

    ITKE1,047,980 pointsBadges:
  • Read email confirmation in VB.NET

    I want to know how to know customer read my email using VB.NET (window application / web application) without image. Thanks!

    Pkaur70 pointsBadges:
  • What is seed and reseed in SQL Server?

    What is seeding and reseeding in SQL Server? How to use it? Where is it used? What is the purpose?

    Jaideep Khanduja16,440 pointsBadges:
  • remove password from SSIS package

    How can I remove the password from a password protected SSIS package? I need to access its source code, but as soon as I try to open it I get the window: Enter Password. I don't know the password. This package was created by an employee who left the company a couple of years ago.

    Rmk3255 pointsBadges:
  • 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,047,980 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,980 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,047,980 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:

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