There are many options, but here are a few.

You can use the Computer Management utility to check if the service is running.

You can use the SC command line utility from...

J (1/15/2009)

---

Michael Valentine Jones

Create database roles for different types of user access, assign database and object permissions to database roles only, and then add individual users to...

Create database roles for different types of user access, assign database and object permissions to database roles only, and then add individual users to the correct database roles.

Jack Corbett (1/14/2009)

---

Do you work for...

I just saw our CEO (30,000+ employees) was wearing a hoodie and jeans today.

Guess I’m going to have to start dressing down.

This way will prevent SQL Server from bypassing the check.

Case statement conditions are evaluated one at a time, and processing of the case stops on the first true condition.

Select

9 as...

If you mean a true remainder, this will give it:

select 2621475%65535

If you actually mean you want to see the decimal fraction, this will give it:

select 2621475./65535.

As to why, you should...

Getting back to the original subject of the T-shirt, I just looked at our company manual, and it specifically bans wearing T-shirts, along with sweat suits, hats, tank tops, stretch...

I have rarely seen anything below 99%, so I don’t pay much attention to it.

I look more at Average Page Life Expectancy and Page Reads/Sec. These seem to be...

Going strictly by the stated requirements, then -2147483648 is the lowest unused value.

RBarryYoung (1/8/2009)

---

Yeah, but "YDM" is not the date standard for any nation. That's why ISO choose it. And what is the alternative way to do this that is...

DATEADD(YY,1,MyOldDate) is the way to go to update the year, but you should be aware that dates of 2008-02-29 wirll be converted to 2009-02-28, because there is no Feb 29...

sqlservercentral (1/6/2009)

---

Thanks for the feedback so far. I was curious as to whether the use of an Identity column for the PK would result in a possible bottleneck when several...

The best way to handle this is to let SQL Server compute the time difference as a datetime (EndTime-StartTime) that is an offset from 1900-01-01 00:00:00.000 and then parse the...

CAST(CAST(ROUND(dbo.invoice_line.qty_shipped, 0) as int) as varchar(40))