• 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:
  • how to use databases made in access or excel in sql

    how to use databases made in access or excel in sql   importing readymade databases in sql

    Dragan1525 pointsBadges:
  • How do you set a SQL Server job step status?

    I am running SQL Server 2005. I have a job that has six steps to load a database table from an external source. The external source is required to send the file nightly. In system testing I found this is not always the case. I created a batch 'step' (Step 3) to check if the file has been sent (see...

    Redwine20 pointsBadges:
  • Need project plan for Access 2007 database migration to SQL Server

    project plan with steps outlined

    Anflores5 pointsBadges:
  • Best tool for SQL Server 2000 – like golden is for oracle

    what db tools are there to query ms sqlserver 2000 database? i'm used to using benthic's golden for oracle databases - and would like a similar tool to use with sqlserver databases.

    Angeliamcdaniel5 pointsBadges:
  • Recursive Association with compound primary key in SQL database

    Hello, I'm afraid I'm very new to this and really struggling. I have a table with a compound primary key composing of Code, Date, Client to represent an attendee on a course. I need to include a 'Lead Client' column to represent a recursive relationship where one attendee can be nominated to lead...

    Littlegreen15 pointsBadges:
  • SQL servers merge transactions

    In vb.net windows application,i used sql server 2008 for database. For deployemnt and implementation process, we used currently the sql server is in the web.client have different locations and want to access application from any where. The problem is at some rural area the internet down time is...

    Qqqqqqqqqqqqqqqqqqqq20 pointsBadges:
  • Can’t bring master database back online

    hi,i bring master database into offline. after that i tryed so many times to make master database as online.But i did't get that one into online(production side)wht is root cause for that?

    241219840 pointsBadges:
  • What is the best way to replicate SQL 2008 DBs to a failover site?

    We are looking to replicate our SQL 2008 databases to a hot failover site.  We can't use DB mirroring due to the number of databases we have.  Has anyone replicated databases to a hot site using a replication solution and what was your experience.

    DaveMPA55 pointsBadges:
  • Delete all tables in SQL Server database?

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

    Prcvjr220 pointsBadges:
  • Using Excel 2010 to pull data from SQL Server?

    How can I use excel 2010 to pull data from my sql server? I have an odbc connection set up and need data from a specific table in a specific database. I want excel to do some projections and calculations.

    NewnanIT1,110 pointsBadges:
  • How to find Windows Operating system values for SQL database: OSId, Descr, Edition, ver, arch,

    I'm managing a large group of virtual machines using SysCenter Virtual Machine manager (SCVMM). I want to add data to the SQL Database for SCVMM application so that additional operating systems will be available in the properties of the SCVMM application. I know how to do the statements which add...

    007jet5 pointsBadges:
  • Help navigating SQL Server 2008 database?

    Hi all, I'm facing an interesting challenge... Lets say: I have a payment coming in and of course my client has not specified which of the 45 open invoices he is paying. The amount does not match any single invoice so it has to be a combined payment for 2 or more invoices. Now, I can get my...

    Palloquin95 pointsBadges:
  • How to display values in one table by referring and checking values in another table?

    how to display values in one table by refering and checking values in another table

    Sqldb5 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