• Cannot create local SQL Server

    I'm trying to create a local SQL Server using the SQL Configuration Manager. But I keep getting this error message: Cannot connect to to WMI provider. You do not have permission or the server is unreachable. Any thoughts what I should do here?

    ITKE1,060,150 pointsBadges:
  • How to link Microsoft Excel file in SSMS 2014

    I'm using SSMS 2014 and I'm able to link an Excel file as a linked server. But here's my question: Now I want to link multiple Excel files. Can I link all of the files on a linked server or do I have to do them separately? Meaning one linked server for one Excel file.

    ITKE1,060,150 pointsBadges:
  • How to export data from R to SQL Server quickly

    Is there a way I can export data from R to SQL Server quickly? The standard way (SQLSave) is really slow for a large amount of data. This is what I tried so far: toSQL = data.frame(...); sqlSave(channel,toSQL,tablename="Table1",rownames=FALSE,colnames=FALSE,safer=FALSE,fast=TRUE); Thank you!

    ITKE1,060,150 pointsBadges:
  • WSUS Server multiple instances of computers listed.

    I am very new to the Windows update server (WSUS). I installed and configured the update server and everything seems to be working. I added some settings in my group policy and applied the GP to an OU and went on my way. The clients started to appear in the list of workstations on the WSUS server;...

    Skepticals0 pointsBadges:
  • SQL update a column to remove a certain character

    I have a table (book) where there is a column that contains number in some rows and numbers with an addition *infront. I want to be able to perform some calculation with the table but the '*' is preventing me from doing this. So how do I update or alter the table so that I can remove the * and keep...

    Lazy16755 pointsBadges:
  • SQL: How to take out second maximum salary?

    Is there a SQL Command to find second max salary.

    Rylan08505 pointsBadges:
  • SQL job keeps failing: Access to the path is denied

    I'm not too experienced with SQL so please let me. I have a SQL job that keeps failing. Here's the error message: Access to the path /d$.... is denied. Would this be network related at all? I have it setup so it's going from one server to another server. Any help would be great. Thank you very much.

    ITKE1,060,150 pointsBadges:
  • Deleted Microsoft SQL Server 2005 compact edition

    How do I recover it from the recycle bin?

    viviene35 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:
  • 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:
  • 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,060,150 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,060,150 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,060,150 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,315 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:

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