Viewing 15 posts - 571 through 585 (of 687 total)
ALTER TABLE [tableName]
DROP CONSTRAINT [constraintName]
will remove the constraint, then you can modify the column attributes.
May 24, 2011 at 12:09 pm
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...
May 24, 2011 at 12:06 pm
ALTER TABLE [tableName]
ADD CONSTRAINT [constraintName]
PRIMARY KEY ([columnName])
make sure the field is not nullable and there are no duplicates
May 24, 2011 at 12:02 pm
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...
May 24, 2011 at 10:25 am
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...
May 24, 2011 at 9:21 am
"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...
May 24, 2011 at 7:02 am
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...
May 24, 2011 at 6:20 am
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...
May 23, 2011 at 8:23 am
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...
May 19, 2011 at 11:09 am
David Burrows (5/19/2011)
Except for "Sometimes users are not consistent (put in three names or whatever). "
Yep, I had that in mind while writing it and that's why I liked the...
May 19, 2011 at 10:32 am
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('...
May 19, 2011 at 7:25 am
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.
May 19, 2011 at 6:39 am
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...
May 17, 2011 at 6:12 am
Ray K (5/16/2011)
True, but even then, we'll still be ahead of you! 😀
One game behind the yankees in second is better positioning than three games behind the Rays in third.
Think...
May 16, 2011 at 12:48 pm
Viewing 15 posts - 571 through 585 (of 687 total)