• Windows Server 2016 KMS Host Issue

    Having issues with Windows 2016 KMS host server. Its giving problems in activation of Windows and Office in some machines. Need to understand how this works. How to use KMS Keys for each product we have? Please assist Step by Step best practice to fine tune and properly manage KMS server. How to...

    sundesa15 pointsBadges:
  • cant search files. windows 10.

    at random times my computer will stop searching sometimes it will search forever and sometimes it just wont search at all and also when it happens the xbox app loads forever and wont open and steam acts kinda weird too. ive already tried fixing index. it worked but it just went back to doing it...

    usernameeeee45 pointsBadges:
  • Corrupted MDF files

    Can anyone help me with how to view corrupted mdf files? I have certain MDF files which have been corrupted and creating hindrance in accessing SQL server database. I want to view these files. So, just wanted to know how to view them?

    ankit33023,555 pointsBadges:
  • SSMS 17 error selecting the default option “Select top 1000 rows”

    Ok, whats going on? Now when I right click a table name and then "select top 1000 rows" I get an error. The error is Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near '('. . The system generated SQL starts off like this.SELECT TOP (1000) [SerialNumbersID] . If I remove the ( ) around...

    ToddN2000132,730 pointsBadges:
  • need a help to retrieve data from 2 diif table

    we have 2 tables where only 1 column data available for comparison and also returns more than 1 row what to do

    Nidhi12055 pointsBadges:
  • Receiving undeliverable email we did not send

    Hi everyone, One of our users keeps getting undeliverable email messages. It looks like someone out there is sending mail and making it look like it is coming from him. Is there anyway to stop this? We are running Exchange 2007. I don't think it is relaying or a virus. It does this even when his PC...

    Fuddstud0 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:
  • 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 Khanduja19,160 pointsBadges:
  • Should i also restore master and msdb as well when upgrading SSIS database onto a new server.

    Hello, I have a SQL server 2012 with multiple instances on a windows 2012 and I am upgrading this onto windows 2016 with SQL server 2016. On one of the SQl instances I am using SSIS. I would like to know if I should be restoring Master & MSDB as well as i see that msdb contains all the SSIS...

    rakshith665 pointsBadges:
  • DBF file conversion

    Is there an easy way to convert DBF files to Vector CAN .DBC files?

    jaworrell5 pointsBadges:
  • Date Range in SQL Query

    Hi I would like to extract records from Db within a date range. Let's say where the date is between today and last three months. For example today is 6th Dec. Last three months will range till 6th Sep. but I also want it to incldue from 1st of sep till 6th of Dec.

    anirban945 pointsBadges:
  • How to repair backup of .mdf file database?

    One of our clients gets the following error when trying to backup a database:quote:________________________________________System.Data.SqlClient.SqlException: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x121db60d; actual: 0x521db60d). It occurred during...

    jordan26henderson5 pointsBadges:
  • RPG stored procedures

    Remote client calls RPG stored procedure which invokes RPG program. I am then calling another program from initial program but when I make this call it does not return result set. Can I call one program from the called program?

    junekotey120 pointsBadges:
  • Why is SQL Server Management Studio taking so long?

    We're trying to do some offline maintenance work on one of our development databases but the "Take Offline" command (through SQL Server Management Studio) is working very slowly. We have no idea what might be causing it to run so slowly. There are no open connections too. Any ideas why this is...

    ITKE1,142,780 pointsBadges:
  • It seems our SQL database is corrupted

    Hi, Is there a way to completely check a SQL-Anywhere database (5.5.05) integrity? "Validate" won't help: we had databases that were broken but "validate"  always told us that everything is o.k. :-( I had the idea to simple read every record in every table (first "select count(*) from...", second...

    basrhaidi5 pointsBadges:
  • SQL Report Help

    Hi I'm dave and I'm new to the forum, SQL and SSRS. Thanks in advance for your assistance and patience. I have a recall report that produces letters for every patient who needs to return to the office on a certain date based on their recall plan (a plan that determines when they should return based...

    Blowinup5 pointsBadges:
  • Setting “SendAs” permission for SSRS

    I need to set the "Send As" permission for Report Server Windows Service so my SQL Server can send reports by email. How is this accomplished?

    rdbarnes5 pointsBadges:
  • Exporting to Excel – Sort doesn’t work due to merged cells

    How can I change my SSRS to allow exporting into EXCEL and eliminate the header portion of report which includes merged cells. These prohibit my user from being able to sort a column in the table data.

    Gma885 pointsBadges:
  • Convert Crystal Reports to SSRS

    What's the best way to convert Crystal Reports reports over to SSRS? Over the next few weeks, I have to convert a bunch of them but I'm not sure of the best way. I know how to do it manually but I was wondering if there was an automatic solution?

    ITKE1,142,780 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,142,780 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