Unless someone has found a way of generating passwords from their salted hash value, I don't understand what the problem is.... Steve S

A couple of problems: your parameters should not be specified as output, because you're passing the values into the stored procedure. The parameters are also badly named - indeed, I'm not sure you need two parameters, because you're just trying to see if a particular flag is set. The syntax error is coming from 0x@oparm. The prefix 0x tells SQL Server that the following characters should be interpreted as a hexadecimal number literal. If you want to do that, specify hex when assigning a value to the parameter, don't include it in the query text. @ isn't a valid character in a hex literal, so SQL Server complains. With that in mind, I would just SELECT PERMISSIONS() and perform the mask operation in client-side code. Testing each bit separately is a waste of network and server resources. In Visual C++, you use the & operator to mask, then == to compare. == has a higher precedence than &, so you need to use brackets to ensure that the AND operation is done first. In VB, use And to mask and = to compare.

how do i create a stored procedure in C++? my program should for any of the sql servers.. so..manually creating a stored procedure won't work.. so.. i have to create it programatically...how do i go abt doing it? ranjani

ranjjj, how well do you know ADO programming with VC++? In order to get the RETURN_VALUE from the stored procedure, you need to execute it from the recordset and not from the connection. In you recordset object you need to set certain properties, like CommandType and CommandText. If you programmed ADO with VB, it is the same thing with VC++. regards, Husein

I believe that this post has the answer to your question. Happy programming! :-D

Ranjani, You post messages pretty often. Why don't you sign up as a user? Just wondering. Basically, the way SQL Server permissions go, you have permissions as the result of being a member of a Windows group or role, right? (When I speak of permissions, I also mean that you can be denied access to something.) Then on top of these group-related permissions, you can be explicitly granted or denied extra permissions. These are usually granted/denied/revoked using the GRANT, REVOKE, and DENY statements in Transact-SQL, since most admin types use Transact-SQL to script this stuff up. The ListUserPermissions method lists the permissions of the second type: special added-on permissions granted specially for a specific user. It won't include permissions that a user has through inclusion in a role, for instance, so be careful. Also, you should realize that the Permission object can represent the fact that a user is denied access to something-- check out the Granted property. Hope this helps. Regards, Jeff Varszegi

Here is a basic definition of SQLDMO that I found here: http://www.expresscomputeronline.com/20030616/techspace1.shtml "DMO is a set of objects that represents the SQL Server infrastructure. This is a very rich and complex object model. It is not intended to provide data handling, which is best done by traditional SQL commands. DMO is designed for administration of SQL Server using a component object model approach. In fact, using DMO, you can do things that are impossible with Enterprise Manager. Moreover, it is often much simpler to write a DMO based code rather than trying to find equivalent Transact SQL syntax for achieving certain administrative tasks." Things I've used it for include: - Listing available SQL Servers - Listing available databases in a given server - Programmatically "walking" a set of database tables for generating database objects based on those table (just to name a few). It is a very useful component. I found a link here http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q287/7/37.ASP&NoWebContent=1 that demonstrates listing available SQL servers using C++. I'm sure there are many more examples out there, so you should just do a google search for the term "C++ SQLDMO" or something like that. There tend to be more examples out there written in VB or C#, however, the same component can be referenced from C++. Let me know if you need any further clarification. -Matt ------------------------------------------ The 3 great virtues of a programmer: Laziness, Impatience, and Hubris. --Larry Wall

ranjjj wrote: this is giving an error!after diplaying in the edit box! And that error would be ?? Five birds are sitting on a fence. Three of them decide to fly off. How many are left?

I forgot to mention the language in which Iam coding! I will have write a C++ code.. thanxxx ranjani

thank you..will try and shall let u know ranjani

Converting from/to prefix, infix, and postfix, is easily accomplished using a stack data structure. Five birds are sitting on a fence. Three of them decide to fly off. How many are left?

DWORD dwType; RegQueryValueEx(HKEY_CURRENT_USER, "SYSTEM\\CurrentControlSet\\Control\\BackupRestore\\FilesNotToBackup", NULL, &dwType, ...); Five birds are sitting on a fence. Three of them decide to fly off. How many are left?