• How to export excel data to Sql server 2005

    How to export excel data to Sql server 2005

    Rasheed1802075 pointsBadges:
  • steps for accessing sql data through ado.net code over LAN NETWORK

    steps for accesing sql data through ado.net code over LAN NETWORK

    Jib35 pointsBadges:
  • Upgrade SQL 2005 Cluster to SQL 2008

    We have a remote sql 2005 server set we will be replacing with a Windows 2008 Cluster. The db supports a 3rd party app. The app has not completely endorsed for sql 2008. If I build an active/passive cluster with sql 2005 on Windows 2008, is there the ability to upgrade the sql server to a SQL 2008...

    tcstl95 pointsBadges:
  • Transactional Replication: Publisher & Subscriber size mismatch

    Hello, We have implemented transactional Replication[Push] on our SQL Server 2005 DB. The Distributor is the Publisher. The publisher is on one server and the subscriber on another. After synchronizing the DB, the tables count and the no of recs per table are identical on both the servers, however...

    Test1215 pointsBadges:
  • Oracle DECODE and SSMA

    Does the SSMA or SQL Server Migration Assistant actually have a custom DECODE function that can be used in SQL Server? I've installed SSMA and can't find that function in the sysdb database. I assumed there was such a function based on a blog posting made by Kevin Kline.  If there is a function...

    Dirk5 pointsBadges:
  • Creating Alert/Email when Automatic Failover Occurs In Sql-Server 2005 and 2000

    HI]] I want to send email alert when aotomatic failover occurs in in Sql-Server 2005/2000.  Specs: Active/Active  NO DR solutions

    ETHMAN55 pointsBadges:
  • SQL Server 2005 Log Shipping question

    I have setup log shipping on our production SQLServer to send the logs to a server I have at my home for a warm backup solution. The process seemed to work but then I had a problem on my secondary server - it seemd to stop working for a period of 2 weeks (I dont know why - I could not login to it...

    Lorelei10 pointsBadges:
  • SQL SERVER 2005 Security use Kerberos instead of NTLM

    How can I setup sql server 2005 to use kerberos authentication instead of NTLM?

    Rick Martinez585 pointsBadges:
  • SQL-Using count and inner join in a single query

    Hi Trying to retrive a report from the DataBase using left join on two tables. To get the count of resultant table, I'm using count. But the output shows error. If I comment count statement then the query executes successfully. I feel there is some error in the syntax of the count that I'm using....

    SQLmurali5 pointsBadges:
  • Help upgrading from SQL Server 1997 to SQL Server 2005

    When upgrading from SQL Server 97 to SQL Server 2005, what needs to be done? Can I restore 97 backups to 2005? Do I need to install any other software? Is this an easy process? We have 6 databases with about 300 GB of data currently.

    ITKE352,570 pointsBadges:
  • error in SQL workbench

    ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2 SQL Statement: CREATE  TABLE `cape codd`.`SKU_DATA` ( )   Does anyone know how to fix or workaround this? thanks Whitney Ferrante

    Whitneyf5 pointsBadges:
  • Migrating from Microsoft applications to Oracle

    How can I easily convert my SQL 2005 databases to Oracle's latest iteration? We are moving away from Microsoft applications and want to migrate to Oracle. What do I need to do to prepare?

    ITKE352,570 pointsBadges:
  • moving an existing active/passive 2005 SQL cluster onto an existing active/active SQL 2008 cluster.

    I have been tasked with moving an existing active/passive 2005 SQL cluster onto an existing active/active SQL 2008 cluster. The active/active 2008 SQL cluster consists of two nodes that are running Windows Server 2008 Enterprise edition. These nodes connect to an EMC SAN which has been operating...

    MikeDCCA5 pointsBadges:
  • Web based application not uploaded ON SERVER sometimes

    We are having the Web based software which is uploaded on our server on technology of front end: PHP & backend: MS SQL Server 2005. Some times this application can not uploaded, so plz give the solution to solve this problem. Actually this application is developed by third party and they update...

    SJFIL5 pointsBadges:
  • SQL server SP3

    Security Update for SQL Server 2005 Service Pack 3 (KB970892) .. i cant get this update to work on my comp..soemthing about hotfix.exe error

    Jimk5 pointsBadges:
  • I’m interested in creating a web form that will deposit information into a SQL Server database.

    I'm interested in creating a web form that will deposit information into a SQL Server database. What's the best way to do this and what software exists to accomplish this? I have experience creating Access forms that connect to a SQL Server back end.

    Eabouzeid175 pointsBadges:
  • Lotus Notes to SQL Server 2005 via linked server

    I am trying to create a linked server on SQL Server 2005 to Lotus Notes 6.03. However, I keep getting an error. A system dsn was created with the Lotus NotesSQL driver (8.0). In creating the linked server on SQL Server 2005, Linked Server Name: Same name as System DSN Provider: Microsoft OLE DB...

    Awaller5 pointsBadges:
  • Can anyone tell me the best way to query Active Directory in SQL?

    Can anyone tell me the best way to query Active Directory in SQL? I'm using SQL Server Management Studio Express and want to add the LDAP server for AD as a linked server to query. I'm not sure what the best way to do this is.

    Eabouzeid175 pointsBadges:
  • SQL Server 2005: Improving performance of Multiple Databases & LUNS

    I am looking at ways to improve performance of our databases. We have 4 large databases (ranging between 50gb and 200gb each) on a single SQL Server 2005 Cluster. Currently they are split 2 on one LUN and 2 on another. I am looking at ways to improve the IO performance of the databases as they are...

    Bulldog9815 pointsBadges:
  • Backup storage for sql server 2005

    1.create database ABC 2.backup database ABC to disk='D:backupDBABC.bak' Here i created a new database 'ABC'.NOW my DATABASE is empty(no objects where created), i am taking full back up,the out put i am getting OUTPUT: Processed 152 pages for database 'ABC', file 'ABC' on file 1. Processed 2 pages...

    Buckup5 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