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

    SQL Server 2000 - memory management

    OK Thanks for your help.
  2. purefreshair

    SQL Server 2000 - memory management

    I've always seem to notice that when SQL takes what it needs when it needs to, it never "lets go" when it's finished. sqlsvr.exe always starts out low after a server re-boot; then over time it takes more and more (gradually keeps growing and growing). Why is that?
  3. purefreshair

    SQL Server 2000 - memory management

    Thank you mrdenny. If I look at the memory tab under the SQL server properties, I see that it is currently set at the defaults; 1) Dynamically configure SQL server memory is selected (dynamically adjust) and 2) minimum query memory is set at the default of 1024KB So if I upgrade the ram on the...
  4. purefreshair

    SQL Server 2000 - memory management

    Hello, Our company has a Dell 2600 Poweredge data server. It is running an instance of SQL server 2000, Standard edition using Windows 2003 server standard edition OS. The server currently has 2GB of ram. It is running one production database app, accessed by several end users. We're...
  5. purefreshair

    SQL 2000 Server Error: 18456

    Got it. Thanks.
  6. purefreshair

    SQL 2000 Server Error: 18456

    Hello, I have a question regarding Windows Authentication. I have an instance of SQL 2000 server (SP3) running on a server that has Windows 2003 server, standard edition on it. The server is part of the same domain name in our active directory. In the Security tab settings of Enterprise...
  7. purefreshair

    SQL server 2000 - scheduled database backup will not run

    So, to place a user database into single user mode, is it just a matter then of conecting to the database using query analyzer and issuing the "alter database db-name set SINGLE_USER" command?
  8. purefreshair

    Data Access From IBM RS6000 AIX server

    Hello, I am writing to inquire whether anyone has had experience in Crystal Report development work via data access to an IBM RS6000 server. I have done work with an AS400/iseries but the RS6000 is a new one for me. For example, does the connection to this server similar, i.e. an ODBC...
  9. purefreshair

    SQL server 2000 - scheduled database backup will not run

    SQLBill, I am merely setting up a maintenance schedule using the feature/wizard inside Enterprise Manager as part of SQL Server 2000. Yes; this is a user database, not a system database.
  10. purefreshair

    SQL server 2000 - scheduled database backup will not run

    Hello Mrdenny, My scheduled integrity check and backup did not run because the error reports state that the "Database needs to be in single user mode". According to Microsoft's site, having the "attempt to repair any minor problems" checked can cause this. I did have it checked so I have...
  11. purefreshair

    SQL server 2000 - scheduled database backup will not run

    Hello, I have an instance where a background service runs on a SQL 2000 server. It has Windows 2003 server standard edition as the OS. The service is part of an app that polls data from another source and stores that data on the SQL database at selected times through out the day. I have a...
  12. purefreshair

    monitoring sqlservr.exe

    say mrdenny, How do you configure SQL Server to not use all the available memory? I have a case where the server has 2GB of ram in it; sqlsevr.exe is using nearly 1.5GB. The server also has an app on it that will be accessed/queried by several users. - Kevin
  13. purefreshair

    PC Re-Boots When Opening Excel File

    Yes, I logged on as myself and I could open the document just fine. So I deleted per profile, she logged onto the PC today, which re-created a new profile, and as soon as she attempted to open the Excel document, the PC re-booted again; yet it opens for me ok under my login. She can log onto a...
  14. purefreshair

    PC Re-Boots When Opening Excel File

    Hello, I have a user that has an infrequent issue with Excel 2003. She'll browse to a folder on the network, browse to the Excel file, and double click on it. Upon doing this, her PC immediately re-boots without any error messages. It appears to happen on selected Excel files that have images...
  15. purefreshair

    Move SQL database to a different volume

    Thanks Bill, I did this task over the holiday break and it worked fine. One other question though; If I look at the database in enterprise manager using the taskpad view, it shows that the database is 126MB in size, with 125.69 used and .31MB free. If I look at the database properties, it is...
  16. purefreshair

    Move SQL database to a different volume

    One other question for you SQLBill, You write about making sure that I set the owner to the correct owner; how/where is this done?
  17. purefreshair

    Move SQL database to a different volume

    SQLBill, This would be a User database that was set up from a vendor application program that runs as a client/server app.
  18. purefreshair

    Move SQL database to a different volume

    Hello, I have a task at my new job where I need to move an SQL 2000 database from one volume on the server (running Windows 2003 server, standard edition) to another. The vendor that originally created the database (before I started here at this job) set the database up on the c volume which...
  19. purefreshair

    Populate a null date field with a value

    That's it!! That worked! Thanks so much.
  20. purefreshair

    Populate a null date field with a value

    Hi there lbass, It is a datetime datatype.

Part and Inventory Search

Back
Top