• (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53

    Problem: SQL SERVER is up and the instance connect is running. All required ports on Firewall is open/ also try to disable Firewall but no success. TCP/IP protocol is ENABLE.  SQL SERVER port is by Default 1433. Also try this: The problem is the Instance name from the client is not resolved, to do...

    Safekom33330 pointsBadges:
  • SQL convert numeric to date format

    How can I convert an 8 digit numeric (format ccyymmdd) into a real datefield to be used in date arithmetics? I need to calculate the number of months between the month (current date) and a date represented in my DB as an 8 digit numeric with format "ccyymmdd". Therefor (I assume) I need to convert...

    DanTheDane2,555 pointsBadges:
  • Can I version my SQL Server database?

    I'm trying to get several of my SQL Server databases under version control. Would anybody have some advice on how I should do this? Basically, I'll want a large collection of generated test data for performance management. Thanks so much!

    ITKE352,420 pointsBadges:
  • SQL server 2008 downgrade to express

    Due to our budget we are being forced to downgrade some servers from SQL server 2008 R2 to Express. Was told it 's a saving of 20k per PC.Are there any issues that we need to know that may cause us problems? I know Microsoft does not make downgrades easy.. If anyone could shed some light I'd...

    ToddN200015,605 pointsBadges:
  • Moving SQL Server database without affecting VB 6 code

    I am using VB 6 code with Microsoft Access database. Now I want to move to SQL Server 2008 database without affecting my VB 6 code. Any suggestions?

    vikasjains20 pointsBadges:
  • Installing SQL Server 2008 and VB 6 on the same PC

    I have 1 pc.3 drives-c:,d:,e:. Now I want to install SQL Server 2008 and VB 6 on the same PC. Mean to say Can I make use of SQL Server 2008 with VB 6 on same machine?

    vikasjains20 pointsBadges:
  • How to configure SQL Server agent

    In my SQL Server, I'm unable to find the SQL Server agent. How do I find it?

    venkat199110 pointsBadges:
  • Flowchart

    Can someone help me write a flow chart and algorithm of a program where the user is asked to find an integer number between 1 and 50? Thanks!

    melkamu15 pointsBadges:
  • My database .mdf file got corrupted in SQL Server 2008

    My database .mdf file got corrupted and I have no means to get my schemas. I tried with a few softwares available on the internet but its turns out that with all of them being demo versions, I don't give back the repaired file. Is there any other means by which I can restore my db? I am using MS...

    mjozekh5 pointsBadges:
  • Setting up a ODBC connection in Lotus Notes

    I've been trying to connect and send/receive information from a Microsoft SQL Server, in my Lotus Notes application using @formula in real-time, but I'm having trouble with the configuration. I've read that I have to set up ODBC driver. Where can I find that? And do I install it on the server or...

    ITKE352,420 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:
  • Auto filter of distinct values on columns in SQL Server Reporting Services?

    Is there a way to have an auto filter of distinct values on columns in SQL Server Reporting Services?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Member relationship in DB2

    I would like to know the relationship of member in DB2 interms of  MSSQL table. I need the query to fetch member in SQL Server

    sbesuedbknk5 pointsBadges:
  • Can SQL 2008 R2 run on Windows 7 ultimate 64-bits

    Can someone tell me if SQL 2008 R2 can run on a Windows 7 Ultimate 64-bits?

    rosewambugu5 pointsBadges:
  • Call DTS from java

    Please help us whether we can call DTS directly from Java.Solution which we got as below:-1. Create dts2. Create job in which we have to call dts3. Call job from stored procedureIt pretty lengthy process and we are not sure how error handling can be done in this scenario.Request all to help with...

    yyogesh10 pointsBadges:
  • Dynamic SQL field name

    SELECT ryear rtcur racct rbukrs SUM( tsl06 ) AS tbal SUM( hsl06 )  AS rbal FROM faglflext INTO TABLE lt_bal WHERE ryear =<input>  AND rbukrs IN <input>  GROUP BY ryear rtcur racct rbukrs.     In the above query , how can I dynamically change the field name...

    saselvakumar18105 pointsBadges:
  • Connecting a SQL database to Lotus Domino Designer

    I've been creating a Lotus Notes application that have dynamic combo boxes. Those boxes are going to be retrieved by selecting from a SQL database. Since I'm pretty new to Lotus Domino, could someone help with connecting my SQL database to Lotus Domino Designer? Thanks.

    ITKE352,420 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 database recovery from corrupt database file!

    Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few days ago I lost some part of my data due to accidental deletion. I backed it up, so I tried to restore the database from the .bkf file. The problem comes...

    chengchong365 pointsBadges:
  • Having trouble connecting Windows Server 2008 R2 to SQL Server 2008 R2

    I've reinstalled Windows Server 2008 R2 on my machine. After that I installed SQL Server 2008 R2 without a problem but I'm having issues when I try to connect with Microsoft SQL Management Studio via my Windows Administration account. Any idea why I can't connect? Thanks!

    ITKE352,420 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