Try this:

DECLARE @DB varchar(25)

DECLARE DBCursor CURSOR FOR

SELECT [name]

FROM master.sys.databases

...

What constitutes an ADD? For an existing ID, is the field blank (or null) if there is no entry?

😎

Could you provide the DDL for the two tables involved?

😎

Could you explain this in a little more detail?

😎

Here is the code using dynamic sql:

use [MyDatabase]

go

declare @T sysname,

@SQLCmd nvarchar(max)

set @T = 'second_db.dbo.more_records'

set @SQLCmd =

'update dbo.addresslist set

...

First, to do it the way you are trying, you need to use dynamic sql. I haven't written it that way yet, but based on your posted code I...

So far I have only done this once, but on one request for help after a few back and forth posts by several people (I seem to remember at least...

NE huh. Welcome to my stomping grounds. If after you drive in and out of the state, you have any questions about oh, say....corn. Let me know!!...

You may want to run DBCC CHECKDB on the database.

😎

Can you run a full backup manually using SSMS?

😎

As it looks like you are using SQL Server 2000, I'd use DTS packages to import the data from the two tables. Of course, you have only provided partial...

Hey, any info I can get and send to our PeopleSoft Administrator now is good. Gives her more time to digest it and bounce ideas off the consultant we...

Not tied to any one way or other, actually looking for alternatives that we can compare and evaluate. As with anything, we have to look at the application and...

Here is the official word: CA etrust ITM version 8.1

Matt's right on that observation. Instead of teaching someone to fish, we end up doing the fishing, and we get nothing in return. Well not totally true. ...