Please check out the following Link:

http://sqlserverpedia.com/blog/sql-server-bloggers/sending-ssis-information-to-the-windows-event-log-2/

You need a cross table query or pivot predicate which came out in SQL Server 2005.

Try the example provided in the following links:

http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=25

http://www.dba-sql-server.com/sql_server_tips/t_super_sql_456_crosstab_queries.htm

http://www.simple-talk.com/sql/t-sql-programming/creating-cross-tab-queries-and-pivot-tables-in-sql

http://www.fmsinc.com/TPapers/access/Reports/monthly/index.html

http://bytes.com/topic/sql-server/answers/144067-crosstab-queries

http://www.sqlservercentral.com/scripts/Miscellaneous/30931/

Are you running from your client PC or or you remotely connecting to the PC?

Is the Account that you are using a Local Admin on the Server?

Are you running the...

I would suggest using a seperate drive(s) for it will increase your performance.

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

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

http://www.sql-server-performance.com/articles/audit/hardware_bottlenecks_p1.aspx

http://serverfault.com/questions/19866/recommended-disk-partition-setup-for-a-sql-server

http://databases.about.com/od/sqlserver/a/partitioning.htm

I hope th following links are helpfull:

http://www.dotnetspider.com/SqlServer-Tutorial-158.aspx

http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx

http://msdn.microsoft.com/en-us/library/ms345154(SQL.90).aspx

http://www.teratrax.com/articles/sql_server_2005_express.html

Regards,

Welsh

I subscribe to it & I do not think that it is a waste of Money.

Try to get it during a promotional.

Make sure that you at least subscribe to the...

I believe that you hve to enable those Extended SP's via code or the Surface area configuration'

Msg 15281, Level 16, State 1, Procedure xp_findnextmsg, Line 1

SQL Server blocked access to...

I saw that yesterday but I did not think to ask.:-)

What is the next problem?

Could you send the Solution and the scripts to create and populate the table(s)?

Are you stepping thru the code, using the immediate window and watch expresions,...

My apologies, I should have looked it up but I was a little short on time.

In Mucach's Books on VB.NET & C# have some great examples.

But of could you can...

This is the search criteria that I used in Advanced Google Seartc:

How to RESTORE HEADERONLY using SSMS

You can manipulate the abouve search to change the number of hits.

In my opinion,...

Dave Try this Link, I hope that it helps:

http://www.mssqltips.com/tutorial.asp?tutorial=105

Dave-DJ,

I can only speak for myself not someone else on the foeum but RESTORE HEADERONLY is frequently used by DBA's:

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

The SSMS GUI typically for convience or for those tyhat do...

You can use package variables for ech SSIS Package or you could read thru a collection of SQL Servers.

You are using Lightspeed? That has a never nice compression capability.

You...

Here 2 of the 5 articles by Ross, perhaps if you Google you can find the rest or some additional articles:

http://www.networkworld.com/community/node/30052

http://www.networkworld.com/community/node/30275