• 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:
  • 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,062,830 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,062,830 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 Khanduja17,385 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,062,830 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:

    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:
  • 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:
  • 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 Tidmarsh61,500 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,062,830 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:

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.