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

Retrieving data tables without backup SQL
If I truncate a table without the backup of it, how do I retrieve the table data?

Answer Question   |  April 9, 2010  3:23 PM
SQL Data Types, SQL Server backup, SQL Server tables, SQL tables

SQL Data Types Conversions
I’m new to SQL. Anyone have a good example or link of converting from one data type to another. We are converting from an iSeries (AS400) to SQL-based ERP solution and we are having some difficulty with how to get data from numeric fields to date or “numeric” data types. Our iSeries ERP solution had [...]

Answer Question   |  March 24, 2009  2:41 PM
ERP, iSeries, iSeries Data Transfer, SQL, SQL Data Types

Correct database format for Rich Text/HTML?
I’m new to SQL and am creating a new database and I am wondering what format would work best. I am looking for the query results to be formatted (specifically hyperlinks and paragraphs). I am thinking that I need to go with XML to get this type of formatting. Is this the way to go? [...]

Answer Question   |  March 4, 2009  3:07 AM
Database Data Types, Rich text, SQL Data Types