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

  • Users: btacy
  • Order by date
  1. btacy

    mistakenly deleted

    i was trying to delete one of my test databases and mistakenly deleted the production, or rather clicked delete on the production db. i realized my mistake almost immediately, but could not stop the action, luckily people were logged on and i had not selected the option to close all connections...
  2. btacy

    database engine on virtual server, good idea?

    we've experienced a few application related problems btw SQL 2k and an online application, our vendors believe it's SQL iming out and that it is somehow related to our database engine sitting on a virtual server. i'm at loss in this regard cos i'm quite new to SQL. Has anybody had similar (or...
  3. btacy

    Database Mail Issues

    By right clicking on the SQL Server Agent icon and clicking start.
  4. btacy

    Database Mail Issues

    Hi, I'm trying to configure mail notifications on some database jobs and have looked through a few threads on the same topic.particularly thread962-1298447. However, when i restarted the SQL Server Agent. it would not restart. it now shows SQL Server Agent(Agent XPs disabled) against the icon...
  5. btacy

    SQL server version problems

    Thank you so much George, you have greatly improved my knowledge of MS SQL Server. i have checked for the database engines installed on each machine. Machine A: MSSQLSERVER SQLSERVERAGENT Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003...
  6. btacy

    SQL server version problems

    hi, a little background to give you a better picture of what is happening. i inherited a couple of databases across on two machines running different versions of SQL server. Machine A runs SQL server 2000 Machine B runs SQL server 2005 one of our vendors needs to fix a problem with an...
  7. btacy

    replicating SQL 2005 database on SQL 2000

    hi, i'm trying to replicate a database that presently exists on SQL 2005 on to an SQL 2000 database. any ideas how i can get that done? i tried to use the generate script option in 2k5, but keep getting this error. ------------------------------ ADDITIONAL INFORMATION: Script failed for...
  8. btacy

    Re attaching a db

    thanks a lot Ovatvvon and mrdenny. your responses helped me get my head around the problem. i have resolved it and here is what i did: i took C offline and tried to attach B again and it re attached successfully, then i restored C from a backup of B and renamed the files as Ovatvvon pointed...
  9. btacy

    Re attaching a db

    thanks for your responses. mrdenny, the database B is detached, so i can't even restore it from a backup. any ideas how i can restore it without it being attached or overcome the error it gives when trying to attach it?
  10. btacy

    Re attaching a db

    hi, i had to create a test database(C) from a backup of a present one(B). while trying to restore C from the backup of B , it kept giving errors saying the datafile was in use, so i took B offline and tried again, the same thing happened and then i detached B and tried once more and it worked...
  11. btacy

    Running a stored procedure from a batch file

    thanks for responding Paul. the SQL server uses windows authentication. do i include the windows user name and password in the file? also there isn't a need for an output file, can that be excluded without any consequences?
  12. btacy

    Running a stored procedure from a batch file

    hi, i wrote a stored procedure for a process. it needs to be run as part of a series of other processes by a user and so i'm thinking of calling it from a batch file to make it as easy as possible for the user. the problem is i don't know how to go about it. can anyone help please? i'm using a...
  13. btacy

    local variable & conversion issue

    thanks
  14. btacy

    local variable & conversion issue

    here is the full code apart from declarations Set @hSqlOne = CURSOR SCROLL DYNAMIC FOR SELECT EMPLOYEE.SURNAME, ORGANISATION.MEM_REF, EMPLOYEE.EMP_NO, MISC.CONT FROM EMPLOYEE INNER JOIN ORGANISATION ON EMPLOYEE.EMP_NO = ORGANISATION.EMP_NO INNER JOIN INDSTA ON...
  15. btacy

    local variable & conversion issue

    i'm selecting 4 linked values per record from different tables,for an unknown number of records, that's why i used a cursor to store them. could you give me an idea how else to work around it without using a cursor?
  16. btacy

    local variable & conversion issue

    hi, i had a problem with the code below OPEN @hCursOne FETCH NEXT FROM @hCursOne INTO @sSurname, @sMemDet, @nIndNo, @sCont WHILE @@FETCH_STATUS = 0 BEGIN SET @regno = @regno + 17 INSERT INTO newiuser (registration_no, password, prompt_question, prompt_answer, individual_ref, status...
  17. btacy

    inserting local variables

    thanks all, the problem was caused by the sizes of the variables as you pointed out. thanks again.
  18. btacy

    inserting local variables

    hi all, i'm running a script which picks pieces of information from a few tables and stores them in local variables. then it inserts the information in the variables (per record)as a new record into another table. it worked perfectly in SQL 2005, i tried to use it in SQL 2000 and it gived the...
  19. btacy

    Database backup Fails In Maintenance Plan

    thanks Denny, i ran a DBCC checkdb on the databases in question. it found 0 allocation errors and 0 consistency errors. so i'll just uncheck the option to repair minor issues as you pointed out. i'm open to any other information on this issue. thanks again
  20. btacy

    Database backup Fails In Maintenance Plan

    in the log file, the following line is repeated for each of the databases not backed up. [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC SQL Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in database 'MASTER'. [Microsoft][ODBC SQL Server Driver][SQL...

Part and Inventory Search

Back
Top