ALTER TABLE [tableName]

DROP CONSTRAINT [constraintName]

will remove the constraint, then you can modify the column attributes.

Try to figure out who that IP address belongs to. It could be that they are trying to log into SQL Server or they have some sort of network scanning/inventory...

ALTER TABLE [tableName]

ADD CONSTRAINT [constraintName]

PRIMARY KEY ([columnName])

make sure the field is not nullable and there are no duplicates

it means someone is trying to log in with a blank username. the connection is originating from the ip you have x'd out.

is that the same ip address as your...

It's a best practice to not use it. It's got way too much power and is a *known* sysadmin login account which makes it super easy to brute force your...

"To execute DROP DATABASE, at a minimum, a user must have CONTROL permission on the database."

Do not give your users CONTROL permissions on the database.

Disable the sa account, don't use...

I was literally just having this discussion yesterday.

My reasoning stemmed from lugging around giant technical books and the back pain that comes along with that. Now, I don't own...

Oh man! The AL east is really tightening up. Only 1/2 game separates first and third!

The Sox starting a 7 game road trip beginning with a three game series...

I think he means something like this

select

CASE WHEN t.RESULTa < 0 THEN '<0'

WHEN t.RESULTa between -1 AND 6 THEN '<=5'

WHEN t.RESULTa >5 THEN '>5'

ELSE ''

END AS BUCKETa

from

(select

CASE WHEN...

Yep, I had that in mind while writing it and that's why I liked the...

I like the patindex idea, I'll have to keep that one in the ol' toolbox.

Here's what I came up with

declare @x varchar(50) = 'Jane Smith 05 18 2011 mamm.pdf'

select cast(replace(substring(@x,

CHARINDEX('...

Perhaps a little explanation as to what the script does or how it does it. Might be helpful for those that are not familiar with these operations.

If only Syed Jahanzaib Bin hassan were here...

Thanks for the article, it provides a little more insight into that age old problem.

I dunno, I come to work every day thinking "I can't wait to get home and...

One game behind the yankees in second is better positioning than three games behind the Rays in third.

Think...