• Where is the backup for SQL Server database located?

    We've been trying to create a backup for SQL Server database using SQL Server Management Studio 2008. We were able to create the backup but it's being saved at some path that we can't find. We saved it on our hard drive but it's not there! What should we do?

    ITKE366,885 pointsBadges:
  • Issues deleting records in SQL database

    I'm having issues deleting records in a SQL database. What should I do?

    rockquery45 pointsBadges:
  • Should I move my SQL database to NoSQL?

    I have a very large table (roughly 100 million rows and 35 columns) and it's currently stored in a SQL database. However, my queries are running very slow at the moment so I'm wondering if I should move to NoSQL. But I have a few questions: Which NoSQL database should I use? Is there a way to move...

    ITKE366,885 pointsBadges:
  • What’s the best way to create a cloud-based SQL database?

    We have a website that's currently being hosted on Amazon S3 and it's working fine. But we have run into a problem with our data (and it's static). So the next step we're looking at is to create a SQL database in the cloud so we can store user data. Could we possibly do this through Amazon AWS or...

    ITKE366,885 pointsBadges:
  • Need project plan for Access 2007 database migration to SQL Server

    Does anyone have a project plan for Access 2007 database migration to SQL Server?

    Anflores5 pointsBadges:
  • Linking Visual Basic and SQL database

    I wish to know a code that can enable me to link Visual Basic and SQL database in an organisation.

    131113115 pointsBadges:
  • The specified module could not be found

    We are trying to install a software (on about 70 workstations) that uses a SQL type database that is stored on our server. We all have Windows XP and our server is Windows Server 2003. About half the Workstations are able to connect to the database with no problems. The rest are unable to connect...

    Kc54555 pointsBadges:
  • List, Save and FTP list of all databases

    How do I run a job to list all SQL databases on a server, save the output and then FTP the output file to another server?

    Mistp00120 pointsBadges:
  • SQL 2005 Database Compare

    If there a way to compare two similar database to find where a Stored Procedure is different between the second database. Different in it not there or the Create Date or Modify Date is different?

    SQLNovice15 pointsBadges:
  • SQL Server Data Files and Threads

    I am reading a Microsoft Press Book MCTS Exam 70-432 and in chapter 2 it talks about Data Files and it says "SQL Server creates a thread for each file underneath a database. As you increase the number of files underneath a database, SQL Server creates more threads that can be used to read and write...

    Rick Martinez585 pointsBadges:
  • SQL Connection

    Using VB6 How can I build a connection code to connect to SQL DB

    Khl5 pointsBadges:
  • Insert values into database from form VB.NET

    Hi guys, Having a bit of trouble with inserting values that i have in my form into my SQL database. Basically it supposed to calculate a customer who borrowed a DVD or CD. I select the date that the customer brings the returned item by selecting a datepicker. The calculation works fine, but i want...

    Darthswift0040 pointsBadges:
  • SQL Server 2005 database conversion

    Hi, we plan to migrate SQL Server 2005 from SQL Server 2000. We have a database with average size of 12GB. Can any one please let me know how to convert our database from SQL 2000 to SQL 2005.Thanks in advance.

    Anto5 pointsBadges:
  • Exporting a SQL database to MySQL

    I have a MS SQL .BAK database that I need to convert to MySQL. I was able to import the database but not actually export to MySQL. A friend of mine told me to use MySQL Migration Toolkit but it's been replaced by MySQL Workbench. Can I use this tool to migrate the database? Or is there another way...

    ITKE366,885 pointsBadges:
  • Delete all tables in SQL Server database?

    How to delete all tables of a database in SQL Server?

    Prcvjr220 pointsBadges:
  • How to read a table in SQL database

    How can I read a table in a SQL database?

    vSphereadmin5 pointsBadges:
  • Setting database security to prevent restoring databases on other SQL Servers

    Within a database in my SQL Server, I am able to control users from Alter Table and Alter SP, and a strong ‘sa’ password is also created. When I login to the backup of that database with a backup operator ID, the backup operator is able to restore the database, and his and others’ rights are...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Create A Fixed Text File From SQL DB Table

    Hello programmers. After doing much research I am unable to resolve how or where to custom format each field of my SQL table output into my text file. Can someone help me with enhancing the below vb script? I need to reformat certain values. Do I do the formatting in the Dim section or in the if...

    Ilfoprog50 pointsBadges:
  • How to Display Japanese character in Crystal Report 8.5

    Hi, I've some data stored in Japanese language in SQL Server 2005 database using nvarchar datatype. When I execute store procedure in SQL Server, it's showing japanese character properly in SQL server. However, when I'm trying to display data in crystal report 8.5, it's showing ????? character....

    Kaushalp50 pointsBadges:
  • Can somebody provide me SQL questions based on various situation?

    I have started working on SQL DB. During an interview question, there were various situations given through which we need to write some queries. Questions/ Situations where UNION , ORDERBY , JOINS , DATE Functions and others are used. Can somebody provide me SQL Join situation questions for...

    Mayurkhe295 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