What I have done in the past for a similar situation....

 You could set up an FTP server at your remote end (where you are) and set up a SQL Server Agent...

What about modifying the application name or hostname parameters in the OLEDB connection string?  They are easily retrievable from SQL and needn't contain the data implied by their name -...

This seems needlessly complex - I just made a UDF that recursively calls itself with more than 1 parameter in my temp database and it works fine?

Example (and it's a...

Well for 11, you might have to have a profiler trace with very particular filters running to catch such statements against your database.

For 12, I assume you mean recording say,...

Very good article - I have to implement something like this soon.  Whilst I usually ensure that I do all data manipulation from apps via stored procedures, it would be...

What about....

select

RowID,

(

    select value

    from MetaValue MVI

    where MVI.AttributeID = 1 and MVI.tableID = 1 and MVI.RowID = MV.RowID

) as ArtikelNr,

(

    select value

    from MetaValue MVI

   ...

Yeah tis getting a bit tricky.  Which way is the match going   I got confused - although lack of sleep lately isn't helping! ...

Do you mean that the variable @key, which is a varchar of sorts, would have several IDs in it such as

@key = '1, 2, 3, 4,...

What is he using to develop the app?  If he has visual studio from microsoft, it comes with MSDE, etc which he can always use to develop against (does Vis...

That's an internal SQL error - you should send it to MS.  Or do a quick google search on it.

Or, just take the SQL v7 file (just the .MDF), copy it to your new server and use

sp_attach_single_file_db to attach it and SQL will create a new log file for...

You can use the stored proc

sp_attachsinglefiledb

Copied from books online...

Yes, SQL Server lincensing (in 2000 anyway) is definitely on the "honour system".  I think it probably has to be as it would almost be "unfair" for SQL to deny...

Maybe not having Exchange is the problem - if another app (such as SQL server) uses my Outlook via MAPI (as SQL does) to send an email message and Outlook...

I am not terribly familiar with how PHP works, apart from knowing that it looks a bit like PERL which was ugly to use!