Did find one website that actually seems to solve this issue to some degree 🙂

http://www.eggheadcafe.com/software/aspnet/31826673/last-time-a-database-was-accessed-sql-2005.aspx

Ok and so if you would issue with command:

create login test with password = "123"

Do you get the sql from EventData()?

Yes I´ve also been looking into the Profiler, but always thought that was for temporary auditing, but maybe I could utilize that for permanent auditing.

thanks for the videos, I´ll take...

Ok select (size*8)/1024 from <dbname>.sys.database_files is the correct query then to get the size in Mb 🙂

Thank you very much for this nice explanation 🙂

Yeah, there it says:

Current size of the file, in 8-KB pages

Still I don´t really understand the difference :/

What if I have a table that has a clustered index in the primary key and I put a non-clustered index on the date column. Would that also produce...

Is it not possible to run stored procedures through a linked server? I have RPC set to true.

I always seem to get this error:

Msg 7357, Level 16, State 2, Line 1

Cannot process the object "exec msdb.dbo.sp_help_job". The OLE DB provider "SQLNCLI" for linked server "JOB_TSSQL6" indicates that...

Ok I will try the logging feature, although I´m not sure exactly where to see the problem.

The load speed to the oracle server is about 30.000 rows per minute.

Now after...