Allan Mitchell wrote:
> Hello ChristinaO,
>
> You ran out of locks?
>
> How many was that?
>
> Have a look here
>
> http://www.sql-server-performance.com/sql_server_configuration_settings.asp
>
> Are statistics up to date?
>
>
> Allan Mitchell
> www.SQLDTS.com
> www.SQLIS.com
> www.Konesans.com
>
>> Hi Allan,
>>
>> Thank you. Yes, they live on the same server. When I've tried to
>> dojust that, I ran out of locks. I'm not sure how to get around it?
>>
>> Allan Mitchell wrote:
>>
>>> Hello ChristinaO,
>>>
>>> If the database is simply a database on the same server then the
>>> action i think you will need to perform is as simple as an UPDATE
>>> statement with 3 part naming
>>>
>>> <database name>.<owner name>.<object name>
>>>
>>> Performance is based on indexing if this is a searched update.
>>>
>>> Allan Mitchell
>>> www.SQLDTS.com
>>> www.SQLIS.com
>>> www.Konesans.com
>>>
>>>> Hi all,
>>>>
>>>> I have a table w/ 50 mill. rows. I need to update 2 columns. The
>>>> table looks like:
>>>>
>>>> patientrcd# patient# facility subtitle datetime page
>>>> -------------------------------------------------------------------
>>>> 0202013 23432 B 05/17/0402 NULL 1
>>>> 0202013 23432 B 05/17/0402 NULL 2
>>>> I need to :
>>>> 1. 'NULL' subtitle column (varchar)
>>>> 2. Populate datetime colum with a date from another database
>>>> note: there are no identity columns
>>>> Is there any way to leverage DTS to do the job? OR do I have to find
>>>> a way to break the data down into chunks and write multiple 'UPDATE'
>>>> stmts?
>>>>
>>>> I'm new to DTS, so just wondering....
>>>>
>>>> TIA
>>>>
>