thank you.

Ok, i will put all the databases with the same owner "SA".

But i did not understood one thing....

Why do you say that all your databases have a owner that is...

that solved my problem. thank you

Situation:

I have a database named test.

I'm connected to it , through this app.

1) i put this database test in single user mode with success!

2) Then i make run some stored...

you say that you model and then pass it to visio.

Do you make the ERD model?

does Erwin help people that have some difficulties in modeling? Does it point you in the right way when you do mistakes?

Do you guys use Erwin to model? or other tool? or make every think in paper (work, etc..) and pas it to visio?

My question is, do you have help from...

thank you

Ok, still i have a question.

If i do like:

alter table .......................

exec (insert into ...............)

It works! and now i understand why, it's because the exec dont let the compiler see...

That's some particular situation that we have...

what about by SQl Server 2005 configuration manager?

If i remove the Builtin\Administrators login from SQL Server will they still be able to shutdown or restart the services?

suppose that i remove the domain admins group from SQL Server 2005 security tab. This means that no administartors have access to SQL Server databases and other SQL Server 2005...

as to filelistonly, that's a very good ideia, thanks.

about Durai Nagarajan's post i didn't understood the command very well. can you explain the command?

Thank you

and we do not have direct connection between the two places to do the replication...