Questions & Answers

  • Disconnect active connections to force SQL Server backup through

    On SQL Server, I noticed that it doesn't restore my backup due to all of the active connections. Is there a way to force it through? If not, how can I disconnect all the active connections?

    ITKE440,495 pointsBadges:
  • SQL: In responsiblity wise last 5 transactions details request as on 31.03.2016

    AS per audit review request: All responsibility wise  AP, AR, GL, CM , FA , PO, Inv last 5 transactions taken from the sql as given date for 31.03.2016.  Please help on our request.

    Thillainathan5 pointsBadges:
  • What is requirement coverage and how it can be achieved in QC9.0?

    Actually I'm trying to analyze the requirement coverage by linking requirement with the test case but it is not showing how many test case is been failed or passed it is showing only in terms of the requirement is passed or failed.

    preethikiran5 pointsBadges:
  • Oracle 9i error message in Windows 7: jrew.exe

    while installing oracle9i in laptop i a getting message jrew.exe stopping program(i am using windows 7)

    Sayedtawfik5 pointsBadges:
  • Processors

    How much time will consumed by a pipeline processor to execute 10 instructions?

    TayyabAftab5 pointsBadges:
  • Truncate SQL Server log file

    My boss asked me to empty our LDF file before I send it to one of our clients. Is there a way I can force SQL Server to truncate my log? Thank you very much.

    ITKE440,495 pointsBadges:
  • Error code a6050266

    What does the error code a6050266 mean?

    waigeorge5 pointsBadges:
  • How is metadata used in the real world?

    Hillary Clinton is using metadata to improve her chances of winning the Presidency as Obama did in 2008 and 2012.  What is metadata and how is it used in a political sense?

    lornaahn5 pointsBadges:
  • Dialpad tones

    How do I silence the tone connected to the dial pad?

    waltcichon5 pointsBadges:
  • XLA file

    How can I open a XLA file?

    Thoman455 pointsBadges:
  • SQL Server 2008 condition in case

    Hi, I have a condition (with a parameter named @Par1=IS NOT NULL) in query like this select * from table1 where Numeric field1 IS NOT NULL. It runs okay but where numeric field1 =@Par1 it, it doesn't work. Another example: @A= '>0' and @invcode = 1 @InvCode INT, @A nvarchar(20) SELECT GoodCode,...

    saeedtalebi5 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?

    ITKE440,495 pointsBadges:
  • How can I rename a column in a SQL Server 2008 table?

    In one of SQL Server 2008 table columns, I have to go ahead and rename it. How can I do that? I've tried this but it didn't work: ALTER TABLE table_name RENAME COLUMN old_name to new_name; Thanks!

    ITKE440,495 pointsBadges:
  • Move table into schema in SQL Server 2008

    I'm currently using SQL Server 2008 and here's my issue - I'm trying to move my table into a specific schema using T-SQL. I can't figure out how to do it. Can someone help me?

    ITKE440,495 pointsBadges:
  • How do I unblock my school Chromebook

    I can't find anything. Is there a way for me to unblock my school Chromebook?

    nboy785 pointsBadges:
  • New Lotus Notes email didn’t pop up

    Why is 'new mail received windows' not popping up when new mail received? A user has to open Lotus Notes and click refresh to popup the new mail. When user was in another windows version, they not realize there were incoming mail.

    hikari25 pointsBadges:
  • Software licenses for PC software

    How can I find out if all of my PC software are genuine licensed on Microsoft Windows?

    srithea355 pointsBadges:
  • T-SQL command to make SQL Server sleep

    Would anyone happen to know if there's a T-SQL command that would make SQL Server sleep for some time (particularly several hours)? We're working on a web service that we want to test - to see if asynchronous pattern is scalable. For that to happen, we have to call a SQL Server with a script /...

    ITKE440,495 pointsBadges:
  • Convert SQL Server 2014 database to 2012

    Does anyone know of a way to convert SQL Server 2014 database to 2012? I tried the Generate Script but I have too much data and SSMS didn't go through with it. Thank you very much

    ITKE440,495 pointsBadges:
  • SQL Server database list of name for tables

    On SQL Server, is there a way I can get the list of names for all of my tables in a specific database? Please note that this is for SQL Server 2008 or 2012. Thanks!

    ITKE440,495 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.