It's an ebook and Simple Talk was distributing it. Drop a PM/mail to Tony Davis (here or over at simple talk) and ask.

What's a form id?

Your questions aren't making much sense by themselves. Can you please explain, in detail, what you're trying to do and what's not working?

Mine had that problem too, before I remembered about Ceiling.

smunson (12/3/2008)

---

I'm talking about ALL the service accounts that can be assigned during the installation process. I'd like to follow best practices for a server environment, despite...

nazaninahmady_sh (12/3/2008)

---

because the ntext is pointer and it save data in different places i can not write a query for transfering data of body ntext from source table to body...

Edit: Didn't read the round up. Recalculating....

Edit 2: This one works.

declare @tbl table (Val numeric (8,2))

insert into @tbl values (0) -- to 0

insert into @tbl values (1.21) -- to 1.5

insert...

What does the schema of the destination table look like?

You said you had a query to copy the data over. Can you post it?

It has? It's exactly the same error with exactly the same insert statement as I helped...

Can you post the schema of the two tables and the query please?

Correct me if I'm wrong, but hasn't this been asked and answered twice before? (exact same insert statement and exact same error)

http://www.sqlservercentral.com/Forums/FindPost610162.aspx

http://www.sqlservercentral.com/Forums/Topic610173-1291-1.aspx

Did you apply the patch to both the server and the machine you're running the client tools from?

What my colleagues used to do was RD into a...

Great.

If I may suggest...

Evaluate your backup strategy in light of this event.

Set up a job to run checkdb (without...

Here's a query that should work

This will work providing you have no table partitioning. If you do, it may give strange results

select object_name(p.object_id), ds.name as FilegroupName

from sys.partitions...

I'm afraid not. Procedures must be called with the EXEC statement and a view may only contain a single SELECT.

If you need to join the output, you'll have to insert...