whenever I am trying to run the query from query designer that takes long gets error message like : [Microsoft] [ODB SQLServer Driver] Timeout...
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...
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 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...
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...
hi actually i was simply trying to count total records on very big table having nearly 500 million records. in sp_who2 it shows that i have blocking...
i would like to request that please can anyone guide me that how I can write a stored procedure that can give me the following information. as i have...
hi I am trying to put down the query to update the Tag column in Test Table. the sample is as below: WorkdayIDRepIDCallDurationRECTIMETag...
hi friends I have question regarding DTS. actually my work is very much dependent on DTS. Actually I have 100's of DTS and I have also saved a copy...
Hi friends, I have been asked by my mananger to backup all dts for all servers. can you please guide me how to save and restore DTS in sql 2000 . how...
Hi friends I have a situation where I have to move two very large databases of size 400gb each from sql 2000 to another sql 2000. Along with these...
I am having RECORDS in which THE ONE CALL IS REPEATED MORE THAN ONCE HAVING SAME customer number , representativeid , callduration i HAVE TO...
dear friends can you please help to write stored procedure that gives following details about server: I am trying to have following datafields:...
Table Namedbo.TotalCallsRecords DateRecordTimeCustomerNumberRepresenCustomerIDLenghofCallProductIDStateCode 9/5/2007 0:00122245123abc111 ca...
Separate names with a comma.
