Viewing 15 posts - 2,341 through 2,355 (of 3,221 total)
Tried it and recieved the dreadful message - logged in via user name and password.
There is a problem with this website's security certificate.
October 30, 2009 at 9:47 am
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?...
October 29, 2009 at 4:18 pm
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...
October 29, 2009 at 1:53 pm
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...
October 29, 2009 at 1:42 pm
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...
October 29, 2009 at 8:27 am
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
October 28, 2009 at 11:55 am
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...
October 28, 2009 at 11:18 am
As Jack Corbett stated:
You might be better off writing separate SP's for each set of conditions and making this a master procedure.
Try this approach
1. For @PASTA pass in...
October 28, 2009 at 11:06 am
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...
October 27, 2009 at 2:39 pm
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...
October 27, 2009 at 1:25 pm
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...
October 27, 2009 at 12:25 pm
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...
October 26, 2009 at 10:03 am
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...
October 26, 2009 at 9:24 am
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...
October 24, 2009 at 7:46 am
SELECT REPLACE('ab.cd.ef.gh.kl','.','')
SELECT REPLACE('hh.jj.kk.rr.ee.bb','.','')
Result:
(No column name)(No column name)
abcdefghklhhjjkkrreebb
October 22, 2009 at 10:26 am
Viewing 15 posts - 2,341 through 2,355 (of 3,221 total)