J-F Bergeron (7/29/2009)

---

Or append it in a single variable using FOR XML PATH('') with semicolumns as separators. But everything will be run in the same batch, don't know if that...

The encryption stuff is all 3rd party, there are a number of vendors, PGP is probably the most common.. Do a search on google with this term: command line...

The table value approach is...

I think Jack and I are on the same track today..

You need to be careful about nesting UDF use with UDFs, because of their use they can make a big...

You could write the output into a table variable and then pull the rows out one-by-one using a CURSOR (I know, I know), or some cursor-less loop. When you...

Jack is on the right track, it isn't so much about licensing with Express as opposed to living with the limitations imposed. If the client can live with the...

Unless you are in a banking/lending company the data does not likely need right protection. With that said, what are you really worried about, somebody with a network sniffer...

Are you worried abou them in transit or at rest.

You could use some command line encryption routine and encrypt them then delete the clear-text file then copy the encrypted version.

Why...

Nope, windows only.. Now if you were running VMWare (or another similar package) on a SUSE host with a windows guest..

CEWII

My first thought was their tech support was misinformed (to be friendly)..

Express supports the same authentication methods that the other editions do. As far as the portfoliocenter software I...

SQL Server supports 2 authentication methods, integrated (aka Windows or trusted) and SQL.

Forms authentication is (as I remember) as web page authentication term and has very little to...

The method specified will not tell you what tables are only for this session..

Also, I'm curious what you need this information for, once the session ends they will be dropped...

Be proactive, do a if exists check on the key value before the insert and then you will know before the insert whether it would would fail or not. ...

First off I wanted to point out that they aren't asking for 32 seperate locations, they are saying that 32 is the max. Most of us have seperate data,...

Is Express running, I don't think it is set to start automatically. Also is SQL Browser running? If not it might not be able to find it. ...