Hi All, We are using SSIS ( SQL server 2008 ) for porting data from a DB2 database to another SQL server DB. We have established OLE DB connetion...
Thanks Subhash
Thanks Satya. But I want to extract the SQLs used in each step of DTS packages.We have close to 200 DTS packages. We want to consolidate the SQLs...
Please let me know if there is a sp or table which will list out the table names and SQL included inside a DTS package
Hi...<br />It worked.Thanks[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Regards,<br />SARAVANAN.G<br />
Hi All, Hope you are doing fine. We are using SQL server 2000 as the database server in our project. We need a small clarification on revoking table...
Yes Deepak.I do undestand. Thank u Deepak and Shashank for your reply. Regards, SARAVANAN.G
If I am using EM for restoring the database how can I make use of NORECOVERY option? Is there any provision for that? Or should I use Query...
We are using SQL serevr 2000.We have taken differential backup of a database.Now we want to restore it.Since its a differential database backup it...
Can anyone tell me how to restore differential backup? Is there any special procdure other than normal restoration procedure? Regards, SARAVANAN.G...
Hi, Can anyone tell me how to make the SQL Mail running and how to check whether its running? Regards, SARAVANAN.G Technical Analyst Regards,...
I would like to know the explanation about other coulmns like replca,recovery,restart in restore details and file type in backup table? Regards,...
In the table restorehistory I could see a column 'replace' with values 1 and 0. Can we say that the values 1 shows 'restorations' and 0 shows...
Thanks Madhu... Regards, SARAVANAN.G
Hi, I would like to capture the historical backup and restoratin information of a database.Is there any SP or something else to find the above...
No...It just for future refernce... <img src='/community/emoticons/emotion-1.gif' alt=':-)' /><br /><br />Regards,<br />SARAVANAN.G<br />
Thanks Madhu... But just want to know what are the options available to reduce space... Regards, SARAVANAN.G
Here's the exact picture.... database size: 7337.06 MB Unallocated Space: 1261.70 MB Reservered: 5881044 KB data: 3889632 KB index_size: 1871880 KB...
No...We dont have lot of insertion actions.Only few updates.Regarding the space...We dont want lot of unused space.Because that itself more than the...
Separate names with a comma.
