• Truncating the transaction log for a SQL Server 2000 database

    What is the best automated way to truncate the transaction log for a SQL Server 2000 database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Database Views in SQL Server

    When I open database expert and open a new DB connection, only tables and stored procedures are shown. How do I get views to show? And yes, I did select views under options/database.

    Jwcurrier30 pointsBadges:
  • Adding a password to a SQL Server 2005 database

    We are moving our Microsoft Access database to SQL Server 2005, and the Access database has password protection. How can you add a password to a database in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Backing up and copying a database across SQL Servers

    I have SQL Sever 2005 on both servers A and B, although I do not have SQL Studio Manager on server A. I would like to backup a SQL database from server B onto server A, and then copy it over to server B and restore it to the same database. How would I go about doing this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can we reindex a SQL Server 2000 database?

    We have a SQL Server 2000 database that has never been reindexed. Do you have any suggestions? Is there a link to a step-by-step process for SQL Server database reindexeing you can share?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to implement an Entity Relationship Diagram into a working database?

    I need to implement a ER diagram into a working database. I'm hoping to use Microsoft SQL Server 2005 Developer edition. I need to know all the details of how to implement an ER diagram such as what happens to a relationships between entities, how to implement "Is a" relationhips, how to implement...

    Obhasha0795 pointsBadges:
  • Implementing Encrypted SQL Server Database Columns

    This is the problem I'm facing: The database (SQL Server 2005) holds more than 5 million customer records. These records contain sensitive credit-card information that must be encrypted. Implementing an application-side encryption solution involves VB6 and .Net technologies. How to achieve a...

    Kansai5 pointsBadges:
  • Implementing a test system with SQL Server log files

    We need to implement a test system where the entries created in various tables on a test server need to be automatically re-generated on a live server so that there are no manual errors. We think the only way to do this is to use SQL Server log files. However, we are not sure that the tools...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Copy SQL Server Table

    How do I copy a table into the same database without including the data? Thanks ken

    Ilfoprog50 pointsBadges:
  • Column extention in SQL

    Hi I want to expand the number of columns that SQL would permit me to create. How do I start? any suggestions? example: 1032 maximum column limit I want in the area of upper 5000 range for a table. Someone help. Thanks!

    Ctc12320 pointsBadges:
  • SQL Server 7 database restore

    I'm working with SQL Server 7 and I made a backup from a Database and I need to restore it, but this error appear: "The RAID set for database is missing member number 1". What can I do?

    Claudiofuentes15 pointsBadges:
  • Creating a username and password on a SQL Server database

    How we can create a username and password on my SQL Server database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • If running two SQL Server DBs in two VMs, I should purchase two DB servers?

    If running two SQL Server db in two VMs, I should purchase two db servers? This question is from the Microsoft Virtualization Live Chat which took place on August 27th.

    ITKE407,235 pointsBadges:
  • Copying a database to a newer version of SQL Server

    I have a database on my SQL Server that needs to be upgraded to SQL Server 2005 or SQL Server 2008, but when I try to copy it with the Copy Database Wizard, I do not have the option “Copy” listed under “Tasks”. I am using SQL Server Express, which I think may be my problem. Is this...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Email Notification

    Hey I'm creating an application front end = vb.net and back end = SQL Server DB!! The application helps assign staff to jobs and when an assignment occurs I would like the staff to receive an email informing them that they have been assigned to a job. Can anyone help me out with how I would go...

    Keirameister5 pointsBadges:
  • Implementing access from a remote site to a SQL Server 2000 database

    I have been tasked to set up access from a remote site to a SQL Server 2000 database. The user interface was programmed in .NET. This database will sit outside our firewall and will be protected by its own firewall. The application currently uses an ODBC connection to the database. Do you have any...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Database hanged due to concurrence

    Hi to all. We have an application running under Windows 2003 Server, database SQL Server 2000, client/server, 60 users updating or consulting data. We did a concurrence test. We asked several users to search for same string at same time and the database got hanged. Will that be a configuration...

    Ome0015 pointsBadges:
  • Do all versions of Microsoft SQL Server 2005 support database mirroring?

    Do all versions of Microsoft SQL Server 2005 support database mirroring?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Creating database access at runtime for ADO and SQL Server

    I’ve put together some code to create database access at runtime using an ADO database connection. How can I do the same for a SQL Server database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Database with Visual C++

    I am learning on Data Base management. I have installed Visual C++ and will use SQL server. But I don't know which component else to install, and how to connect to and use SQL Server. Can somebody help me? Thanks a lot

    Makee15 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