RE: store stored proc results into table

Well can we directly execute a Stored Procedure inside a Cursor and Loop over the results returned by the executed Stored Procedure.I don't know if this question is related in this contextThanks

RE: SQL statement help needed (2)

No, not me! But I know a friend who knows someone who has heard, that there might be some people... Actually I only thought about why always reinvent the wheel when someone else has done similar before.

RE: Passing a querystring to a stored procedure?

- keep sql-injection in mind ! Check http://qa.sqlservercentral.com/columnists/chedgate/sqlinjection.asp- just define your variables as sp-parameters and handle your statement in your sp. You will soon discover it's best to work with known predicates.- check http://www.sommarskog.se/dynamic_sql.html and http://www.sommarskog.se/dyn-search.html

On your production SQL Server 2000, you have...

RE: How to Make Sure You Have Good Passwords

Don't forget sp_change_user_login

How to Make Sure You Have Good Passwords

As Robin points out there is no built in way to make sure users have strong passwords when using SQL authentication. There are a couple changes you can make (with appropriate warnings!) that will allow you to do this. Read on to find out why and how.

RE: Need help with DELETE

Thanks for this input. I have seen this technique before, but I will document it this time.CSDunn

Tonya needs to manage what user accounts can...

Review of Lumigent Entegra

We've been trying to catch up on reviews lately, Hai was kind enough to give Entegra a try and report back on it. The basic concept is that it lets you do extensive auditing without having to add triggers. If you're trying to find an auditing solution, this is worth considering.

RE: Design Suggestions Needed (For an Employee Database)

Thanks for the responses. The structure is already hardcoded, so i'm trying to get away from that. I have one additional issue, and I believe it will fit in just fine to the proposed model. The issue is that there is also a group type "CUSTOM", which can mix and match employees from different teams. […]