I don't believe it's possible with a Check Constraint. Pretty sure a trigger is the only way to do this one.

What do you mean? SQL Server will load on boot unless someone has tampered with the initial settings. Do you mean power was removed from the server and...

To the best of my knowledge, point of time recovery that includes bulk inserts, is possible only with FULL RECOVERY... and then only if you're backing up the log very...

mobasha (5/26/2008)

---

it would be like this:

he ask for sa i say i have no such login, tell me what u want and i will provide u with a user to...

Without knowing the structure of the data at hand, I'd say just load it, edit it when necessary, and add to it whenever you need to. If necessary, you...

I've found that there's a "tipping" point between the performance gains realized in denormalizing information and joining for the same information. If the denormalization results in millions of rows,...

Believe it or not, it means it's connected and working fine. I had the same problem when I first saw it... Red usually means something is wrong.

I'm pretty sure that you just shot yourself in the head performance wise... the myth that all CLR's are faster than T-SQL is just that... a myth. Most of...

If you want the data automatically from the previous month based on today's date, do NOT use BETWEEN because it will either miss most of the last day of the...

I agree... shared locks on a set of reporting tables aren't much more expensive than using a WITH (NOLOCK), and WITH (NOLOCK) will not prevent deadlocks. Don't forget that...

I can't get over the gut feeling that it's a bad idea, but here goes...

First, make sure that some other user, preferably some DBA (yourself?) has SA privs.

Second, open SSMS...

One more quick question... which table are all the times (and other columns) coming from? I can't tell because you're not using table aliases on the columns. The...

I agree with Gus... multiple-choice questions make a test easy to grade and that's all. My "favorite" multiple choice question looks something like the following...

Which of the following roles...

I don't see why you need a CASE statement to begin with...

CONVERT(DECIMAL(6,2),ISNULL(SUM(CONVERT(NUMERIC,CRC.Contact))/NULLIF(SUM(TalkTime+HoldTime+WrapTime+WaitTime+PreviewTime+DeadTime)/3600.0,0),0))

One simple forumla will return correctly whether the domain is present or not...

DECLARE @MyDomainName SYSNAME

SET @MyDomainName = 'firstname.lastname'

SELECT SUBSTRING(@MyDomainName,CHARINDEX('\',@MyDomainName)+1,128)

SET @MyDomainName = 'DOMAIN\firstname.lastname'

SELECT...