Is field level encryption with symmetric keys available in SQL
Server 2005 Express?
     I tried to execute CREATE MASTER KEY ENCRYPTION BY PASSWORD.....
but it did not seem to recognize the keyword MASTER or ENCRYPTION.

I need to create setup file, which will install SQL Server Express and
my application on windows xp. Any ideas?

Hi
I am using SQL Server 2008 DE and I am not an expert in writing SQL scripts
but I am having a problem resolving simple issues:
1) When I want to store a string that would include single quotation (') I am

Run this query:
select 1x, <choose any column> from <choose any table>
Can anybody explain?
/k

I want to use union join to build up a view
Howerver, it  seems i only use inner,left,right join.

Two different SQL 2005 x64 installations on Windows 2003 Server x64. Both
call a simple extended stored procedure from QA.  On one server it works
fine. On the other, almost identical server it never returns and the
instance hangs.

I get the 'Invalid length parameter passed to the substring function' error
when executing the below script. I am not sure what I need to do to correct.
Thanks in advance for any help.
select LastName, FirstName, MiddleName

I picked up a routine from a old employee where he insert about 1000 record
every  30 minutes, he is going in a loop until finisih reading the file and
calling an insert for each record. That is taking a while a is slow, tha
table has 22 million records !!...

I am running a SQL Server 2005 Database.
My requirement is to pass a list of machine names (one at a time) as a
parameter to a Stored Procedure.
So let's say I have a table HOSTNAME with one column 'host' containing all

Seems like everyone here is very well versed in the art of SQL server
programming! I was hoping to get some good advice on what books should
I purchase so I can learn to design a database for our small business
using SQL server. I have everything running in Excel and have done

For an application that experiences heavy writes to the database,
could this be a solution?
The application itself uses a 3-tier model. When a entity needs to
persist, the DAL creates the query needed to persist (could be an

I have the tables
1. Customers
2. Orders
3. Payments

I don't know the English expression of a Primary Key existing of two
(or more) fields. Directly translated from Danish it would be
"concatenated key" - is that it?  :-)
However, that's what I have. I need to know which is the last inserted

I've got a bunch of third party generated tables with weird hex names.  They
all start with # and not ##.  (This is in 2005 btw.)  I want to look in those
tables, i.e. SELECT top 10 * from #hextablename and see what's in there.  But
since they are #, I can't see inside I presume ...

This error has begun appearing when this Sp is run.
Msg 207, Level 16, State 3, Line 1
Invalid column name 'May 2009'.
The strange thing is that i have two databases - one a test system,