• How to use SQL Server 2005

    I have installed SQL Server 2005 but I want to know how to open SQL Server and connect the DB.

    Anand79865 pointsBadges:
  • Accessing another database using a variable

    I have a select like this: SELECT a.part_id, a.descript, b.location from PART_MASTER a, anotherdatabase.INVENTORY b where a.part_id = b.part_id Is it possible to use a @variable to identify the other database, rather than hard coding it? (I've tried @db2.INVENTORY b) but SQL SERVER 2000 doesn't...

    CO Bill120 pointsBadges:
  • SQL Authenticated user change his/her own password

    We have an Access application that leverages ODBC DSN to link to SQL Server 2008 database. SQL Authenticated logins and passwords have been created for each user on the SQL Server, these logins have been granted access to the SQL Server database. When creating the logins: Enforce password policy,...

    TLMercer45 pointsBadges:
  • How to retrieve tables?

    My SQL Server 2005 database get corrupted because of a virus infection. No tables are showing now. My database folder contains .mdf, .ldf and file (3 files) can I retrieve my tables using one of this. Any solution please? I don't have any other backups. Please get a solution.

    DatabaseRecovery35 pointsBadges:
  • Database Recreate

    My SQL server 2000 Database is corrupted because of a virus infection. No tables are showing now. My database folder contains .mdf, .ldf and file (3 files) can I retrieve my tables using one of this. Any solution please? I don't have any other backups. Please get a solution.

    DatabaseRecovery35 pointsBadges:
  • Recovering .mdf and .ldf files from SQL Server

    I backed-up our SQL Server yesterday around noon, and we then added more data in. Today, when we tried to start our application, we found that the database is in SUSPEND mode. We stopped our SQL services and tried to copy the newer data, but there was a data error. It seems that our .mdf file is...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Restoring a SQL database with an .mdf file

    How can I restore a SQL database with an .mdf file?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Load balance of SQL database

    When my database has grown beyond the performance capabilities of a single SQL Server, what are the ways get increase the system performance?

    RASHMIMB15 pointsBadges:
  • Data base 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:
  • Use of database backup from lower version to higher version of sqlserver

    I am using sqlserver 2000, have a database of 2GB. I want to shift at higher version 2008. What I have to do TO upload my Old version-2000 database backup  into  sqlserver 2008

    Vineet2820 pointsBadges:
  • SQL Server 2005 backup server

    Is there a way to replicate a SQL server database to another SQL server with the same hardware and software? I want a live copy of the data up to date in case something goes wrong and we need to switch to the backup server.

    NewnanIT1,110 pointsBadges:
  • Error message when restoring a SQL Server database

    This error received when restoring a SQL Server database: System.data.Sqlclient.Sqlerror:Create Database or Alter Database failed because the resulting cumulative database size would exceed your licensed limit of 4096MB per database.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Connection of VB6 with SQL Server 2000

    I want to connect VB6 application with SQL SErver database such that if anything is saved in VB6 forms it will be saved in the database tables of SQL Server.

    Jayee5 pointsBadges:
  • SQL Server active/active node clustering

    I need to scale my applications to support the future volumes. We are using sql server 2005 service pack 2, on a active and passive node cluster environment. Can I add another active node to the cluster and create a grid environment to scale my enviornment, without impacting any of my current...

    Ndtvenkat20 pointsBadges:
  • I want to create backup of SQL database and set a password.

    HEllo All  i want to create backup of SQL database and want to set Password that anyone who restore this backup after that it cant be able to restore database without knowing perticular Password .... is this Possible....? if Yes please tell me How...? Thanking You Raviraj

    Raviraj1235 pointsBadges:
  • Trigger or Stored for lock and unlock database for 15 minute

    Dear Sir, I create a login form in which if you insert password 3 times wrong then u r account is locked for next 15 minute. and we send a random password  on referenced emailid which is sent after 15 minute. For these 15 minute the account isactive='false'. So can u please help me to give code...

    Programmer0075 pointsBadges:
  • SQL Server Data File Storage

    We have a SQL Server with 32GB of RAM, 8 CPU 16 Cores, using SAN. On our production database (1 database only) we have 3 file groups Primary, Core, Index with 1 file in the PRIMARY Group, 16 Files in the Core Group, and 16 Files in the Index Group. Each file group including all data...

    Rick Martinez585 pointsBadges:
  • International SQL Server Replication

    I have a unique challenge involving keeping 2 SQL Server Databases in synch, one of which will reside in Iraq, the other will be in a base camp in Kandahar, Afghanistan where the local clinic will use a client application that communicates to the local database. The database in Iraq will be for...

    MattPoirier15 pointsBadges:
  • SQL Server 2005 database installation

    i installed sql2005 s/w in my system.but i don't know how to use it.i don't know how to create database and manage and all.can u help me?

    Saranya885 pointsBadges:
  • Experience applying SP4 to SQL 2005?

    Hi, I have a Microsoft SQL 2005 SP3 database server with 2 instances (both patched to SP3.) The one instance (1a) includes 52 small production databases. The other instance (1b) includes 2 large production databases. Now I would like to upgrade the (1b) instance to the new Service Pack 4. The way I...

    CarlMarius15 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