I believe that you would need to use dynamic SQL, to create the database.

declare @cmd varchar(max)

select @cmd = ' create table ' + @newdb + '.dbo.mytable (myid int)'

exec (@cmd)

Here's the bigint doc. You'd need to compare it to the Oracle documentation

http://msdn.microsoft.com/en-us/library/ms187745.aspx

If you get a PK error, then you have a PK update occurring.

What I would do is change this to a SELECT, and pull out the PK columns from...

Roy Ernest (12/13/2010)

---

Brandie Tarvin (12/13/2010)

---

Wow. I just had the worst time trying to post to Grant's blog. Three times I had to try before my post went through.

You'd think he...

Tom.Thomson (12/12/2010)

---

Yes, it changes now...

Excellent response from Lowell and Gus.

Tom, new avatar?

I've used them, often as a base maintenance setup for systems that aren't stressed or critical. They have worked fine.

However when I need finer control, I tend to use custom...

Craig Farrell (12/10/2010)

---

Steve Jones - SSC Editor (12/10/2010)

---

Craig Farrell (12/10/2010)

---

I'm failing to see the problem with this... I'd purposely go out of my way to wander through said lounge on...

Jack Corbett (12/10/2010)

---

I understand both the fact that's it's not a highlight and, especially, the travel part. I just want to encourage everyone to give it a shot as...

LOL, I have to say...

Brandie Tarvin (12/10/2010)

---

Horses don't feed...

Christoph D (12/10/2010)

---

Prakash-205770 (12/9/2010)

---

From the view of database architect, sending emails is a business functionality and need to be hosted in a separate server as separate application! The application needs...

AndrewJacksonZA (12/9/2010)

---

Steve Jones - SSC Editor (12/9/2010)

---

I'm not sure how much of a budget I have to change hardware, especially as this works. There is a few minute slowdown as...

Prakash-205770 (12/9/2010)

---

From the view of database architect, sending emails is a business functionality and need to be hosted in a separate server as separate application! The application needs to read...

Jack Corbett (12/9/2010)

---

Jeff Moden (12/9/2010)

---

Travel money, hotel money, earn money... I'd love to make the trip from Detroit to Florida this time...