• SQL: How to take out second maximum salary?

    Is there a SQL Command to find second max salary.

    Rylan08350 pointsBadges:
  • SQL Server: The Index Allocation Map Page is Pointed to by the Next Pointer of IAM Page.

    Microsoft SQL Server was running fine until it recently stopped running for no real apparent reason. It's saying: The Index Allocation Map Page is Pointed to by the Next Pointer of IAM Page. Anyone have had similar issue? Your advice is greatly appreciated.

    Frank33115 pointsBadges:
  • SSRS script when no records found

    I have a script that checks if records are found, if not, return a default row: IF EXISTS ( ' + @SQL1 + ' ) BEGIN ' + @SQL1 + ' END ELSE BEGIN select 0 FIELD1, 0 FIELD2 END The downside to this is it runs the SQL twice. Is there a better solution? I have tried IF @@ROWCOUNT = 0, but that seems to...

    akho9125 pointsBadges:
  • Open multiple Windows 10 applications at the same time

    I'm a computer software developer at my job and when I begin work, I have to start up so many applications. This includes: SQL Server, Visual Studio, SSMS, etc. I'm wondering if there's a shortcut I could use to open all of these up at the same time (meaning at once)?

    ITKE1,052,135 pointsBadges:
  • CURSOR issue in AS/400

    Hi Friends please someone help me on the below issue. I have a SQL query which I ran in STRSQL. Initially it's showing 17 records in first page and pressed Page down to go to 2nd page then it's showing second set of 17 records. And then If I press page up to go to 1st page again I could see that...

    SatishKumar00730 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:
  • 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,052,135 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,052,135 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,890 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,052,135 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:
  • 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:
  • 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:

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