• It seems our SQL database is corrupted

    Hi, Is there a way to completely check a SQL-Anywhere database (5.5.05) integrity? "Validate" won't help: we had databases that were broken but "validate"  always told us that everything is o.k. :-( I had the idea to simple read every record in every table (first "select count(*) from...", second...

    basrhaidi5 pointsBadges:
  • SQL server query to search for table and column data in database

    I want to find the data in a table,but i dont know the table name and column name.All I know is the data and the database name .Is there a query to find the table and column

    Linu438910 pointsBadges:
  • SQL database page level corruption

    Hello Experts, We are facing page level corruption in SQL database. The database size is 650 GB. What should we do?

    DBAPriya30 pointsBadges:
  • Starting a career as SQL database developer

    I recently have finished my btech 3rd yr via cse. I am quite interested in SQL so I want to be a SQL database developer. So please guide me in what other languages I should learn and what other skills I should learn too.

    Rajiv62535 pointsBadges:
  • How to create a SQL database

    I want to create a SQL database. What are the software requirements and where do I get the software?

    DouglasMonaco45 pointsBadges:
  • Data Storage – SQL Server

    Hi Guys, I have a question. When I enter data into SQL server where it stores, I mean database file where can I find it? I'm unable to locate it in the C drive.

    prasanna1235 pointsBadges:
  • Create downloadable file that will install a virtual server and services

    How can I create a downloadable file that will install a virtual server and install certain services and programs to a PC? So a user must be able to download the file to the PC that will then when opened it will install A Virtual server and certain programs as well as a blank SQL database hassle...

    SilenT1100105 pointsBadges:
  • ERP form error message on a SQL database

    We have a problem with the ERP system on our SQL database. Whenever an ERP form at our client’s end remains idle for 15 minutes, an error message pops up when the form is made active again. This message is: “FRM-40733: PL/SQL built-in DBMS_ERROR_CODE failed.” Our DBA team is blaming it on a...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Set default value on SQL database table

    I have a SQL database that has a column with several tables. I need to create a trigger (or even a stored procedure) that would set the default value for the column in all these tables. How can I do that? Hope this question makes sense. Thanks.

    ITKE1,101,045 pointsBadges:
  • SQL database recovery from corrupt database file!

    Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few days ago I lost some part of my data due to accidental deletion. I backed it up, so I tried to restore the database from the .bkf file. The problem comes...

    chengchong365 pointsBadges:
  • SQL database only with LDF file

    Is it possible to restore a SQL database with the latest ldf file because the MDF file is corrupted? I was hoping that data is still there. I actually have a backup of the MDF file of last month. But the MDF file this month is damaged, and the ldf file still normal. Can I use the. MDF file backup...

    ArturKis25 pointsBadges:
  • SQL database rollback query

    How do I roll back in case the database changes all data to the same information?

    twatonny015 pointsBadges:
  • Automate SQL Azure database backup with SQL script

    We're generating millions of SQL scripts per day so we can backup our SQL Azure database. But instead of manually, we need to do it automatically. What's the process to do this? Thank you.

    ITKE1,101,045 pointsBadges:
  • Rename SQL database table

    For my SQL database, I have to rename one of my columns. What's the process to do that? Will a specific query work for this? I just have to change the name.

    ITKE1,101,045 pointsBadges:
  • Find SQL database table in Java

    I'm using both SQL and Java. Now, in Java, is there a way I could find out if a table exists in my SQL database? Do I have to write a query for this?

    ITKE1,101,045 pointsBadges:
  • SQL paramaters

    How do I input a date for query to an SQL database from Visual Studio.

    Jerrymack25 pointsBadges:
  • Set auto increment key in SQL Server database table

    For my SQL Server database table, is there a way I can auto increment the primary key? I tried to go into properities but I'm not seeing anything. A co-worker told me about the identity specification property -> set it to yes but I'm not seeing that at all. Can someone help me?

    ITKE1,101,045 pointsBadges:
  • Select data from two different servers in two SQL Server databases

    Is there a way I can select data, in the same query, from two different SQL Server databases that are on two different servers? How can I do this?

    ITKE1,101,045 pointsBadges:
  • SQL Server database list of name for tables

    On SQL Server, is there a way I can get the list of names for all of my tables in a specific database? Please note that this is for SQL Server 2008 or 2012. Thanks!

    ITKE1,101,045 pointsBadges:
  • Three ways to login in to SQL database server?

    Does anyone know what are the three ways to login in to SQL database server?

    melbourne5 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