i'm still confused and looking in the wrong place, clearly.

i did sp_helptext 'sys.fulltext_catalogs', and it's a system view on my 2008 instance, i'm not seeing the same code you posted;

can...

i would disagree.

if you look at the definition for 'sys.fulltext_catalogs' via sp_help, the datatype is clearly int for the column fulltext_catalog_id you are selecting

/*

Column_name ...

you can explicitly call CHECKPOINT yourself, would that help?

--UPDATE MyTABLE ....

--INSERT INTO SomeTable

CHECKPOINT

--UPDATE MyTABLE2 ....

--INSERT INTO SomeTable2

CHECKPOINT

balasach82 (4/5/2013)

---

Error: 18456, Severity: 14, State: 5.

The login ZZZZ exists and it is linked to the user in the db. Still we get the error

>>> Login failed for user...

here's a very similar version when compared to Jasons;

if a user matches it's login SID, it fine and nothing needs to be changed.

If the SID doesn't match , it builds...

assuming the data types of col1 and col2 are varchars:

update SomeTable

SET Col3 = Col1 + Col2

if they are integers, you will have to explicitly cast/convert the two columns.

the actual execution plan, if oyu can post it as a .SQLPlan file, would give us the most detailed information;

aside from that, here's what i see:

i see six objects in...

would doing something like selecting a newid() help?

for example, have them do something like this:

SELECT

NEWID() AS RefID,

OtherColumnsButNotTheRealID

Into TableForExport

From tblPatients

--OR

SELECT

identity(int,1,) AS RefID,

OtherColumnsButNotTheRealID

Into TableForExport

From tblPatients

then...

sql has the ability to update a table based on another table, you just need to get used to the syntax.

the advantage is it would be set based,and allow you...

glad i could help a little Sapan;

note that sp_msForEachDb is really is a cursor behind the scenes;

while cursors are generally frowned upon, when fiddling with metadata, this is one...

rajarshi_ghosh_05 (4/4/2013)

---

{snip}

No. We dont bother about the temp table data not if anything happens like network failure or server restart or user system restart! We dont have to preserve that...

you restore the last good backup as a new database name.

then you can use cross database queries move differences from one table to another;

depending on the foreign keys, you might...

RexHelios (4/4/2013)

---

Didn't realize we could sue other members' stored procedures 😉 Just an attempt to pump some humor, Lowell. No offense meant....

something like this seems to work for me, see how i modified it to sue sp_msForEachDb, and to INSERT INTO a #temp table, and read the results at

the end.

CREATE...

you have to select form a CalendarTable, which would contain all possible dates, and left join it to your data that has the rest of the data.

you can generate a...