Tried it and recieved the dreadful message - logged in via user name and password.

nag4.net

How is the data being passed from your application to the procedure, is it a comma delimited string ... or? And how to handle that is your problem?...

Strictly as a pure guess -- Checking Books On Line for:

SQL Server, Wait Statistics Object at:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/cb7f917d-4291-4115-9b78-ee7692ebbb2d.htm

Can you associate any of the data returned with any of the items contained...

If what Steve has recommended does not do what you need try this:

CREATE PROCEDURE UDP_User_Permissions AS

SET NOCOUNT ON --Don't want all the...

Read these pages From Books On Line (BOL) and see if these techniques will provide you with the information you are seeking.

How to: Set Up the Job History Log (SQL...

Here is an excellent article by Brian Kelly which may help you to accomplish what you want

http://www.sqlservercentral.com/articles/Security/sqlserversecurityfixeddatabaseroles/1231/

It contains examples and very good explanations and how to information

This might help you better understand what you can do using a view:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/aecc2f73-2ab5-4db9-b1e6-2f9e3c601fb9.htm

From the above Books On Line entry

You can modify the data of an underlying base table through a...

Try this approach

1. For @PASTA pass in...

Frances L

You have posted your question to a site that assists users of SQL Server, with a question concerning how to perform a task in Microsoft's ACCESS.

You would be better...

Alberto.Omini

If you are going to continue using VB 6 to query a SQL Server database, update the application to use ADO in place of DAO. Now here some...

Chad Crawford

From one who has been battered from pillow to post on some of my QOD's. Do not take it to heart, expand the time you can to research...

What is your bakup/recovery mode ... Simple/Full ... do you take periodic log backups? How frequent are your backups?

In addition to Gail Shaws' excellent article you might also read...

The code posted here is not mine, but was posted by another SSC contributor whose name I have forgotten ... but not their contribution, and I thank them for that.

Returns...

Look at @@ROWCOUNT

For example:

UPDATE authors SET au_lname = 'Jones'

WHERE au_id = '999-888-7777'

IF @@ROWCOUNT = 0

print 'Warning: No rows were updated'

If you are using SQL 2005 then read...

SELECT REPLACE('ab.cd.ef.gh.kl','.','')

SELECT REPLACE('hh.jj.kk.rr.ee.bb','.','')

Result:

(No column name)(No column name)

abcdefghklhhjjkkrreebb