Search results for query: *

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

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

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

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

Is there anyway to limit sql resource usage by user? I have identified the offenders using the profiler and would like to give them lower priority accessing the database.