• SQL Server error message: Access is denied

    For SQL Server, I have a database on my machine and then created a backup of my tables. I just moved my backup to a remote machine without the table. But when I tried to restore it, I keep getting this error: System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is...

    ITKE413,460 pointsBadges:
  • Error message when restoring .BAK file on SQL Server

    I've been trying to restore a .BAK file on SQL Server for the past few days but I keep getting this error message: Msg 3241, Level 16, State 7, Line 1 The media family on device 'c:\glyn\JA.bak' is incorrectly formed. SQL Server cannot process this media family. I've tried several queries on 2008...

    ITKE413,460 pointsBadges:
  • 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!

    ITKE413,460 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!

    ITKE413,460 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.

    ITKE413,460 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.

    ITKE413,460 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.

    ITKE413,460 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?

    ITKE413,460 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?

    ITKE413,460 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!

    ITKE413,460 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!

    ITKE413,460 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.

Thanks! We'll email you when relevant content is added and updated.

Following