I believe everything you need can be logged via counters in perfmon.

Thanx Dave, never too old to learn something new 🙂

definitely with bcp utility, and a query inside....

C:\>bcp "select top 50 * from DatabaseName.dbo.Table_Name" queryout Test.bak -U username -P password -c -t

use Rand() as [your values here or reference]

example:

SELECT CAST(RAND() * 1000000 AS INT) AS [RandomNumber]

Thank you for all the insightfull replies.

Seeing that we all agree more or less on the subject, I am putting this in my manual as "Best Practice" 🙂

No disrespect to...

http://www.sqlservercentral.com/articles/1324/

http://www.sqlservercentral.com/articles/1324/

"Microsoft® SQL Azure™ Database is a cloud-based relational database service built on SQL Server® technologies. It provides a highly available, scalable, multi-tenant database service hosted by Microsoft in the cloud....

can you...

Try RedGate SQL ToolBelt

and (SSC gonna hate me) Idera SQL Diagnostics Manager

We run an ancient VB6 based app, and level 80 DB on SQL 2005 STD.

Someone enabled automatic updates on all servers, and the patches ans SP's came in from hell...

Hi, please provide more detail?

which database? system? which file? mdf, ldf? etc....

any backups made recently?

We have one 37 million table having 20 + columns with all the person information, But almost, 7 million records having duplicate emails

But other fields are different.

Insert into New

select *...

You mean you dont have permission, to grant permissions to others?

have your DBA grant sysadmin rights...where and if needed.

to continue with what Steve suggested....

If 3rd Party tools are not available, build your own and very accurate health check system with perfmon.

include the SQL counters for growth, fragmentation, backups,...