whenever I am trying to run the query from query designer that takes long gets error message like : [Microsoft] [ODB SQLServer Driver] Timeout...
yes , i really need stored procedure for differential backup. that i can create in master and can call other userdb to have differential backup I...
I have been asked by my manager to create the stored procedure for differential backup. can anyone please help me to write the stored procedure that...
I have a very weird situation: I have two servers Server1 (sql 2000 , standard edition) and Server2 (sql 2000 , standard edition) both have exact...
thanks a lot. so if i change the authentication from windows only to mixed there is no effect and i do not even need to restart the sql server ....
i have a situation that i want to change authentication from windows to mixed. if I ask all the users to to out from server and then if i remotely...
can anyome please suggest that how we can communicate between two sql 2000 servers. if i want to transfer data from sql to another how i can...
i am having backup of my old system databases (master , msdb , model) and i want to restore the existing backup of system databases of sql 2000 on...
is there is any sp or small script that you can please share that give the location of data file and logfile of all dbs on server. i have to create...
by mistake our sysadmin installed the sql 2000 on the c: drive on which operating system is installed. so because of that my all system databases are...
can anyone please share his/her experience in using the lite speed software for backing up very big database and compress backup. can you please send...
I think I have not been able to clear what I am looking for . dear friend ...please i am trying to link two servers. both are sql 2000. I am sysadmin...
hi thanks a lot for your response. actually i am trying to create link server between two sql server 2000 . can you please provide any link regarding...
I am trying to create link server between two sql 2000 servers. server A and Server B. Both the servers A and B have windows authentication only. can...
can anyone please throw some knowledgeable light on this topic. i will highly appreciate if anyone can share his or her knowledge to get better...
Do you have enough space on current server? Thanks a lot your response and asking the related questions so that i can reach the solution. yes i am...
thanks a lot for your response. can you guide me soon that on what basis i can connect the two servers so that I can take backup of one on another...
sorry greg i forgot to add the erroe i am getting when try to run the script Server: Msg 208, Level 16, State 1, Line 17 Invalid object name...
thanks greg ... no it is constantly giving me error...can you please check thi second piece of code once more and paste once mor. sorry and thanks a...
hi friends..i am having some very large databases minimim 300 GB and most of them are anyways going to increase even in TB. we are dedicating one...
Separate names with a comma.
