Questions & Answers

  • Secondary storage for the future

    Does anyone have some examples of advancement in secondary storage for the future?

    winsonloseson5 pointsBadges:
  • Remote connection error using SQL Server Express 2012

    Now, I've recently added SQL Server Express 2012 to my home server. I'm trying to connect to it from Visual Studio 2012 from my machine but I keep getting this error:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was...

    ITKE346,030 pointsBadges:
  • Email Trigger failing in SQL Server 2012

    I'm having trouble getting a trigger to work.No errors are being thrown, but nothing is being email either. Is it my nested select? Use ABCTRAINING SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO alter TRIGGER TAXPERCENT ON [dbo].[AP101_VOUCHER_DISTR] AFTER update AS declare @VAT numeric(15,2),...

    ITKE346,030 pointsBadges:
  • MIMIX – New object created in source system

    When we created a new object in source system and included in Data group for replication. It didn't automatically replicate? We have to end journaling for the new file (obj) and start Journaling again.It works now. Reason?

    7085 pointsBadges:
  • Does SQL Server 2008 lack “datetime”?

    Does SQL Server 2008 allow for the datatype “datetime”? I’ve primarily worked on SQL Server 2005. I found out about the gap when I built an entity framework model while using a 2008 database. When I tried to update the entity on a 2005 database I got the following error: The version of SQL...

    ITKE346,030 pointsBadges:
  • BRIEF EXPLAINATION

    explain the working of railway track fault detection system component by component.

    isawhimthinking5 pointsBadges:
  • Blackberry voting button

    How can you enable the voting buttons to work on a message received on a Blackberry via Microsoft Outlook 2010?

    Pclowser5 pointsBadges:
  • Cannot find server name

    I’ve just started learning ASP.net and I installed Visual Studio 2010 and Microsoft SQL Server 2008. When I connected SQL server management studio to the server message box and tried to enter a server name, the connection failed. How can I find the name of the server? Is there something else I...

    ITKE346,030 pointsBadges:
  • Upgrading to SQL Server 2008 R2

    This might be a simple question but I have SQL Server 2008 in my machine and I'm looking to upgrade to SQL Server 2008 R2. What's the easiest way possible to do it? Any documentation would be great.Thank you!

    ITKE346,030 pointsBadges:
  • SSIS on SQL Server 2012

    We're in the middle of upgrading from SQL Server 2005 to SQL Server 2012. However, there's a good amount of SSIS running on this server. Can we re-deploy these packages on the new SQL instance? Will we have to go through Visual Studio upgrade for each? Thanks!

    ITKE346,030 pointsBadges:
  • Windows 8 Pro Stop Error Code: 0xc000021a

    i'm having with my PC which is an HP Pavillion a6700y Desktop PC. In Dec.2012 I upgraded Win. Home Premium 64 to Win. 8 Pro, I did clean install everything went well, i've had no problems until I went to start it up & then it said that the PC had problem & started diagnosing & then a...

    dusty51435 pointsBadges:
  • How to convert SQL Server 2008 R2 BPA output into CSV?

    I have been using SQL server 2018 R2 BPA for getting data from Microsoft. When using SQL Server 2005 to export results I could do so in a CSV format. When we upgraded two servers to Server 2008 I found that I could no longer run BPA 2005 on these. We then upgraded to 2008 R2, which again does not...

    ITKE346,030 pointsBadges:
  • Tasks solved by writing computer programs

    Identify 5 different tasks that can be solved by writing a computer program and for each task, isolate the problems to be solved?

    wakiso5 pointsBadges:
  • Having problems connecting to SQL Server 2008 remotely

    I am trying to connect to my database in Visual Studio 2010 using the named instance by 123.123.123.123/instanceNameBut, I get the following error message: error provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server I have the following aspects enabled: open Port...

    ITKE346,030 pointsBadges:
  • CALLB error!

    Hi all, When I compiled a RPGLE member, I'm getting  this error : "CALLB cannot be used when DFTACTGRP (*YES) is specified for CRTBNDPGM or as a compile option keyword."  Can any one please explain me why this happens and how to handle this? Thanks!

    Sai4AS4001,420 pointsBadges:
  • Recommended Alarm Thresholds

    When setting alarms, are there any recommended thresholds for best practices? This would be for setting email alerts.

    ksmoler5 pointsBadges:
  • Why won’t the macro run in other worksheets?

    I want to make a table as part of a macro. The size of my document changes daily, so even though a choose control end before I make the table, it assigns specific cell numbers which it employs for subsequent runs of the macro. How to I get it to go to the last populated cell in a column...

    Felucha5 pointsBadges:
  • Pagination in different versions of SQL Server

    What's the best process (performance wise) to paginate results in different versions of SQL Server (2000, 2005, 2008 and 2012) if you also want to find the total number of results (before pagination)? Thanks!

    ITKE346,030 pointsBadges:
  • Cannot connect to SQL Server 2012

    I'm having trouble connecting to SQL Server 2012 database using C#. I get the following error message when I try to connect: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance...

    ITKE346,030 pointsBadges:
  • Stored Procedure code in SQL Management Studio

    I'm trying to find a way to step into a stored procedure code in SQL Management Studio (in SQL Server 2008). I've heard its possible with Visual Studio but I'm looking for a debugging solution for Management Studio.

    ITKE346,030 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following