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...
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
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...
...Question 2 - The current appl is using the MS Access autonumber functionality. I modified these fields to use identities but now the Access appl will not give the users the >* function (to add new rows to the table).
Sorry for such a long post and thanks in advance for any sugestions.
Sunny
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
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.