In the simple term, he wants the DB backup location to be your server instead of his server. Then he should have access to the shared folder on your...
DBCC LOG does not give the record detail. you might use 3rd party tools or can create a trigger to records the event.
Hi All, We are migrating data from Lotus Notes to SQL Server 2005 for PHPBB application. The issue we are facing while updating a ntext column with...
How do I migrate from LotesNotes (.nsf) to SQL Server? Iam planning to do the following let me know if my assumption is correct. 1. Downliad the...
Yes that is the correct process. Follow the MS KB : http://support.microsoft.com/kb/958734
Adding a trigger looks a good idea dont you think that will degrade the perf. My situtation was different I partitioned table in non peak hour by...
BOL is quite helpfull Iam not denying, when you have less time and you are trying some thing for first time you need so many information and...
Not clear about the steps. There are 10 millions of rows in the existing tables.Simple steps could be fine.
Hi, Let me know the steps and guidlines to do this?
I clould have posted that. After researching for sometime it is clear the my query is a pure table scan it does not doa cluster index seek as there...
<P mce_keep="true">I have a large table with 80,000,00 records. My query is very slow it takes more then 45 minutes to return the result. let me know...
I am new to SSIS 2005 and don't know VB & need urgent help on how to skip first few rows from the excel sheet. In the excel sheet my data starts from...
We want to setup the Transaction replication using VPN but the it is a different domain. HOw do we configure it? Please share some information on...
Thanks for the reply. With a speed of 100 mbs will it be able pull minimum 100 mbs od data per day. Any other consideration like security, scheduling...
Hi, I want to know what are the parameters I need to concentrate while configuring Transaction replication over VPN? What is the performanace if...
Thank you all of you. This was an exception written in the SP. We fixed it. Thank you all once again SQLWorld
Hi All,When I try to exec a Sp in my SQL Server 2005 Sp2 management studio I receive the following compilation error:Msg 18054, Level 16, State 1,...
Separate names with a comma.
