Apparently someone did not read the referenced article before submitting the QOD:

Transparent Data Encryption and FILESTREAM DATA

FILESTREAM data is not encrypted even when TDE is enabled.

Here is a free ebook on beginning SQL (emphasis on SQL not SQL Server). Just click on the links for the chapters to get started.

http://www.informit.com/library/library.aspx?b=STY_Sql_24hours

Since osql is being depricated, probably the better route is to create a backup SQL script for the targeted databases to backup such as:

BACKUP DATABASE [TestDB] TO DISK =...

I would not use the pause statement, if you do, the batch script will wait indefinitely for the user to depress a key.

You can download the SQL Server 2005 Express Advanced Version here:

http://www.microsoft.com/Sqlserver/2005/en/us/express-down.aspx#advan

It's about a 230M download but is SP3 and includes all of the advanced tools.

When you installed SQL Server 2005 express, did you install the 'Advanced Services' version or just the default version. You need the one with 'Advanced Services' capability.

I am using SQL Server Express 2008, and there are several tools available to use to manipulate the databases. If you look in the following folder:

\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE

You should...

Have you tried the Database Copy Wizard?

You can use the "Copy Database Wizard" which can copy or move a local database to a remote or networked database server. You probably have to add the wizard under...

Use the DTSWizard to import data from an excel spreadsheet. The target DB and table will have to be specified as well as the source file.

Triggers are generally used to perform some action when an event occurs. What event are you wanting to trigger off of? I.E., [Insert], [Upate], [Delete], etc.

In addition, if you use the -T flag for a trusted connection, you may have to enable 'Named Pipes' protocol.

Hi,

I used the below query to BCP out to a csv file successfully. SQL version is SQL 2008 Express running on Windows XP SP2. I've replaced the DB name, table...

I am using SQL Server 2008 Express, and when I run the same command that you reference here, i.e., [C:>bcp -v] I get the following output:

C:\>bcp -v

BCP - Bulk Copy...