It should be installed with sql2005, Look in Business Intelligence, or "BI"

The apostrophe is the escape character for the apostrophy

select *

From tab a

where a.name = 'xxx''x'

Look on the server's application log in event viewer.

Seek and scan are as the word inplies.

Lets say we want to look up the word "book" in a dictionary.

Seek is like reading the top header of a dictionary, you...

Take a look at Osql.exe, or bcp in sql server books online

Dunno,

Or perhaps

SELECT *

FROM [Well]

WHERE UWI = @UWI_Equals)

  AND @UWI_Equals Is NOT Null

get rid of the OR Operator should be good

I don't think you can use rs to output xml to a report.

Rs only deals with recordsets, Cells in rows and columns if you will.

You may get stuck doing it...

well, in enterprise manager, you can right click on the table, all tasks, Generate sql script.

In the options tabl select Foreign keys, Indexes and triggers, hit preview, or Go.

Or in...

Additionally you can use dts to call the stored procedure, and save as an excel file

Is there any other data attribute that differentiates the rows?

You either have to build something in the application to persist a value each time a connection happens, or use profiler.

But what is the real number you want?

Try Security...

Check that your login is not locked, or expired.

Also check that the password for the service matches the domain password.

Did domain passwords for service accounts change recently?

The only way I can think of is to set up a profiler session, and monitor the databases in question. You can use the Audit event to check connections and such

Give this a read, perhaps it will help

http://blogs.msdn.com/tudortr/archive/2004/07/20/189398.aspx

Reporting Services authentication is done via windows Authentication, If the user is not using windows auth then you will need to build your own front end page with login/authentication, then...