• Search: Error with SQL : Login failed for ‘SA’.

    I'm using a softawre written in VB(.net). It runs normal on XP and 2003 server. it supports both Access and SQL 2000 and 2005. but I recently upgraded my OS to Win7+SQL 2008, and I've been having the following error anytime a call for a screen in the software"Search: Error with SQL : Login failed...

    PrinceBismark25 pointsBadges:
  • System tables in SQL Server

    How to view System tables in drop down menu of a database in SQL SERVER 2005

    VendoorMohankrishna5 pointsBadges:
  • Application compatibility with SQL Server 2005

    We would like to upgrade from SQL Server 2000 to SQL Server 2005, but we are currently also using PowerBuilder version 6.0. How can we determine if our version of PowerBuilder is compatible with SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Inserting DB2 records on iSeries to SQL Server 2005 Table

    I need to insert records from a DB2 file residing on an iSeries to a SQL Server 2005 table on a remote system. How can I do this in a CL or RPG ? Thanks

    shizam5 pointsBadges:
  • Related to SQL server 2005

    When we write store procedure it is encrypt by --with encrypt tag means it will locked it doesn't show sp so how it will be DECRYPT?

    ITIndustry5 pointsBadges:
  • sql server 2005 service will not start

    I have a new server running server running windows 2003 and sql server 2005. when I turn on allow remote connections and restart sql service the service fails to start. If I turn off allow remote connections the sql service starts with no problems. I have been unable to find any potential solution...

    Cwpmike15 pointsBadges:
  • installation of sql server 2005 in vmware

    I am trying to install sql server 2005 in vmware with scripts but failed. Script is running successfully, but nothing is shown in sql server configuratin manager.

    Zini15 pointsBadges:
  • Attaching MDF and LDF files to SQL Server 2005

    I have MDF and LDF files with different modified dates. How could I attach these to SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Stop one database in a SQL 2005 environment

    If there are multiple databases ever one unique SQL2005, how can I stop only one of them?

    MoroExpert5 pointsBadges:
  • SQL Server active/active node clustering

    I need to scale my applications to support the future volumes. We are using sql server 2005 service pack 2, on a active and passive node cluster environment. Can I add another active node to the cluster and create a grid environment to scale my enviornment, without impacting any of my current...

    Ndtvenkat20 pointsBadges:
  • SQL 2005 Database instance

    Hi there i have a windows 2003 domain in our school, i have a problem with my sql 2005 database. im trying to uninstall a instance from the database engine. it wont uninstall. i believe that this is corrupt. im trying to reinstall sophos but as the old database will not uninstall sophos wont...

    Philcrox160 pointsBadges:
  • Stored procedures to script table data in SQL Server 2005

    Are there any stored procedures or command line utilities that I can use to script out the data from a particular table in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Create linked server from sql 2000 to sql 2005

    Does anyone knows how to create a linked server in Sql 2000 regarding a database to Sql 2005. All I want to do is a selection from a table in sql 2005 and insert into a table in Sql 2000   Thanks in Advance

    ManosZim30 pointsBadges:
  • Trigger or Stored for lock and unlock database for 15 minute

    Dear Sir, I create a login form in which if you insert password 3 times wrong then u r account is locked for next 15 minute. and we send a random password  on referenced emailid which is sent after 15 minute. For these 15 minute the account isactive='false'. So can u please help me to give code...

    Programmer0075 pointsBadges:
  • Can two separate cursors update the same SQL table when executed together?

    I have three tables. Table One is a master table which contains rows which need to be updated with data from the other two tables (I'll call them Table Two and Table Three). I have created a cursor which updates existing rows in Table One with data from Table Two. This works fine, and following the...

    MrRussellWebb5 pointsBadges:
  • Microsoft Sequel Server 2005 VSS backup

    What's seems to have happened is that the SQLVDI.dll files in the 2 directories: C:\Program Files (x86)\Microsoft SQL Server\80\COM C:\Program Files\Microsoft SQL Server\80\COM are out of sync. This seems to have happened as a result of a service pack for MSSQL which was applied in Dev. The...

    LeonT140 pointsBadges:
  • How to install a named instance in SQL Server 2005 without affecting the existing instance

    I have SQL Server 2005 installed and the default instance running. I want to install an additional named instance. How should I go about creating the new instance, without affecting the existing one?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error message when installing SQL Server 2005

    I have installed SQL Server 2005 and acquired SP2. However, when I continue to install the SAP dialog instance, it gives me the following error: MDB-05036 Error when creating sqldmo SqlServer object What does this mean?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Connecting to a SQL Server 2005 database through LAN

    I am trying to connect to my SQL server 2005 database on my server. I open SQL server 2005 management studio and try to set the server name to IPADDRESS\SERVER3 (the name of the server) but this doesnt work. I have also tried with connection strings in VB and these dont work either

    Providence15 pointsBadges:
  • Looping in SQL

    dear, i have one table with more than (16000) rows. now i should add on column with "computed column" as a result for other columns, so i already create the new column with correct statment but how can i make this statment excute for all pervious rows. to be exact: the new column should contain...

    Firasrehawi5 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