• Intellisense isn’t working in SQL Server 2008 R2

    We just got a new machine but everything was already installed on it, including SQL Server 2008 R2 and Visual Studio 2010 SP1. However, I don't have any intellisense in SQL Server Management Studio (aka it's not working). What should I do?

    ITKE351,300 pointsBadges:
  • Incompatibility issues between SQL Server 2012 and Visual Studio 2012

    I am hitting a strange error while trying to create an SQL Database project in Visual Studio 2012. Unable to open Database Project This version of SQL Server Data Tools is not compatible with the database runtime components installed on this computer. I am using SQL Server 2012 Developers Edition...

    ITKE351,300 pointsBadges:
  • Rolling back updates in SQL Server 2014

    Is there anything that will allow to rollback and UPDATE query in SQL Server 2014 that was not available in previous versions? I’m referring to committed commands – I know you can rollback if query is inside transaction. We have full, differential and transaction log backups in place but we’d...

    ITKE351,300 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...

    ITKE351,300 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...

    ITKE351,300 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...

    ITKE351,300 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!

    ITKE351,300 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:
  • 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...

    ITKE351,300 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:
  • 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.

    ITKE351,300 pointsBadges:
  • Using a table variable as input in a stored procedure

    Have just run into a problem. Currently our web service has been adding data to our SQL server 2008 tables by building a dynamic SQL INSERT command. It has started failing because of the data coming in. It contains a single quote in the name data ex. O' Brien. I am looking to pass the tables from...

    ToddN200013,310 pointsBadges:
  • Powerbuilder and Word OLE

    How do I insert pictures in picture content control in Word during runtime from PB (if I have 5 predefined picture content controls already saved in a Word template?

    HariharanAthmaraman5 pointsBadges:
  • Privera software

    I'm an IT beginner and I want to learn more about Privera software. Can someone point me in the right direction?

    ki7uf8tz65 pointsBadges:
  • QR Code barcodes in .NET

    How could I generate barcodes not in black and white, but still it could be scanned, it this possible?

    Alice34570 pointsBadges:
  • Why is my textbox always showing zero’s after the decimal point? (Visual Basic)

    I have a text box to where a user will insert text like 1234567. My intentions is to have that textbox add the comma's and decimal points once the focus has left it. However the results I am getting is 1,234,567.00 and not 12,345.67. Here is my code: Private Sub toothchart_TextChanged(ByVal sender...

    TryingHard125 pointsBadges:
  • Lost Toolbar

    I unchecked all of the toolbars (by mistake) in the "Customize" menu and now I can't find a location to Right-Click on to bring up the customize menu so I can restore the Standard menu. Any suggestions?

    ChuckWagon5 pointsBadges:
  • Insert data to DB2 database using VB and SQL stored procedure

    I have spent a few days trying to find a solution using Google. Has anyone had luck with this problem? Simply put we are trying to send data from our web service to our I-Series. We need to do this via a SQL stored procedure. When we do the insert dynamically it works as long as there are no single...

    ToddN200013,310 pointsBadges:
  • How to change datetime values in SQL Server?

    I want to present a datetime value without hours, minutes or seconds in SQL Server 2008? Would this code work?Statement @SomeDate datetime = '2013-09-18 16:30:22' select trunc_date(@SomeDate) ----------------------- 2013-09-18 00:00:00.000

    ITKE351,300 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