Denny,

if we use this from analyzer it wil throw error as its a command not sql syntax.

bcp "tempdb.dbo.DimProducts" in "c:\Users\Shay\Documents\DimProducts.txt" -T -c

Msg 156, Level 15, State 1, Line 1

Incorrect syntax...

bcp [tempdb].[dbo].[DimProducts] in

"c:\Users\Shay\Documents\DimProducts.txt" -c -t

You don't use BCP from Query Analyzer. You run it from a command-line window.

you should use -c and not -C. The spacing should be OK,...

Hope this helps :

http://msdn.microsoft.com/en-us/library/ms162802.aspx

No one knows any suggestions here ???

Allright, thanks...

Can anyone provide suggestions ?

Please find the attached results.

More information:

typeallocatedvirtual_resvirtual_comawetopFivegrand_total

CACHESTORE_SQLCP158888000CACHESTORE_SQLCP158888

MEMORYCLERK_SQLUTILITIES1125201201200MEMORYCLERK_SQLUTILITIES112640

OBJECTSTORE_LOCK_MANAGER4057616384163840OBJECTSTORE_LOCK_MANAGER56960

CACHESTORE_OBJCP45712000CACHESTORE_OBJCP45712

MEMORYCLERK_SOSNODE25984000MEMORYCLERK_SOSNODE25984

-- top 10 consumers of memory from BPool

select

top 10 type,

sum(single_pages_kb) as [SPA Mem, Kb]

from

sys.dm_os_memory_clerks

group by...

Hello All,

Sorry track this to another way.

- Is there anyway that to track the Logins, created date, accessed date, when it was accessed the particular database.

Is this question makes...

Thanks much for your time.

Sorry to say, but I was looking for SQL query to store data into a temp table. So that client can query that and test or...

Log folder doesnt shows info clearly.

Here we have enough preveliges... Donno why they need only SQL Script for this.

I explained like SQL Server 2000 is not the much smart to...

I am sorry, I should have been more clearer...

But we need this to be implemented in 2000 & 2005 servers as well.

Not C2 auditing. Simply enable server properties security for...

SQL Server Auditng is enabled on this instance.

Am I posting unclear question ?

can anyone post any ideas on this ?

can we track in any way ??? Is this possible in SQL Server 2000 ?

Nothing clicked to me.. accdate shows wrong information. Any other help please..!

One more query :

Is there anyway to track the logins last time used on a particular database in SQL...