Please will you post some sample data showing what you have in your source tables, and what you want your target text file to look like.

Thanks

John

In your original post, you appear to have two tables: "table1" and "table2". In your sample data, you only have one: "Table". If you could post some CREATE...

Warren

My view is that you should back up everything (within reason) and then it's there if you need it. Just because you can't think of a reason why a...

That looks very complicated. To convert milliseconds to seconds, just divide by 1000. To convert microseconds, divide by 1000000. I don't really understand why you need to...

I don't know whether you can ignore those results, since you haven't provided any sample data....

Unless I'm missing something here, there's no need to use a cursor. I think it's as simple as this:

SELECT * FROM TraceResultsLongRunningQueries

ORDER BY Duration DESC

John

Brian

Have you tried using an OnError event handler?

John

Yes, you can - although it's not necessarily the best way of going about it. For example, if you want to manipulate the results from a data flow, then...

Is there a question here?

John

If you look up the syntax of sp_send_dbmail, you'll learn how to do this.

John

You need to query the backupset, backupmediafamily and backupfile tables in msdb. The following query should work on all versions of SQL Server and return the most recent backup...

Arash

Should be possible... just include a @Domain parameter in your stored procedure definition and build that into the script that you already have - something like this snippet:

SET @sql =...

Mmmm... do you understand that you have to copy your query output, paste it back into the query window and run it in order for the logins and users to...

Vinay

What do you mean by the query stats? I would recommend that you monitor dm_db_index_usage_stats over a period of time. That way you'll find out how often the...

I'm afraid I don't know what you mean. Are you getting any error messages when you run the script?

Are you saying that you run the script, and then when...