• SQL Server 2000 backup failed

    can not backup a 2000 db, dbcc checkdb ok. see following: Errorlog: 2008-01-08 09:54:40.69 spid62 Starting up database 'CP2005'. 2008-01-08 09:54:41.00 backup BACKUP failed to complete the command BACKUP DATABASE [education] TO DISK = N'C:\fjs1\education_db_200801080954.BAK' WITH INIT , NOUNLOAD ,...

    Fjsittler5 pointsBadges:
  • SQL Database is corrupted

    Respected sir, Unfortunately the hard disk of my system is damaged, now I recovered my database. but it cannot be attached again to SQL management studio 2005. The error is myfile.mdf is not a primary database file. (SQL server, error 5171) Please sir help me.

    shampur5 pointsBadges:
  • Export / import data from Excel to SQL database

    Hi, I want to do one program in which I have one Excel sheet that some data can be stored. I want to import that data in VB.NET application and store it in a SQL database and do same thing vice versa. Which means I can fetch data from SQL database through VB.NET and store that data in Excel. Please...

    qwertyudicdi10 pointsBadges:
  • Tracing with SQL Server profiler

    I'm using SQL Server and I've just started to use the profiler function. Is there a way I can trace using SQL Server profiler? Do I have to use SSMS? Thank you!

    ITKE392,085 pointsBadges:
  • Changing password on SQL Express 2008

    I recently installed SQL Server Express 2008 and I'm signing in using Windows authentication. But after that, I can't do anything. Is there a way I can change the password so I can have access? I'm also using Windows 7.

    ITKE392,085 pointsBadges:
  • Transfer data from Oracle Hyperion to SQL Server

    Can I transfer all my data (tables, columns, etc.) from Oracle Hyperion to SQL Server? Would SSIS work for this? Thank you!

    ITKE392,085 pointsBadges:
  • Deleted SQL Server 2005 database

    Hi, actually I know the importance of backup, but I don't have the back up in any-how condition. Accidentally the database deleted by me. How do I recover it? How to use the transaction.log file to restore deleted database in SQL Server 2005?

    Lalit35 pointsBadges:
  • Select reserved words in Oracle

    How can I select reserved words in Oracle. For example: In T-SQL, I'm able to select a column that's called table by using Select [table] from tablename. But I can't figure out how to do it with Oracle. Thank you very much.

    ITKE392,085 pointsBadges:
  • T-SQL: Split numbers into a table

    For T-SQL, I have to split 1,2,3,4,5,6,7,8,9,10 9 into a table (also comma delimited). How can I do that? Is there some sort of function that I can return each one in a row? Thank you so much.

    ITKE392,085 pointsBadges:
  • A01 Extension File

    Hi, It is some kind of DB file which has extension .a01. But I can't read the file because it's not clear. When I open it in notepad, it displays ASCII (Encrypted Format) only.

    Rupees15 pointsBadges:
  • How to read PDF file in Windows Form applications, files saved in SQL Server database

    How can I read a PDF file in Windows Form applications, files saved in SQL Server database?

    DotnetLearner5 pointsBadges:
  • SQL Server: Getting the identity from an inserted row

    For SQL Server, how can I get the identity of an inserted row? Do I have to use @@IDENTITY or IDENT_CURRENT? Thanks so much for your help.

    ITKE392,085 pointsBadges:
  • SQL Server: Should I use SELECT*?

    Particularly in SQL Server, I'm wondering if I should use SELECT*. My friend told me that it's necessarily good practice and it has caused several performance problems for his database. Should I use it? If so, how should I go about it?

    ITKE392,085 pointsBadges:
  • How do I update existing record in CildTable with NEWID while creating new record in ParentTable with same GUID

    First, let's insert a record into ChildTable: INSERT INTO ChildTable (DataCol3, DataCol4) VALUES ('Rec2-1','Rec2-2') As indicated in your article, ChildKey PK populates automatically. When I try to create a new record in ParentTable that is linked to the record previously created in ChildTable I'm...

    Exsellerate5 pointsBadges:
  • Clustered or non-clustered primary key in SQL Server?

    For SQL Server, I'm creating a test database and I'm debating if I should use NONCLUSTERED or CLUSTERED primary key. What's the difference between the two? Is there a preference of one over the other?

    ITKE392,085 pointsBadges:
  • How to compare fingerprint images in VB.NET

    I'm working on FINGERPRINT RECOGNITION SYSTEM. I'm using VB.NET as front end and SQL Server 2000 as back end. I had saved fingerprint images in sql server using image datatype, now I need suggestion on how to compare fingerprint images.

    Dlfshweta5 pointsBadges:
  • Setup query execution plan for stored procedure in SQL Server

    I'm currently using SQL Server and I need to setup a query execution plan for my stored procedure. How can I go about this? Can I use SSMS? Thanks!

    ITKE392,085 pointsBadges:
  • How to send stored procedure parameter to Trigger?

    I am sending a parameter from ASP.NET web API to a stored procedure. Now how do I send that SP parameter to Trigger?

    AnshuRishiPratapReddy5 pointsBadges:
  • SQL Server: How do I add an identity to my existing column

    On SQL Server, I'm trying to change the primary key of my table to an identity column. But there's already a number of rows in the table. I created the script so the IDs all start at 1. Is there a command that can alter the column to have a identity property? Thanks!

    ITKE392,085 pointsBadges:
  • Reinstall SQL Server on Samsung Medison EKO7 machine

    How do I reinstall SQL Server on Samsung Medison EKO7 machine?

    AdewaleAdebayo5 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