Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

I have a print command at ever end. When I test the code its kicking back to this part of the code saying incorrrect...

Lynn Pettis (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

I have a print command at ever end. When I test the code its kicking back to this part of the code saying incorrrect syntax...

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

I have a print command at ever end. When I test the code its kicking back to this part of the code saying incorrrect syntax near '('....

Dont I need to use parenthesis to open and close the alter table statement? If I delete it then ill get an error near VARCHAR

I have a print command at ever end. When I test the code its kicking back to this part of the code saying incorrrect syntax near '('. I dont know...

Oh man...I meant to add in my error message :doze:

Incorrect syntax near '('

What am I missing in this dynamic sql?

BEGIN

SET @nSQL = '

IF NOT EXISTS (SELECT * FROM '+ @SourceDatabaseName + ' .INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_SCHEMA = ''dbo'' AND

TABLE_NAME ...

Sean Lange (8/7/2012)

---

morepainot (8/7/2012)

---

Ok, so I am pretty much through my script. I am getting 2 errors througout the script and of course I dont know why. I think its...

Ok, so I am pretty much through my script. I am getting 2 errors througout the script and of course I dont know why. I think its because I have...

Ya, I just used 4 single qutoes and I think Im getting what I need. The databases here weird. I had to inner join other tables in order to get...

Lynn Pettis (8/3/2012)

---

morepainot (8/3/2012)

---

Incorrect syntax near the keyword 'of'.

SET @nsql = '

SELECT

DataType of Column + ColumnName + '' of the Table ' + 'TableName+'' is not...

Incorrect syntax near the keyword 'of'.

SET @nsql = '

SELECT

DataType of Column + ColumnName + '' of the Table ' + 'TableName+'' is not same as its...

Sean Lange (8/2/2012)

---

morepainot (8/2/2012)

---

Sean Lange (8/2/2012)

---

Well the code certainly looks a lot better. But it doesn't help me identify why you are getting an invalid object name. I can't see...

Sean Lange (8/2/2012)

---

Well the code certainly looks a lot better. But it doesn't help me identify why you are getting an invalid object name. I can't see your screen from...

Sean Lange (8/2/2012)

---

Because it doesn't exist? 😛

It is tough to figure that out from here. Does the table...