It is possible to read in a tab-delimited file into SQL Server. However, your sample file seems to be missing end-of-line characters? If you can define an end-of-line marker...

This is quite easy to do... I hope you're here to learn and not just get homework assignments 😉

In a business world, we often do not have the choice to...

Something doesn't make sense.

You say you are trying to "report on the Transaction Log Shipping Status on the Primary Server". This leads me to believe you are just doing...

Cool! I'm about ready to say SSRS with Sharepoint is a viable application platform...

If getting the data is easy, then I would think you could add sub reports to your main report. Or you could use Data Grouping. Highlight an entire row of...

So you're looking for something like this?

Clever Title 1

Detail 1

Detail 2

Task 1

Task 2

Task 3

Measure 1

Measure...

What reporting tool are you using? I don't see anything here that can't be done through the source T-SQL query.

Sakthi,

I'm curious to know the resolution to this, as the CNAME alias is typcially part of my suggestions for failover, but I've never had the chance to experience a failover...

Do the following two select statements return the same name?

SELECT @@servername

SELECT SERVERPROPERTY('servername')

That's about as much as I can help...

I'd start by running the "SQL Server Client Network Utility" (should be in Start menu) on both servers to see what protocols are enabled. Perhaps Named Pipes is off...

Here's one possible sample solution using 2 values in a comma-separated variable. You can run this against any database. You'll want to add checks for empty strings passed in, as...

MS VS 2005R2... SQL 2000 and 2008 seem to work well enough for testing things out.

Perry Whittle (9/23/2008)

what...

That's...

Great comment! SQL Server on a VM can be VERY slow due to...