[font="Times New Roman"]

Hi,

You may try following script.

SELECT AgencyName,AgencyId

FROM ContactAction

WHERE AgencyName IN

(

SELECT AgencyName

FROM contactAction

GROUP BY AgencyName

HAVING COUNT(*)>1

)

ORDER BY AgencyName

Regards,

Anil Kumar

[/font]

[font="Times New Roman"]

Can you please explain what happens when we execute DBCC CHECKDB?

Regards,

Anil

[/font]

[font="Times New Roman"]

I was doing all that by creating a view on specific table columns then assigning permission on view.

Thanks a bunch for your valuable suggestion.

Best Regards,

Anil Kumar

Infosys

[/font]

[font="Times New Roman"]

Yup, i missed that point. log file usage for bulk logged and full recovery model are same if there are no bulk operation.

Regards,

Anil Kumar

[/font]

[font="Times New Roman"]

Hi,

Bulk logged recovery model may not provide point in time recovery if there is any bulk operation executed against the database since the last back up because bulk...

[font="Times New Roman"]

Please be informed that resource database included in SQL Server 2005. in SQL Server 2000 there was no resouce database. mssqlsystemresource.mdf and mssqlsystemresource.ldf files belongs to Resource database.

Thanks,

Anil...

[font="Times New Roman"]

Hi,

System databases for SQL Server 2005 includes master tempdb, msdb and model databases.you might have noticed that there is no resource databse in SQL Server 2005 as all...