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 Chriss Miller 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. latitude800

    local server group

    Via SQL Enterprise, I am trying to created a local server group (local) when I trying to do it I get an error message that cannot authenticate using windows or SQl authientication. I am not able to add local server... Any help would be really appreciate.. Regards, James
  2. latitude800

    Select Query Help !!!!!

    I have the following query that pulls a TermID Publication source. I am not getting any results, I get the Term ID but Publication source NULL. Please any suggestions. Thanks very much in advance. SELECT gps.TermID, gps.PubSourceID, gpsr.PubSource, FormattedPubSource=CASE WHEN...
  3. latitude800

    DBCC SHRINKFILE

    I am trying to skrink the log files for a database logical name GPSDYNAMICSLog.ldf, I want to have 2 MB size, and I do the following. When I use DBCC SHRINKFILE (GPSDYNAMICSLog, 2) I get the following: Server: Msg 8985, Level 16, State 1, Line 1 Could not locate file 'GPSDYNAMICSLog' in...
  4. latitude800

    configuration of our SQL server 2000

    I am new with the company and I am trying to detail every piece of the configuration of our SQL server 2000. Would you please assist me identifying the best process to do this. Can I run a Query Analyzer. Thanks Jimmy
  5. latitude800

    Schedule Task to Reboot server

    So using shutdown.exe will reboot the server, I cannot manually restart the server, I am schedule the server to reboot at 11:00 PM. Thank for yourhelp Sincerly, Jimmy
  6. latitude800

    Schedule Task to Reboot server

    I need to schedule our SQL Server to reboot every night according to our vendor. I am trying to setup a schedule task without success. I cannot find reboot.exe. Would someone tell me where can I find it or a way to write one. Thanks for all your assistance in advance. Sincerely, Jimmy
  7. latitude800

    Creating backup from SQL Server 2000 to another server

    I am creating a full back up to run every night from my SQL Server 2000 to an IT Server backup SQL. I have mapped my IT drive to the SQL Server 2000 with no issues, but when I am trying to create the backup using enterprise manager, and add the drive I cannot not see the drive, is not one of my...
  8. latitude800

    SQL Server 2000 maintenance plan

    I need an advise, I was recommended as part of the maintenance plan to schedule the SQL Server 2000 to reboot every night, (shoutdown and restart) this will provide me with better preformance. Please what would be the best way for my the server performance. Thanks in advance. Regards, James
  9. latitude800

    I/O error 21(The device is not ready.)

    I am getting the following error message , would anyone experience this before. Thanks in advance. THe L drive is my SAN I/O error 21(The device is not ready.) detected during read at offset 0x0000000006e000 in file 'L:\MSSQL\Data\WEBIMIS_Data.mdf'. Connection Broken
  10. latitude800

    Problem making changes to report "exclusive access"

    I have 4 different reports that use the same SQL tables Links. I have a problem when I try to make changes to the report 1 and is a user in report 2 I get a message saying "I need exclusive access to make those changes" The report are not even connected share the same table but nothing else...
  11. latitude800

    Great Plain point to new server

    I am moving to a new SQL server. I have 10 workstations. I have alreary migrate the Dynamics to the new SQL server. HOw can I point the 10 workstation to the new SQL server. Thanks in advance for your assistance. Jimmy
  12. latitude800

    SQL file Administration structure

    I have about 15 databases on SQL server 1 including production, testing and development. The data files are going to the SAN (J) and log files are going to (K. for example j:\mssql\datafiles\ -- 15 databfiles reside here -- k:\ log files L:\ all my back up - Like you can see all my files...
  13. latitude800

    T_SQL Query Very costly Performance

    Good Morning May I please have an assistance. I have worked on the query below but the query is creating very issues mainly in performance very costly. WOuld please take a look and see if would be a better way to write it. Thanks in advance. The query is set up to limit access to certain...
  14. latitude800

    SQL Server CPU fan fail

    I currently running SQL server 2000, sp3a, dual processor Intel 3.4 Gig each. The SQL server is dragging and its running 100% CPU, 150 GIG hard drive. We have about 10 small databases running on the box totalling about 15 GIG. I found the the temp.db file is getting very large, even thought I...
  15. latitude800

    Database Growing creating slowness

    I have a database that processes all my online transaction. Startind yesterday the database is growing extremly large, slowing the website and up to the point the when members trying to login to the website it doesn't authenticated. I have shrinked the database log files, then everything goes...
  16. latitude800

    SQL Server Standard vs Personal edition

    I need to install SQL Server 2000 on 3 desktops, Currently I have 2 CDs, personal edition and Standard edition. which o the 2 I should use. Appreciate all the assistance and the advise.. Regards, Jimmy
  17. latitude800

    Microsoft Outlook Reading Pane

    I was told if I am using Reading Pane to view my email I am activating any email viruses that may recived. I like to confirm that the information is correct. Unless I open the attachement and activate the .exe I will get a virus, but not by using Reading Pane. I am trying to find information my...
  18. latitude800

    Local SQL Registration

    I am going out of town and I am trying to take a local copy of the SQL databases, when I am trying to create a new SQL registration (local) or (IT-201) "which is my local machine", I do not have the option. When I type the name and authenticate using windows just hangs.. How can I create a...
  19. latitude800

    SQL Server 2005 on a virtual pc

    I am currently using SQL server 2000, but I am trying to install SQL Server 2005 using virtual pc for testing. please does anyone can tell me how can I install SQL server 2005 in a virtual pc. Thanks for your valuable help. Regards, Jimmy

Part and Inventory Search

Back
Top