Hi satya, it is in SQL 2000 and the primary server got crashed completed.. Mahi
Hello All, I would like to know about one scenario, that is, If we have a full back of a database(with full recovery mode) at 12:00 AM and log...
Hello All, We have a DTS package on one of the 2000 machine say A server and it has a step which is executing a procedure on other 2000 machine say...
We got a task as below. We have 150 tables and we need to find which tables are being used and which are not, we are going to delete the tables...
there are few stored procedures using these tables in 2000 so if we migrate the databases to 2005 stored procedures will fail, please some one help...
Hello All, We are planning to migrate 2000 databases to 2005 and we ran Upgrade advisor tool on 2000 server, in the output it gives us one "Remove...
Hello All, I am looking for a Task in SSIS package which will automatically generate a XML file if we supply a query. is this possible with any of...
I want to genrate a xml file based on a query and save it to a destination path and i also need to apply a schema is it possible to do both the...
Hi Ranjit,<br /><br />This world became like a small village then Mumbai is not far away from Hyderabad <img src='/community/emoticons/emotion-1.gif'...
Hi ranjit, thanks for your reply.. where do u stay in India? Now I am staying at Hyderabad, can I know ur details please? Thank you..
Can some one provide me the documents(FAQ'S, Sample questions or any material) to prepare for MCDBA(SQL 2000) test. Thank you, Shyam.
I heard that no patch(DST Change in 2007) is required for SQL Server services, SQL Server Analysis Services add for SQL Server Reporting services,...
Hello all, I am new to SQL Server Analysis services and reporting services, on one of the server we have these two services and which need to...
if the status is showing loading means you have choosen "with norecovery" option while restoring the database, in this case you can restore any...
Hi, from last fews days I saw the below kind of error at 11:00 PM daily and I have checked at that time the only job running is "DBCC CHECKDB of one...
RAM on the server is 8 GB, PLE is almost showing less than 300 through out day, if this is showing less values what action we need to do? please let...
Hello all, we have scheduled few performance counter on one of our SQL Server and they are showing more than the optimal value, can some one please...
yes u can check the available space in properties of the database..
Some times the space available shows 0 MB in the properties, once execute the sp_spaceused procedure and if that shows any negative values you may...
Hello All, Daily in the night we are getting the database blcoks and those were for the same reason, i.e process A is blcoking process B, process A...
Separate names with a comma.
