• Cannot connect to SSMS 2017 database

    I'm trying to connect to SSMS 2017 database from my Windows 10 machine but I can't at all. I've uninstalled / reinstalled SSMS but that didn't help. Nothing changed in my security settings (antivirus). Here's the error message I'm getting: A network-related or instance-specific error occurred while...

    ITKE1,071,435 pointsBadges:
  • How to get local time of a SQL server?

    Hwo to get local time of a SQL server and store it in a variable of a client program written in C#?

    Edchu5 pointsBadges:
  • How to disable auto audentity of a DB2/400 table

    Hello, For a migration data project (from SQL/Server to DB2/400), we need to disable the auto identifiers of a DB2/400 table. On SQL Server, the equivalent command is "set identity_insert MyTable off". Thank you in advance JC Cherid

    TheWorldAsGarp5 pointsBadges:
  • Execution plan cost checking in SQL Server 2012

    How can I analyze SQL Server Execution plan in that cost percentage (need more clarification for physical operation, logical operation, CPU cost)?

    kowshi5 pointsBadges:
  • SQL Server 2008 Setup has stopped working

    Why has my SQL Server 2008 Setup has stopped working?

    SahilPasha35 pointsBadges:
  • Test “SQL Injection” in mobile app for login the app using mobile number and password

    Is this any possible to test "SQL Injection" in mobile app for login the app using mobile number and password?

    Parkavi5 pointsBadges:
  • Cannot create audit in SQL Server 2012

    I'm currently a DB_owner user in our SQL Server 2012. I need to create an audit but I keep getting this error message: User does not have permission to perform this action What should I do? Thank you.

    ITKE1,071,435 pointsBadges:
  • Change column from VARCHAR to NVARCHAR in SQL Server

    Would it be possible for me to change a SQL Server column from VARCHAR to a NVARCHAR? Is there a specific SQL command to do this?

    ITKE1,071,435 pointsBadges:
  • How to run SSMS on MacOS

    So from what I've heard from colleagues, SQL Server 2016 can run on a MacOS. But I need to make sure that I can use SQL Server Management Studio too. Can I run that on a MacOS? Thank you.

    ITKE1,071,435 pointsBadges:
  • DB2 hex values in SQL causing problem

    Ok here's one I cannot figure out. Here are the PO#s that show in our green screen software and they look fine     5-824101 S1079682 33­-548504­-D RMA 001904          REASON CODE 11  8075-089          1V 76139-6200        88   But if I write a SQL to extract them the PO#...

    ToddN2000102,160 pointsBadges:
  • Track data from SQL Server 2005 in Visual Studio

    How can I track data from SQL Server 2005 in Visual Studio?

    friska9075 pointsBadges:
  • Set DataTable name in returned data set

    I have a SQL stored procedure with simple select statements that returns multiple datatables within the dataset.  The stored procedure is being called from C#/.NET code.  The stored procedure is returning the data but the datatable names end up Table, Table1, Table2,...  when the dataset is...

    LordPerrin15 pointsBadges:
  • Error message in Reporting Services on SQL Server

    I am trying to post a report on Reporting Services on SQL Server, but I keep receiving this error message (“salesexpo1” is the name of the table): An error has occurred during report processing. Query execution failed for data set 'rSellingEP_AV'. Invalid object name 'Saleexpo1'. What might...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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,071,435 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,071,435 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,071,435 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,071,435 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