Hello Sue,

Thank You for the reply.
I created a table in the Development environment. It appears to not be replicating.
The record count in the main table is...

I know this is an old Post. It is pretty much what I am trying to do. I used the backup via the GUI interface. 
I backed up database A...

You right! I forgot about that.

with the create statements

You gut's can delete this thread

it was the sql statement that was giving me the error.

I was looking at the wrong symptom.

When...

I made a Mistake above

The error is

[Execute SQL Task] Error: Executing the query "DECLARE @AssetsDB as varchar(50)

set @AssetsDB

= ..." failed with the following error: "Incorrect syntax near...

OK! Doing a little more research.

My identity column is a primary key column.

So I guess my question is!

Is there a way to insert data into the column that has a...

I just wanted to add more information.

DBCC CHECKIDENT ( table_name, RESEED )

message

Checking identity information: current identity value '0', current column value '1001003'.

DBCC execution completed. If DBCC printed error messages,...

Hi All,

My problem is exactly this post.

Running SQL Server 2012E

I have an table which I am loading with new data

I am entering value 0 and value 999999 two separate insert...

Hi Phil that worked for the insert into

How different would the select into be in creating another table

User Export got this

select

*

into TempTable.dbo.Evalthree --IN 'TempTable.mdf'

select

UserID , Identifier , FirstName , LastName , Phone,

(select getdate()) as "DateOne", (select SUSER_SNAME()) as "UserNames"

from

TempTable.dbo.EvalOne

The statement could...

What I am trying to do is move data using SQL from one database into another adding two derived columns

in this case Create date with the default of get date...

Hi Luis

Here is the correction output:

1K75

2i105

3r114

4k107

5l108

6a97

7n110

8d100

9-8208

10W87

11a97

12l108

13l108

14a97

15c99

16e101

Hi Stephanie,

SELECT LastName FROM DT5

WHERE CHARINDEX(nchar(0x02010), LastName) > 0

or where Charindex(nchar(8208),LastName) > 0

this get the desired out put

Kirkland-Wallace

Is there a cause for this behavior?

I do not understand the...

Hi Luis

Here are the Results:

1K75

2i105

3r114

4k107

5l108

6a97

7n110

8d100

9-45

10W87

11a97

12l108

13l108

14a97

15c99

16e101

That was a good thought!

SELECT LastName FROM DT5

WHERE CHARINDEX(CHAR(151), LastName) > 0

no results

SELECT LastName FROM DT5

WHERE CHARINDEX(CHAR(150), LastName) > 0

no results

SELECT LastName FROM DT5

WHERE...

I have reviewed this post and half way down it. I came upon a typo. It has referenced the type() when I believe it is the text().