The DBA's quite right, you need "WITH CHECK" explicitly specified (or allowed to default). I don't see an option in scripting to explicitly specify this (at least through 2008...

Grant Fritchey (8/16/2014)

---

ScottPletcher (8/15/2014)

---

What is(are) the clustering column(s) on the table? You need to read each 1/4 of the table at a time using the appropriate clustering key range.

What...

Shouldn't the event you want to intercept be "ALTER_DATABASE", not "RENAME"?

You'll need to interrogate the event data to identity a MODIFY NAME = vs other types of alter database commands.

What is(are) the clustering column(s) on the table? You need to read each 1/4 of the table at a time using the appropriate clustering key range.

What are there nonclustering...

AZ Pete (8/15/2014)

A unique constraint cannot be implemented since the combination of LocationId and ExternalId must be unique only for the cases when ExernalId is not null. There can be...

You should be able to create a DDL trigger to prevent database renames, at least through ALTER DATABASE. I hope sp_renamedb would get caught as well, but I haven't...

Alex R (8/15/2014)

this is the latest syntax error:

EXEC sde_Stage.dbo._aaa @table_name = ''GLOBAL'',@date = ''OBJECTIDLIST'',@reduce = 0.0025,@oid =''3476,6673''

SELECT * FROM OPENQUERY ([10.100.1.40], 'EXEC sde_Stage.dbo._aaa @table_name = ''GLOBAL'',@date = ''OBJECTIDLIST'',@reduce = 0.0025,@oid...

I don't believe you can use varchar(max) across linked servers; try varchar(8000).

Something like this:

SELECT ServerName

,SUM(CASE WHEN FileType <> 'LOG' THEN FreeSpace ELSE 0 END) AS 'Available Data Space'

,SUM(CASE WHEN FileType = 'LOG' THEN FreeSpace ELSE 0 END) AS 'Available...

You don't want quotes around the variable names, just the values, if they are not numeric:

SELECT * FROM OPENQUERY ([10.100.1.1], 'exec mydb.dbo.mysp @p1=''mytable'', @p2=0.0025,@p3 =''3476,6673,3321''')

That looks fine, unless you're trying to reference the return values, in which case you need to add an alias after the OPENQUERY(...) AS alias_name.

As to the current design, I'd make these comments:

CVEducation

InstituteName should 100% be normalized out to another table.

DegreeName should 98% be normalized out to another table.

Maybe SponsorID should be in a...

Unless I'm missing/misunderstanding something, I think this will do it:

UPDATE dbo.x_SCORE

SET

score_Gender = CASE WHEN myGender = whatGender THEN point_Gender ELSE 0 END,

...

Add quotes around "18", "26" and "28" when you check for those values:

CASE

WHEN left(LTRIM(RTRIM(account_number)),2)...

Yep. You just need to CAST the first column as varchar:

...