You could have coded your SP as follows CREATE PROCEDURE usp_check_login @username varchar(20), @password varchar(20) AS SET NOCOUNT ON SELECT user_id, user_active as login_active, user_loginattempts as login_attempts, user_type FROM tbl_user WHERE user_username = @username AND user_password = @password RETURN @@ROWCOUNT GO That way you could use your RETURN_VALUE to determine whether or not your user […]
2003-12-23
3 reads
Just off the top of my head: what about using MSDE (Micro$oft Data Engine) and put that on the DVD, along with everything else?
2003-12-23
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-12-22
2003-12-21
1 reads
2003-12-19
What are you trying to audit? Just logins? Queries as well? Changes in data? K. Brian Kelley, GSEC http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/
2003-12-18
My personal "senior" moment with SQL Server is anything to do with replication. I have worked as an App DBA for years and I have only worked on one replication setup. I have much more experience with clusters. Someone asks me an off-the-cuff question on the types of replication I'll find the answer in BOL. […]
2003-12-17
An easy way to 'shrink' the tempdb is to stop and restart the services when you are done with all your transactions. This will cause tempdb to be rebuilt based on the model database. -SQLBill
2003-12-17
Do you create many DTS or large DTS packages? We have 188 DTS packages most of them small.
2003-12-16
1 reads
I don't see indexes rebuild before you perform business logic sp to generate summary data. You will perform table scan mostly since indexes have been dropped at step3.
2003-12-16
1 reads
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers