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!

  • 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: *

  • Users: grimmy
  • Content: Threads
  • Order by date
  1. grimmy

    Replication

    Operating System - W2K SQL Version 6.5 I am experiencing problems in getting replication to work between two servers. I can set the publishing and subscribing up fine but it is failing with the following error:- ODBC SQL Server Error - Login Failed. Not associated with a trusted SQL server...
  2. grimmy

    Urgent Replication Problem

    I am trying to replicate certain tables from one 6.5 SQL Server to another but it is failing with the following error:- 28000[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: Reason: Not associated with a trusted SQL Server connection. I have another two SQL Servers which...
  3. grimmy

    Replication In 6.5

    I am trying to replicate certain tables from one 6.5 SQL Server to another but it is failing with the following error:- 28000[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: Reason: Not associated with a trusted SQL Server connection. I have another two SQL Servers which...
  4. grimmy

    SQL 6.5 with W2K

    Will SQL 6.5 Run OK on Windows 2000? Does anybody have any experience with this. Cheers.....Grimmy
  5. grimmy

    BETWEEN Query

    I am trying to find a set of results within two dates and I am using the follwing query which is failing:- select * from Employee where PTW BETWEEN '24/07/2002' AND '24/07/2001' The error I am getting is:- The conversion of CHAR to DATETIME resulted in a DATETIME value out of range. The...
  6. grimmy

    SQL 2000 with Transaction Server

    Hello, I currently have a live system which uses SQL 6.5 with Transaction Server and I am trying to upgrade to SQL 2000. I have built a separate SQL 2000 server and Transaction server and it does not seem to want to play and the application returns an error 5 Invalid Procedure or argument call...
  7. grimmy

    6.5 to 2000 Data Transfer

    I currently have a Live SQL 6.5 server which I needed to upgrade to 2000. To stop downtime a new server was bought and I created that as a direct copy of the live server and upgraded to 2000 All Databases and objects have be upgraded fine but now i need to copy all the up to date data from the...
  8. grimmy

    Upgrade to 2000

    I am trying to upgrade our SQL 6.5 server to 2000 by using the upgrade wizard and it is coming up with an error that tempdb needs to be 10MB in size. So, I am trying to make tempdb 10MB but cannot find how to go about this. It is currently 2MB and I have tried using the Alter Database command...
  9. grimmy

    Database Size Issue

    I am currently running SQL 6.5 and have a database setup with a 1GB data size. At this minute there is only 200MB free but there is not a lot of data in tables in this database that changes so I cannot believe that it is using 800MB. What is the best way of seeing how much data size an...
  10. grimmy

    My problem is that I am trying to p

    My problem is that I am trying to pass a string to a an active x control that requires double quotes in the string. Test1 = "Word1 "Word2"" Word 2 is the word that I want to appear in double quotes but it does not like this code. I have tried using a variant and other shot...
  11. grimmy

    Strange Error message

    We were experiencing problems with a SQL 6.5 server on Saturday Night of course with an event being written into the SQL error log as below:- FLUSH_CACHE:TIMEOUT, DATA-IN-MOTION, bp 0x4e6e3c0, pg 0x2629c, stat 0x126c/0x264000, obj 0x2, bpss 0) To correct the problem I rebooted the server and...
  12. grimmy

    Auto increment

    I have written a VB App that writes to a SQL 6.5 DB and I am having a small problem with on table. Within this table I have a column that I have setup to auto increment by 1 each time a record is added and I show this column in my VB app as record number. The problem is that whilst testing that...
  13. grimmy

    Installation Of Office 2000

    Hello, I am currently starting to roll out Office 2000 onto all P.C's across a network from a setup routine which is held on an NT server. The problem is that the installation takes around 45 minutes when you run more than one install at the same time. We have checked statistics on the server...
  14. grimmy

    Restoring Problem

    Hello, I am having trouble trying to find a way of just restoring one single table from my Full Backup. A table has mysteriously disappeared from a database and so I just want to restore that One table. In 6.5 it as as simple as select single table in the GUI but I cannot see anything in SQL...
  15. grimmy

    SQL 2000 On NT

    Hello, If SQL 2000 is loaded on NT4 Server does it have exactly the same functionality as it would if it was loaded on Windows 2000, or basically is it a version of SQL 7.0 with a SQl 2000 front end Thanks....Grimmy
  16. grimmy

    Urgent 2000 Replication Problem

    Hello Friends, I am getting a strange message when trying to setup my SQL 2000 server for replication. When going through the Configure, Publishing, Subscribers and Distribution wizard I receive the error message:- SQL server Enterprise Manager could not configure SAM-SQL- 07 as the...
  17. grimmy

    Autogenerate Number

    I am looking for the way to autogenerate a unique number so I can key from it. I know it is Autonumber() in access but what default do I need to give the row????
  18. grimmy

    Memory Address Error

    Have a Compaq 6000 professional worksation in which I am trying to install an additional ISA card. The problem is that the card wants to use the same memory address as the SCSI H/D Controller C800-CBFF. Have tried moving the ISA card to another memory address but still says there is a clash. Is...
  19. grimmy

    Login Failure

    Hello, Upgraded my NT workstation to 2000 about 2 months ago and everything has been OK....UNTIL NOW. Switched machine on yesterdat and at login when details have been filled in it comes back with the error The Authentication Service Is Unknown and does not log me on. The network is OK because I...
  20. grimmy

    Login Scripts

    Hello, Here is a problem and nobody I have asked knows the answer even instructors with all the microsoft quals etc. In our domain we have a PDC at head office and BDC's at our sites around the country. Obviously this is so all clients on each site would use their own BDC to logon hence login...

Part and Inventory Search

Back
Top