Search results for query: *

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...

Jeff, thanks for the response, I'll clarify. The users are running an application on a Citrix server which in turn accesses a SQL Server 2000 database by calling stored procs. The NT user groups that we have setup are used to administer permissions in SQL to these stored procs. A SQL admin...

Running Citrix Metaframe on W2K and connecting to SQL Server 2000 (SP2) on another W2K box using NT Authentication. Using Citrix users cannot access SQL via an NT User Group account until I add each individual user to the database. After that they are ok and are given the correct group...

I receive the following error when trying up backup a database(apx 142MB) across my network(W2K).The backup seems to complete and will restore but always produces error messages. Running SS2000 SP2. Anyone seen this before? 18210 : BackupDiskFile::RequestDurableMedia: failure on backup...

Maybe I should clarify. What I'm trying to do is to set a breakpoint when a variable e.g. @ErrNum >0.

Does anyone know how to set a "Watch Expression" using the SQL Debugger(SS2000 SP2)? I can setup breakpoints ok but can't find any doc on setting watch points other than BOL stating that it can be done. Thanks in advance