This should help:

http://www.codeproject.com/Articles/20683/Publish-SQL-Server-2005-As-Webservice

Two options are to use the pre and post execute options in the publication to run scripts so you could have the objects created via script instead of replicated. ...

EXEC sp_who2 active

That will get you started, although you can also query master.dbo.sysprocesses.

Performance issues can be caused by so many factors from hardware issues, inefficient code, out of date statistics, bad execution plans the list could go on and on.

You need to...

Giving them access to a hosted VM may be an option as we will not allow any sort of remote access into our network due to some of the sensitive...

At the moment no SQL server development has been done a d if they agree with the POC we will then pursue creating the entire database within the customers data...

Capturing a "deadlock graph" via server side trace or profiler can be used to capture the xml for the actions causing the deadlock. the xml can be saved as...

While a database is active you cannot backup the mdf, ndf, ldf files (remember these don't have to be the file extension, they are just microsoft's naming convention).

Some 3rd Party...

As the database will be readonly you wont be able to make any changes to it specifically.

So your best bet is to create the login at botht he primary and...

The books are good to get you started but a word of warning, the example questions supplied with the MS Press books are not even close to the level of...

Is there any errors reported in the SQL Server Error log within management in SSMS or any errors written to the windows event logs?

To get the output of a stored procedure for a single value you can use a select for example

CREATE PROCEDURE Test AS

BEGIN

SELECT 10

END

Then have your execute...

I assume you are running SSMS on a remote machine and not directly on the server. If so check the regional settings on your machine.

As far as I am aware only Sysadmins have permission to view the SQL Agent monitor. One alternative is to provide access through a custom coded dashboard that runs...

Is this a set structure, the data does not look particulary normalised.