Make sure your tick the SQL SERVER box at the root of all the log files; this will automatically select all the log files. Then run your filter.

Logged events...

Just to back up Koen's comment, the file does need to exist first but once populated you can copy the file to another location as previously posted.

You can specify a dynamic destination in the File System task.

I found this after a quick Google; hope it helps.

http://sqlserversolutions.blogspot.co.uk/2009/04/copyrename-file-using-file-system-task.html

That's a a very big question as it covers so many facets! Only you as the developer and your business colleagues can decide if CLR is suitable for your environment.

A...

Personally, I try and avoid dynamic SQL but understand it has it's place.

Unfortunately, I believe you cannot execute dynamic SQL in a function (via sp_executesql).

You could explore the creation of...

You can certainly reference other databases and tables within a function providing the permissions are in place.

Remember though, UDF's within a SELECT statement have to run on every row returned...

More information would be really, really helpful!

What is the column type of ?AddItemVal?

What is the column type of @MyVal?

What is the column type of Column2

Do have some sample data?

Was this...

A simple Google search turned this up.

http://msdn.microsoft.com/en-us/library/windowsazure/ee730904.aspx

Looks like there are several ways to do it - the following is a copy and paste from the hyperlink:

Migrating Databases to SQL Azure...

I'd recommend a tally table. Keep the computations to a minimum as this will result in more compute cycles which will impact on the cost of the instance over time.

Help and an exchange of ideas is what SSC Forums are great for. Best of luck with your issue.

Is this a new problem, a problem that occurs occasionally or happens with every transaction?

Javascript... umm.... this is a SQL Server Forum!

I have to agree with Gail here. If you checked for blocking / long running queries / index fragmentation then more details would be useful.

Have you checked the available resources...

This is not a solution but is table possibly over-indexed? Too many indexes will impact INSERT, UPDATE and DELETE performance as the indexes have to modified.

http://blogs.technet.com/b/sql_server_isv/archive/2011/04/15/fundamentals-improving-insert-and-update-performance-by-dropping-unused-indexes.aspx

Replacing characters can be easily done with the REPLACE function available in SQL Server 2005 onwards.

http://msdn.microsoft.com/en-us/library/ms186862(v=sql.90).aspx