Hello,

When saved to SQL Server (rather than the File System) the SSIS Package will be stored in the MSDB Database.

You can select the Package when you create the Scheduled Job:...

Hello,

In SQL 2005 it is SSIS that replaces DTS.

For somebody who is unfamiliar with SSIS it might be easiest to use the Import and Export Wizard to perform the task...

Hello,

If you code it as an SP, does it still take 16 minutes to execute? Even with the recompile option?

If the SP is faster, can you compare the SP and...

Hello,

For data transfer, as well as sticking with the Linked Server, or buying DataMirror you could also consider an SSIS Package.

Regards,

John Marsh

Hello,

Do you want to see processes that are blocked by another processes (in which case an amended version of the original query would work; as would sp_who2), or do you...

Hello again,

Rereading your post, may be I misunderstood your question. Are you asking about the daily transfer of data, or the migration of the DBs from 2000 to 2005.

In...

Hello,

The Linked Server should still work in SQL 2005. Do you specifically want to move to something else?

In which case, if you can find the budget, you could consider "DataMirror".

Regards,

John...

Hello,

The column "suid" does not exist in those system views/tables. Presumably the author meant "sid"?

Does sp_who2 not give you the information that you need?

Regards,

John Marsh

Hello,

LogParser extracts information from the SQL Server Log, but not in real time. You would need to schedule it to run every day/hour/minute etc depending on your requirements.

It can filter...

Hello,

For the Date question, there are lots of built in date functions - See BOL "Date and Time Functions (Transact-SQL)", but I often use Convert e.g. Select @Date = Convert(Char(8),...

Hello Again,

Sorry, but as far as we know the built in "Select All" cannot be turned off. Please see this thread: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=249227

(I must give credit to Andreas...

Hello,

One question - do you want to log DB errors to a table over a long period?

The Profiler is normally used for short term analysis e.g. in bug hunting or...

Hello,

Thanks for the update and the improved query. I'm also glad to hear you managed to extract the data that you needed.

Having checked in BOL ("Database Engine XML Enhancements"), the...

Hello,

We have not found a way of doing that either, so we currently use a workaround similar to the one described here: http://www.themssforum.com/SVCS/MultiSelect-parameter-79674/

Regards,

John Marsh

Hello,

There is a whole section in (SQL 2005) BOL on Upgrading ("Upgrading to SQL Server 2005"), in addition this Microsoft article gives a reasonable overview: http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

Regards,

John Marsh