• Backup schema in SQL Server 2005

    Would there be a way to backup just the schema in a SQL Server 2005 database? I don't need records, just the structure. Thank you!

    ITKE362,015 pointsBadges:
  • Deleted the SQL Server 2005 Database

    Hello! Please tell me is it possible to restore the database if someone accidentally deleted it? I have an old backup but I want a new database to reanimate. Really the database completely is removed from a disk?

    Britton5 pointsBadges:
  • Restore single table from SQL Server 2005

    For our SQL Server 2005, I had a backup made for the entire database. But does anyone know of a way to restore just one single table, no the whole thing?

    ITKE362,015 pointsBadges:
  • Restore SQL Server 2005 database backup over network

    I apologize that it's old software but we're using SQL Server 2005. Does anyone know if we can restore a database backup using Server 2005 over our entire network? We would appreciate any help.

    ITKE362,015 pointsBadges:
  • Connecting VB 2008 to SQL Server2005

    How to connect VB2008 with SQLServer2005 through coding. Not through OleDBAdaptar. Also Let me know the code for Add,Edit, Delete & Save in VB2008

    Ishita20095 pointsBadges:
  • What are basic differences between SQL Server 2000 and 2005

    What are the Basic difference between SQL 2000 and 2005? Thanks!

    Amin4rmOvexTechnology250 pointsBadges:
  • Transfer database from SQL server 2005

    How can we transfer database and logins from SQL Server 2005 to another SQL Server 2005?

    241219840 pointsBadges:
  • SQL Server 2005 upgrade to SQL Server 2012

    How can we upgrade SQL 2005 to SQL 2012

    Khaledzayed5 pointsBadges:
  • Transferring SQL 7 DB to SQL 2005 DB

    Hi to all, I have a Dell PowerEdge server having an SQL 7 DB on it and I want to transfer these DB to the new IBM Server having an SQL 2005 Server Standard Edition. I am not experienced enough to database administration. Can someone guide me through this please? Thanks, Bert

    Bertski40 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:
  • Advantages of SQL Server 2005 over SQL Server 2000

    What are the benefits of upgrading to SQL Server 2005 from SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Linked SQL Server problems

    I have 2 servers. Server 1 has SQL 2000 (SP2). Server 2 has SQl 2000 + SQL 2005 (sp2). I'm trying to create a linked server on Server 1 to Server 2 SQL 2005. I can get SQL 2005 linked into SQL 2000 on server 2 itself but when I got to Server 1 and try to create a linked server to SQl 2005, I get...

    KH155 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:
  • Moving SQL 2005 databases with no downtime between servers

    We have 2 SQL 2005 servers and would like to move the database and the logins and passwords from server to server. I ran backup and restored the full database with no recovery mode which allow me to copy the transaction logs then I transfered the logons and ran sp_change_users_login to associate a...

    Theitman25 pointsBadges:
  • Limiting SQL injection in SQL Server 2005

    I have a site in ASP and on the back-end in SQL Server 2005, but I keep finding SQL injection on my site. Is there code that will prevent SQL injection from getting onto my site?

    SQL Server Ask the Experts2,585 pointsBadges:
  • I am using SQL Server 2005 and the following error keeps being reported in the Domain Controller Logs:”There are multiple accounts with name MSSQLSvc/…..”

    I am using SQL Server 2005 and the following error keeps being reported in the Domain Controller Logs: "There are multiple accounts with name MSSQLSvc/....."

    Tizi30 pointsBadges:
  • ASP.NET

    I have four textboxes and a database which is already created. What I want to do is if i enter the value in the four textboxes and press button, it should automatically gets updated or saved in the database.

    5555544425 pointsBadges:
  • SQL2000 linked to SQL2005 doesn’t allow TRAN selects

    Hi all, I have a SQL2000 machine that has a linked server that runs SQL2005 (before this was a SQL2000) When the systems were both SQL2000 from ServerA it was possible to run: BEGIN TRAN SELECT * FROM MYSVR.MYBD.DBO.MYTABLE COMMIT TRAN After the ServerB has been upgraded to SQl2005 the code above...

    alessandro.panzetta9,725 pointsBadges:
  • Retrieving large binary objects

    Server: SQL Server 2005 SP2 on Windows 2003 R2, Quad Core, 4GB Ram, Gigabit Ethernet Client: Windows XP SP2, Dual Core, 1GB RAM, Gigabit Ethernet I am retrieving images from my database across the network and am concerned about thruput. It seems to me when I request a 300k image that it will be...

    JButtery5 pointsBadges:
  • Restore a View Sql Server 2005

    I over-wrote a VIEW by mistake. How do I recover the original version of the view? Is there a way to ROLLBACK a "CREATE VIEW..." command?

    VelameLaCosa110 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