Yes, export / import the data will be fine for you, as said above, and easy too...

Else there are other ways as well.

- Win.

If you are on Win 2003 box, you can give a try ,

Administrative Tools -> Local Security Policy -> New window - >Local Policies -> User Rights Assignment - >...

If you change the SQL Server service account, change that to Agent as well and restart the services.

It should come up and running fine.

Is this SQL Service account, a windows...

Can you tell us the table size and number of records ?

Is this 64-bit SQL Server? Check the standard reports for top 5 queries by CPU usage and diagnose it.Look at perf mon for CPU counters and correlate with SQL profiler...

Hello matt.newman,

Thank you for your time checking this and providng the links. I have done much research in googling the information, nothing clicked to me. Now, Lowell gave some beautiful...

Thanks Lowell..

You are good to help, and the steps what you have mentioned are correct as max logins are default to MASTER as it happens in all servers and in...

I checked TraceTable records, it logged 6844 connections in 24 hrs of time.

But only MASTER database details and in application name it shows only SQL Agent info.

as below...

SQLAgent - Step...

Thanks Lowell for your clarification. That was a great help done by you.

I want just to get the DB name and connection made on it, either applciation , or an...

Can anyone look into this and help me in resolving ?

Thanks in advance.

Hello Lowell..

Thanks for your help on auditing and for your query..

I tested that in my DEV environment, but its giving only MASTER database info alone.

I tried creating that in...

Thanks Lowell for your suggestions and response....

Iam affraid of using it, Iam sorry already I have an issue with my one of the DEV instances. Its not allowing me to...

Your script is of cursor, will that eat my Server Memory, CPU... ?

Will this hit every second or only at logon ?

I used this script for tracking logons and it...

Thanks Nadeem, appreciate your help...

I will definitely test this and get back to you.

I applied DDL triggers but then failed to connect SQL Instance:

Logon failed for login ‘sa' due to trigger execution.

Changed database context to ‘master’.

Changed language setting to us_english. (Microsoft SQL Server,...