it's the order of operations.

create table StudentAccount references table Instructor,

so the script has to create table Instructor before it can

create table StudentAccount;

i reordered that one table...

I've got an HP G71, and bought one of thosse SSD/HD replacement Caddy to replace the DVD in the Side Bay with an SSD caddy.

it was really easy to do...

pretty sure all you need to do is toggle this option:

it's in place to prevent someone from making accidental changes:

after that, you will be able to modify the column in...

here's a few different ways to recover access by adding yourself as a sysadmin:

via powershell, which supports impersonation by a local admin:

http://sqlblog.com/blogs/argenis_fernandez/archive/2011/07/10/think-your-windows-administrators-don-t-have-access-to-sql-server-2008-by-default-think-again.aspx

via A Scheduled Task, which supports impersonation by a...

GrassHopper (5/31/2013)

---

I have a comments field that has certain values I want to extract into it's own field(new must be created). What is the syntax for doing this?

the data...

The code is tested at parsing time for all objects to exist;

it doesn't allow logical testing to be ignored.

you could switch to dynamic SQL instead to avoid the error.

IF exists

(SELECT...

well, the default trace only keeps the last 100 meg of DDL...

agreeing with Dave, it seems to work fine, but it assumes that MFM always exists and is always those three letters int eh first three chars.

if we are grabbing something...

Stating the obvious, a database doesn't just get set to single user by itself, some process or person actually issued the command.

that ALTER DATABASE command counts as a DDL operation,...

my SSMS for SQL 2012 is in this folder:

"C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"

My question for you is whether you want to Replace the current call for SSMS with the 2012...

weekly updates screams drop and recreate to me; if you needed any changes/updates that were mere seconds old, it might be a...

if this was just an insert form the source, you'd ideally want to find a way to find the max(id/createddate) from the target, and get records that are greater than...

it's a quote, i...

The Dixie Flatline (5/30/2013)

---

GilaMonster (5/30/2013)

---

The Dixie Flatline (5/30/2013)

---

GilaMonster (5/30/2013)

---

I just delete that kind of thing outright, long with the 'Answer my posted question', 'explain life, the universe and everything to...

my wild guess to provide a rough example: note i'm truncating the time portion of hte datetimes to the day.

With YourTable

As(

SELECT 1 AS SomeColumnForGrouping,CONVERT(datetime,'2013-05-30 07:26:30.157') AS CreatedOn...