Search results for query: *

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

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

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

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

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

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

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

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

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?

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

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?

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

thanks

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

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?

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

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

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

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

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