Find a particular text from all tables in DB.
Hi There are 100 tables in my DB. I want to find if a text say “ABCD” is availbale in any these 100 tables. If it is availbale can we list those tables. Can someone help me out with the Query.   Regards Mayur

Answer Question   |  January 15, 2010  11:46 AM
SQL Server, SQL Server database

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 server-side encryption solution that would have minimal impact on performance and business processes? [...]

Answer Question   |  December 7, 2009  10:12 PM
.NET 2.0, SQL Server 2005, SQL Server database, SQL Server encryption, VB6

Email Notification
Hey i am 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 recieve an email informing them that they have been assigned to a job… can anyone help me out with how [...]

Answer Question   |  January 23, 2010  12:09 AM
SQL Server database, VB.NET

Replication sync_method set to concurrent in SQL Server 2000
Hi, Just wondering what happens to data that are inserted during the time of a snapshot replication generation when the sync_method is set to concurrent, as there are no table locks, are the data insert into the publisher then held in the distribution database and when the snapshot has been completed, the data in the [...]

Answer Question   |  October 22, 2009  12:24 PM
SQL Server 2000, SQL Server database, SQL Server replication

how to use sql server 2005
i have installed sqlserver2005 but i want to know how to open sql server and connect DB

Answer Question   |  February 23, 2012  12:28 PM
SQL Server 2005, SQL Server database

Data model for Custom fields and Custom forms.
Hi, I plan to build a web application which would have dynamic forms with custom fields. he can create one module, web form having some custom fields.So these fields can be created by customer itself through web application. To make this enable i believe I should have some tables to store meta data details of [...]

Answer Question   |  September 10, 2009  8:11 PM
data model, Dynamic Forms and fields, performance, SQL Server database

SQL Server Database Restore
When i restore a database from server1 to server2 as stand by/read-only mode the database restores with a database owner “domainrmartinez”. How can i restore a database from server1 to server2 and the database owner as “sa”?

Answer Question   |  September 4, 2009  9:21 PM
SQL Server, SQL Server 2005, SQL Server administration, SQL Server database, SQL Server database restore

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

Answer Question   |  April 3, 2012  9:22 AM
C++, SQL Server, SQL Server database, Visual C++

Adding data in SQL 2005 server
i am trying to add data on an sql database from backend problem is it does not acceptnull values kindly help. My email address is edmuia@yahoo.com

Answer Question   |  August 6, 2009  2:00 PM
SQL Server 2005, SQL Server database

SQL Server Database Date Time Values
I am developing a software using Date Time values. i am using SQL server 2000 as the database. can i create a coloumn with only time value or data value. Only datetime is available. how can i eliminate a part of it in the database. when inserting the time values the date part is 01 [...]

Answer Question   |  July 30, 2009  4:11 PM
SQL Server 2000, SQL Server database

sql in C#
How can I attach And detach a database file to sqlserver in C# code ? please give me an example of this

Answer Question   |  July 15, 2009  3:05 PM
C#, Database Files, SQL Server database

SQL Server error: Cannot find log file
I am receiving the error, “cannot find log file.” I detach the database and I am unable to reattach it because of the error. I created a new database and copied the MDF. When I restarted the SQL Server, I am told the database is suspect. What can I do to fix this error?

Answer Question   |  July 15, 2009  2:52 PM
MDF, SQL Server database, SQL Server error messages, SQL Server errors, SQL Server logs

Issues rebuilding system database on SQL Server Express 2005
I am having some trouble rebuilding the system databases on my SQL Server Express 2005 instance. While I have had a total system failure, the backups have been good. I have restored the operating system but obviously there are no SQL system databases present (they were open at the time of the backup). So now [...]

Answer Question   |  July 7, 2009  2:32 PM
SQL Server 2005, SQL Server database, SQL Server databases, SQL Server Express, SQL Server Express 2005

Shrinking a SQL Server database
What is the best way to shrink a database? What are the alternative methods?

Answer Question   |  July 6, 2009  4:57 PM
SQL Server database, SQL Server Database Consolidation, SQL Server databases

Backing up SQL Server 2008 databases to a tape drive
I am running Sql Server 2008 and I need to know how to make backups of the database onto a tape drive. How do I do this?

Answer Question   |  June 25, 2009  10:36 PM
Backup to Tape, SQL Server 2008, SQL Server backup, SQL Server database, Tape Backups

SQL Server 2000 Database Table Limit?
Is there a limit to how many tables a single database can hold in SQL 2000?

Answer Question   |  May 7, 2009  8:18 PM
SQL Limits, SQL Server 2000, SQL Server database, SQL Server tables

Linked SQLServer
Hi, In oracle database you are able to link the oracle database to a SQLServer 2005 database, I want to be able to link a SQLServer 2005 another SQLServer 2005 database (not another SQLServer 2005), does SQLServer 2005 allow us to do this? Does it only allow server to server linking? Thanks.

Answer Question   |  April 27, 2009  10:49 AM
Linked SQL Servers, SQL Server 2005, SQL Server database, SQL Server Linked Server

Connecting a SQL Server database with Visual Basic 6.0
What code would I need to connect a SQL Server database with Visual Basic 6?

Answer Question   |  October 25, 2009  8:23 PM
SQL Server database, Visual Basic, Visual Basic 6

Using SQL Server databases on data with numerous checks
I am interesting in cleaning census data, and I have a number of edit checks, consistency checks, validation checks and range checks to perform. What is the best practice you would recommend, using SQL Server as the database?

Answer Question   |  April 8, 2009  5:17 PM
SQL Server, SQL Server database

Backup Performance Compare
How or what can I use to compare the performance of the backup performed when the database is configured to use the simple recovery model versus the full recovery model.

Answer Question   |  April 7, 2009  4:26 PM
SQL Server 2005, SQL Server backup and restore, SQL Server database, SQL Server performance