:laugh:I just tried to do a SELECT INTO and for the first time ever I got an error.

That's what I get for suggesting that it is better to do an...

:w00t::hehe::w00t:

tfifield (11/29/2011)

---

I find SELECT INTO as a very handy dandy tool to create a table quickly. If I'm a bit queasy about letting a big DELETE or UPDATE query...

IMHO, faster does not necessarily mean better.

Are you going to define Indexes on the Table?

You are not going to be able to return a variant data type.

If your RETURN VARCHAR(255) then that will be the data type for each column that you use the...

cafescott (11/29/2011)

---

I'm using select-into rather than insert-into because I don't have a good idea what the table structure is. The select statement is huge, and it is much easier...

Why are you using SELECT INTO as opposed to an INSERT INTO?

I executed it in the Publication Database and I get...

Created a new thread in the Replication forum since the topic has changed.

http://www.sqlservercentral.com/Forums/Topic1213268-291-1.aspx?Update=1

Karl,

I agree that replication should be dropped but I can't do that without an ok from someone.

As far as the sp_repldone it looks like my only option at this time.

In...

These are the LSN's that I get when I perform the following:

CREATE TABLE #OpenTranStatus (

ActiveTransaction varchar(25),

Details sql_variant

)

-- Execute the command,...

😎

Evil Kraig F (11/28/2011)

---

You want it to look like:

insert into #t1(col1, col2, col3, col4, col5)

Select

col1, col2, col3, col4, col5

from

R1

where

R1.col1 > 0

and R1.col5 =...

Removed post.

ok, thanks.

Is a trial version of CozyRoc available?

I'm sure that it is a great product but I would need to prove that it would help with a specific project that I'm...

Jeffrey Williams 3188 (11/25/2011)

---

If you can confirm that the database is no longer (or never was) involved in replication, you can disable the replication (sp_repl_done). If that doesn't work,...