Thanks a lot Jamie.

You were completely right.

I've tell a lot of times to Gila Monster that hope one day can help her as she helps me and now i must...

Hi there, the error was mine.

The sp that i send you is not the correct one ,i've attached the one that is good and where the query is fine....

Thanks a lot Jamie (everybody). Your answer was very useful to my work.

Regards,

JMSM 😉

Hi,

I'm using SQL Server 2005.

Sorry.

Thanks and regards

JMSM 😉

Sorry,

I think that you'll not understand the info that i post before. :blink:

I need to make one report that gives this information in one row for each database in one...

Hello,

Thanks for the information you send me.

But what i need is to get all this information in one table, so i need to insert this info in one temporary...

Hello everybody,

Thanks for the help, but i used one simple solution :crazy:

i locate the command prompt in the sql server bin directory and run the following command.

Open cmd and change...

Thanks for the answer,

But can you(anyone) tell me one query to get job history of all jobs that were running on a specific date (November 09(nine))

Thanks and regards,

JMSM 😉

Thanks a lot everybody.

Regards,

JMSM 😉

I'm talking about any change, so it can be DML or DDL

Thanks and regards,

JMSM 😉

Hi,

But is there any query to can check the last date/time when objects were changed.

Thanks and regards,

JMSM 😉

Hello everybody,

You've been fantastic, thanks a lot.

Thanks for the help.

Regards,

JMSM 😉

I think that u don't understand my question.

I've got one user that is dbo on 3 databases, db_datareader on another 3 databases and db_datawriter on more 5 databases.

What i need...

Hi there,

Thanks a lot but my SQL Server instance is SQL Server 2005, is there any tool so that i can get the same info that is given by PSSCONFIG

thanks...

Hi Gila,

Thanks a lot.... like i tell u any time u be usefull, hope one day have........ so knowledge as u ;o)

Thanks and regards 😉

JMSM