Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. YL5956

    COBOL submit TSO command

    Hello, I need to write a cobol program which submits a TSO EXEC command and captures the output. I don't know Cobol very well, and couldn't find any information on this subject. Can someone help me with this? thanks.
  2. YL5956

    Datasource problem

    Recently, we upgraded our database to SQL 2000. Af the conversion, we started having intermittent problems connecting to the database. We are using a named instance of SQL 2000, upgraded the MDAC on the Coldfusion Server. I can verify the ODBC datasources without any problems but when the...
  3. YL5956

    Copying Data only

    Hi, I want to copy the data from our Production Server to our test server. I don't want to recreate all the objects, just import the data. What is the best way to do this? I tried using the import wizard but the data didn't move over. What am I doing wrong? Thanks in advance for your help.
  4. YL5956

    Active Directory Migration causing ODBC errors

    We are running coldfusion on an Extranet W2K server. The server is connecting to a SQL 7 database inside the firewall. Our database server was recently moved to Active Directory. After the migration, the Data sources in Coldfusion Administrator, on the Extranet Server, would no longer...
  5. YL5956

    Terminal Services Freeze

    I am able to log on to our Windows 2000 Server using terminal services, but when I try to log out the screen goes blue and just freezes. For some reason it's not completing the log out sequence. Any suggestions?
  6. YL5956

    Unable to to remove SQL Server Users

    We have a Coldfusion application that has the authority to delete and create SQL Server users. We are running into the problem where when we perform a delete the user account is removed from Enterprise manager, but when we try to recreate the account, SQL Server comes back with a user already...
  7. YL5956

    Login Password Problems

    I'm copying from a SQL 7.0 to a SQL 2000 database and my passwords are not being moved across correctly. I run the sp_help_revlogin script to move over the logins and then copy the database over using DTS. The problem I'm having is when I try to connect to Query Analyzer using one of the SQL...
  8. YL5956

    renaming an instance

    Hi, Is there a way to rename an instance of SQL2000? Thanks.
  9. YL5956

    reboot script

    Is there a way for Windows 2000 to kick off a script upon a server reboot? I know there is a way to run a script upon logon, but our server is going to be unattended and the script would need to run without someone having to log on. Thanks.
  10. YL5956

    DB2 Query -512 error

    I'm running a query that select rows from a db2 subsystem and then cross-referencing those rows to a table on a different db2 subsystem. My query is running into a -512 error. Does anyone know why I'm getting this error? Select Pkg_name from RMS.COMPONENT where pkg_name is not in...
  11. YL5956

    Batch Process

    What I want to do is to stage all my scripts, tables, procedures, etc, in one folder. After the staging has completed, I would run the batch job and it'll load all the objects into SQL Server. I need to know how load the objects into SQL Server using batch. Thanks. yl5956
  12. YL5956

    Batch Process

    I was wondering if anyone know how I can use a batch script to exec procedures from a remote directory. I think OSQL would work but is there a more efficient way? The process I have in mind is to use the script to look at a particular directory and 'exec' every object in that directory. Thanks.
  13. YL5956

    ODBC Authority

    Hi, I'm setting up user to connect to a SQL Server 7.0 database on Windows 2000 using ODBC. The Server doesn't let them connect unless they are made administrators on the machine. I don't to grant them admin rights. Is there another group I can add them to and have them be able to connect to...
  14. YL5956

    How do I setup Ad hoc updates to th

    I did that. Here is what my server shows but I still get the same error message. I'm sure I'm doing something wrong. Thanks. name minimum maximum config_value run_value ------------- --------- ----------- ------------ --------- allow updates 0 1 1...
  15. YL5956

    How do I setup Ad hoc updates to th

    Here is the message I'm getting from Query Analyzer after running the script to create the stored procedure. Server: Msg 259, Level 16, State 2, Procedure sp_dba_to_allow_non_sa_to_change_password, Line 63 Ad hoc updates to system catalogs are not enabled. The system administrator must...
  16. YL5956

    How do I setup Ad hoc updates to th

    Hi Terry, Here is the situation. I'm sitting up a development server based on our production image. I am not the DBA for the Production machines and they are reluctant to change the machine configuration. The only way I can be sure that the my server is identical to production is to mirror...
  17. YL5956

    How do I setup Ad hoc updates to th

    Hi, I ran the exec sp_configure 'allow updates' '1', and restarted the service but the system is still not allowing me to perform the ad hoc query. Please help. Thanks.
  18. YL5956

    How do I setup Ad hoc updates to th

    Thanks you for the assistance. So to go over the steps would I perform the following sequence of steps? 1) exec sp_configure 'allow updates' '1', 2) Create the SP through Query Analyzer 3) set allow update back to 0
  19. YL5956

    How do I setup Ad hoc updates to th

    This SP is being used by one of our webapps. I'm not sure why they didn't use the SP_Password instead. The developer decided to create this SP just for the web users. Please let me know how I can create this SP in the database. Thanks.
  20. YL5956

    How do I setup Ad hoc updates to th

    Here is the sp that I'm trying to add. It allows other users to change passwords. I can't seem to get this in. Thanks. SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON GO create procedure sp_dba_to_allow_non_sa_to_change_password @old sysname = NULL, -- the old (current)...

Part and Inventory Search

Back
Top