First it is the Function Owner (which may be the same as the DB owner) and yes you have to specify it. If this is a problem then post your...

Open Enterprise Manager

Drill thru to your server then to the database.

Right click the database in the tree view side of EM and select All Tasks/Export Data...

Now in the Wizard go...

Cannot do this will soundex as it translates the whole phrase in the column and not the words. You could however right a procedure that looped thru all the words...

I had this problem and for me it was related to the MDAC installed (may have been just one of the dlls not registered properly). When I reinstalled the problem...

How is Agent configured as far as account runs under. It may not have the enough rights to access the file system and most likely unless you have an account...

Yeah, like uses [ as the begining delimiter for a list of character replacements.

Example.

If you wanted to find a list of items that started with A, C, D, or G...

Nothing in SQL itself that will do this any better. You might check for a third party app but most use roughly the same algorithem but may have data dictionarys...

You could also write an XP dll to do pretty much anything you cannot do directly in SQL in this case (such as sending data to a server using UDP...

And going back to your original question, the TDS I do not believe is enrypted in any unless you use multiprotocol with encryption turned on and so is visible to...

If you are talking about data entered in the text area, once gone then no.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

If however each SP has variances in the SELECTion field output then a common view can actually hurt performance since (as I have come to understand) the view will read...

I was working on a Sample I forgot to bring home, but the only way could think of is similar to an old trick in Access. Create a table with...

Great to hear you are at least finding a way.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Sorry doing this from the top of my head, no server to test against and no analyzer with nice color coding.

"Don't roll your eyes at me. I will tape them...

Not really fancy but you could try something like this

DECLARE @var AS INT

SELECT @var = RAND( (DATEPART(mm, GETDATE()) * 100000 )

...