Roy, nary and tnk,

My question remains the same. New user with this database role would be able to see through my dmvs... Could you read my question once again...

-Lucky

SELECT TOP 1*

FROM

(SELECT FirstName, Lastname, Dates As LatestDate

FROM computert1

INNER JOIN computert2

ON computert1.id = computert2.id)tmp

ORDER BY tmp.LatestDate desc

Without variable

SELECT FirstName, Lastname, Dates As LatestDate

FROM computert1

INNER JOIN computert2

ON computert1.id = computert2.id

WHERE dates = (SELECT MAX(dates) FROM computert2)

-Lucky

DECLARE @Date DATETIME

SELECT @Date = MAX(dates) FROM computert2

SELECT FirstName, Lastname, Dates As LatestDate

FROM computert1

INNER JOIN computert2

ON computert1.id = computert2.id

WHERE dates = @Date

-Lucky

Ur following query is incorrect...

select empdate, count(id),category from table

group by category order by empdate

Pivot is a correct option to get this kind of result

Sql server doesn't support nano seconds as far as I know. You can to use VARCHAR columns to get this info. But as soon as you CONVERT them in date...

You can't take the backup of DB which is in the restoring state. Create a job which takes the backup of only principal DB. This can be found from database_mirroring...

Roy,nary

HERE IS THE PROBLEM!!!

This kind of user would be able to see your all the system views though. Is there anyway to bar him from seeing system views as well.

(I...

INDUCEDTRANSFORMFAILUREONERROR itself says that pdf can't be imported.

Even though DATETIME saves the space in comparison to INT, this should not be the only reason to save the data in DATETIME and not in INT. I would focus...

Oh thanks

Yes this worked Michael. But i want to do the same with Google Software Updater (gusvc). This didn't get started :(. can anyone hellp out here?

PS C:\Windows\system32> Get-Service | Where-Object...

Thanks Lowell.

No Kingston. This didn't work. Even when I tried as follows:

and sk.level1name like LTRIM(RTRIM(@ucf)) +'%' :(This didn't work.

Practically you should not have more than 5-10 nonclustered indexes per table. This would really degrade the performance if ur database is in OLTP environment. OLAP is fine having more...