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, Enforce password expiration and User must [...]

Answer Question   |  November 12, 2012  7:57 PM
SQL Server, SQL Server database

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.

Answer Question   |  July 13, 2012  8:36 PM
SQL Server 2005, SQL Server database

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.

Answer Question   |  July 12, 2012  11:42 AM
SQL Server 2000, SQL Server database

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?

Answer Question   |  May 2, 2012  10:18 AM
SQL Server 2005, SQL Server database

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

Answer Question   |  March 31, 2012  6:18 AM
SQL Server 2000, SQL Server 2008, SQL Server database

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

Answer Question   |  April 9, 2011  7:15 AM
SQL Backup, SQL Data Types, SQL Server backup, SQL Server database, SQL Server security

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 applications/sql statements/stored procedures? [...]

Answer Question   |  April 22, 2011  5:58 PM
SQL Server 2005, SQL Server 2005 Database, SQL Server 2005 SP2, SQL Server database

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 [...]

Answer Question   |  March 23, 2011  8:49 AM
SQL Database, SQL Server 2005, SQL Server database, SQL Server triggers

Create a database in SQL Server 2005
Create a database in sql server 2005 but database name passed as parameter into a stored procedure

Answer Question   |  March 7, 2011  7:05 AM
SQL Database, SQL Server, SQL Server 2005, SQL Server database, SQL stored procedures

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 files belonging [...]

Answer Question   |  March 7, 2011  3:28 AM
SAN, SQL 2008, SQL Server, SQL Server 2008, SQL Server database

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 billers to [...]

Answer Question   |  February 22, 2011  8:28 PM
Secure Data Transfer, SQL replication, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server database, SQL Server replication

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?

Answer Question   |  February 7, 2011  5:20 AM
SQL 2005, SQL Server 2005, SQL Server 2005 Database, SQL Server database

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 would to [...]

Answer Question   |  February 7, 2011  5:49 AM
Database Instances, SQL 2005, SQL Server 2005, SQL Server database, SQL Server multiple instances

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

Answer Question   |  January 21, 2011  1:34 PM
Access, C#, excel, Import external data, SQL Server, SQL Server database

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 [...]

Answer Question   |  January 17, 2011  11:28 PM
SQL Jobs, SQL Server 2005, SQL Server 2005 SP3, SQL Server database

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.

Answer Question   |  January 10, 2011  10:08 PM
SQL 2000, SQL Database, SQL Server 2000, SQL Server database

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 others attending [...]

Answer Question   |  January 3, 2011  11:53 PM
Database issues, Design principles, SQL, SQL Database, SQL Server database, SQL Server errors

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 high and user unable to do data [...]

Answer Question   |  December 20, 2010  8:04 AM
SQL Server 2008, SQL Server database, SQL Server synchronization, SQL Server transactions, SQL transaction logs

Need project plan for Access 2007 database migration to SQL Server
project plan with steps outlined

Answer Question   |  January 12, 2011  5:36 PM
Access 2007, Access Database, SQL Database, SQL Server, SQL Server database, SQL Server migration

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

Answer Question   |  November 16, 2010  8:28 AM
DELETE statement, SQL Database, SQL Server, SQL Server database, SQL tables