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...
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...
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...
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...
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...
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...
Hello all, We have enabled job notification for all the SQL job on a server and some times the some of the jobs getting failed to notify, when I...
When I check the properties of the database space available is showing 0 MB. but if I try using dbcc showfilestats it has lot of free space, any one...
If we have a full backup at 12AM and log backup up at 10AM and server crashed at 10:30 AM and if we want to recover the data completly till 10:30 AM...
Any one please help me in resolving the below error...<br /><br />in SQL Server logs I found the error<br /><br />Error.<br />Event User: N/A.<br...
Any one please help me how to change the the value of DATABASEPROPERTY? For example: in my test database the value of "select DATABASEPROPERTY(...
One of my server got restarted and after restart the SQL mail was not working, I stopped and started SQM Mail using the scrip stopmail and start...
Hi, On one of my server from task Manager I found that the most of the CPU is using by sqlserver , is it possible to find which process is using...
Hello all, Is it possible to create a task in DTS packages on 2000 server to process the Cubes on other server which is running 2005 analysis...
Separate names with a comma.
