• 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...

    ITKE345,065 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...

    ToddN20009,905 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...

    ToddN20009,905 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

    ITKE345,065 pointsBadges:
  • Dynamic vs. Stored Procedure table inserts

    I just finished making some code changes to get around a problem. I changed my code from doing a dynamic insert to using a stored procedure. Originally it was 20 lines of code for the dynamic process. Doing it the stored procedure way, by the time you defined all the parms it was 107 lines of vb...

    ToddN20009,905 pointsBadges:
  • Windows Forms and SQL Server 2008 database

    Now, I have created two different things: A local database and a Windows form. With the Windows form (In Server Explorer), I added the database's connection. How can I begin querying it using LING-to-SQL? Thanks!

    ITKE345,065 pointsBadges:
  • Dreamweaver Firefox PHP

    PHP codes in calculator?

    Sjoseph5 pointsBadges:
  • SSRS reports in SQL Server 2012?

    I’ve been working with SQL Server 2008 R2 in conjunction with Visual Studio 2008 and 2010. I just installed SQL Server 2012 and have SQL Server Data Tools running. Now I’m trying to create SSRS reports in SQL Server 2008 R2, but I can't find them in Programs. I realize that common advice is to...

    ITKE345,065 pointsBadges:
  • How to read transaction log in SQL Server 2014?

    I need access to the read transaction log file in SQL Server 2014 for auditing purposes. In the past, I’ve used a third party log reader, but we’re looking to cut costs. I’m familiar with CDC, but that only allows access to data changes and I also need access to schema. Is there an improved...

    ITKE345,065 pointsBadges:
  • How to view transaction logs in SQL Server 2014?

    Hi, I have SQL Server 2014 CTP 1 installed and I can’t figure out how to view all transaction logs.Does anyone know where I can find them? I’ve looked at datasheets and documentation on MS website but I couldn’t find anything.

    ITKE345,065 pointsBadges:
  • Does SQL Server 2008 R2 Express have Intellisense?

    Is Intellisense available in SQL Server 2008 R2 Express Management Studio? It seems like it should be there. Is it inactive or am I doing something foolish?

    ITKE345,065 pointsBadges:
  • Comments in Excel using VBA with archived info included

    To whom it may concern,I am currently trying to get very specific cells in a spreadsheet to pull up the previous weeks worth of information (date from the past 5 days at least) and to show up in a comment on very specific cells so that the people in my department do not have to look up the...

    jgarces5 pointsBadges:
  • Connecting a SQL Server database with Visual Basic 6.0

    What code would I need to connect a SQL Server database with Visual Basic 6?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Connecting a SQL Server database with Visual C++ and .NET

    How can I connect a SQL Server database with Visual C++ and .NET?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to schedule SQL query to run in Microsoft SQL Server

    I have a query that I want to automatically schedule to run daily. How do I do this?

    House5 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