That sounds strange. Can you post your DDL, and is possible a reproducable scenario with data. Otherwise just sample data and expected vs actual results.

And what does downloading to a machine mean? Most apps 'download' answers to the machine. I can query with QA and copy the results to Excel, there is no way...

ISO 8601

There is a short description of it in my article: On the Trail of the ISO Week.

Use the COLLATE keyword. See this example (you'll have to change the collation for whichever you use):

CREATE TABLE FOO (bar varchar(10) COLLATE Finnish_Swedish_CI_AS)

go

INSERT INTO FOO VALUES ('AGE')

INSERT INTO FOO VALUES...

Ok, so the truncate problems are out of the question then. What was the error message that you got?

What version are you using? It works perfectly in June CTP.

I do not have a server to test with, but I suppose sp_helpfilegroup 'PRIMARY' might work. If you execute it with no parameters it shows all filegroups.

EXEC sp_helpfilegroup

Well, yes, you can use the STUFF function in the same way. But it is going to be much more complicated since you need to find out where to stuff...

As was said above, you can use triggers in SQL Server as well. Or, if you just want to see now afterhand what happened, you can use a tool such...

Uhm, not quite sure what you are looking for, but maybe something like this?

strSQL = "SELECT Server, Port, Database_name, ticket, Address " _

& "FROM SearchDB INNER JOIN db_tlog_maint_plan ON SearchDB.Fname...

Unfortunately, user-defined types cannot be used in table variables.

I haven't heard of anything like that unfortunately, but if you do find anything then please mention it here.

There is no way to set a timeout when calling sp_OAMethod. You could of course implement some kind of timeout mechanism in the method itself (possibly with a parameter to...

UPDATE foo SET bar = REPLACE(bar, '.(AABBCCDD)', '')