Microsoft SQL - Changing Owner of Table

So.... While searching the web for how to change the owner of a table on a Microsoft SQL Server I came across a lot of

sp_changeobjectowner '[olduser].[tablename]' , 'dbo'

(and unfortunately I see a lot of current suggestions on this - so y'all need to do your homework and if you are going to simply google an answer so you can get a "point" on MSDN you really need to make sure it's the right answer!)

I kept getting - Object 'olduser.tablename' does not exist or is not a valid object for this operation. - turns out that sp is deprecated in SQL 2012 and so won't work for us!

turns out what we need is

alter schema dbo transfer [olduser].[tablename]

All good! :)

Jamie

MVC3 - Entity Framework - Database First

Well, that's a mouthfull! :) I wanted to share my experiences setting up an MVC3 project using an existing database and the Entity Framework.

Bye Bye Northwind â€“ Welcome Adventureworks!

If youâ€™ve done any database tutorials in the past, youâ€™ve no doubt come across the Northwind sample database. Iâ€™ve recently found out about a new sample database â€“ the Adventureworks sample database!

FREE Bill Scheduling Program

Hey Guys! I haven't posted anything in my "Software" section in a long time (Even though that's what I DO every day) and I thought I should start to share more So here's an app that I wrote, that I use to schedule my paychecks and bills - check it out and you can have it for FREE!

The problem I have is that I get paid every two weeks and my bills are monthly. This app lets you forcast out all of it in one nice grid and totals things along the way. You can instantly see if at any time you're account is negative becuase the line will turn red, and you can also mark items that you have paid, but have not cleared, and those turn green so you know not to pay them again.

It's very simple and super useful!

ASP.NET Remote Membership Tool

So Microsoftâ€™s got this great Website Administration Tool that you can run locally and manage your users and roles for your site, but whatâ€™s lacking is a tool to do the same remotely. Read about how I solved the problemâ€¦

Microsoft SQL - Changing Owner of Table

MVC3 - Entity Framework - Database First

Bye Bye Northwind â€“ Welcome Adventureworks!

FREE Bill Scheduling Program

ASP.NET Remote Membership Tool

More Articles...