Recent content by sunny456

Jay, I have the same question as Andrei. I checked out your link but couldn't find anything specific to SQL Server. Could you point me to your source of information on this topic. If Windows Server 2003 can indeed allow SS2000 SE to use 4GB of memory it would give us justification for an...

I need a way to load all my domain user names into a table. The following script does basically want I want but I need to convert this into a stored procedure and NOT encode the username and password. Thanks for your help in advance, Sunny Option Explicit Dim sDomain Dim oDomain Dim...

I had the same problem after upgrading to SS2000 SP3. Check out this link it worked for me. Regards, Sunny http://support.microsoft.com/?kbid=328151

James, thanks for the reply. As far as why - we are in the process of developing an appl(sort of a menuing system) that will allow access to certain appl's and reports based on each user's NT security. The caveat is that we don't want to show the user any programs in the menu that they don't...

Thanks for your reply but what I need is a way to determine the NT user groups that an individual login is a member of and not a list of all NT user groups in a Domain. Thanks, Sunny

I need a method of finding out which NT user groups a user is a member of, via a stored procedure. Any help would be appreciated, Sunny

Look at this web site http://www.sqldev.net/xp/xpsmtp.htm. I have been using this method for over a year and had no problems. It does NOT require MS Outlook, just uses smtp. Good Luck

I am calling a SQL Server stored procedure which has 1 input parameter and 3 output parameters. I can call the procedure and it runs successfully(I checked in the SQL debugger that all 3 outout parameters are populated correctly) but when I check the variables afterwards in Cold Fusion they all...

I am in the process of moving data from an MS Access 97 DB to SS2000. (Keeping the access frontend) The data was imported using DTS. There was 1 field in the Access database used to store signatures in the datatype OLE Object (MS Photo Editor 3.0 Photo) I have tried converting to both an Image...

We are in the process of upgrading a MS-Access(97) database to SQL Server 2000. We will still be using an Access front-end program to access the SQL backend. I have used DTS to import the data into SQL and have linked the data using ODBC. The data looks fine but I have 2 questions. Question 1 -...

I have a user that's trying to pass 67 parameters to a sql stored proc and Foxpro (V6) is giving her an overflow message. Does anyone know the max number of paramters that Foxpro V6 can pass to a SQL sp. Any ideas on how to get around this limitation? Thanks in advance

nevermind I re-read the title of your post

And the name of the book is????

link9, go to BOL and search for DBCC SHOWCONTIG. At the bottom of the page there is a script that I think will help you defrag indexes for an entire db based on maxfrag. HTH

Jeff, thanks for your feedback. Do they use an ODBC connection? YES If so, I would ensure that it is a system data source. Yes it is a system DSN and have verified that there are no conflicting user DSNs set up with the same name. Have you verified that the MDAC versions are the same...