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

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

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

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

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

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

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

Hi, i have a maintenance plan set up to backup 4 databases, check the data integrity and backup the transaction log where applicable. it's been working fine for a while. I discovered today that two of the databases were not backed up. i can't seem to figure out what went wrong. Any ideas? thanks!

hi All, i'm running a block of code to insert records after checking some criteria. it gives this error "Cannot insert explicit value for identity column in table 'webx' when IDENTITY_INSERT is set to OFF." i have tried to check what identity_insert is, so as to turn it on, to no avail...

hi , please i need help on zipping backup files of a database from within SQL before it is saved in a remote location, cos the backup file is really large. it's SQL 2005 Can anyone help me please? thanks

Hi, i wrote out a query for a view and it takes too long to execute (abt 10 mins). this view will need to be refreshed at various times, so i need it to execute faster. Any advice on what to do? thanks

Hi, I'm new to SQL Server and i'd appreciate as much help as i can get. the database i inherited doubled in size (backup files) within a period of two months, this has caused some concern, as there hasn't been any major influx of data other than regular work inputs. Any idea what the problem...