[/quote]

If it's still growing, query sys.databases and look what the log_reuse_wait_desc column says. That will explain why the log file isn't been reused and why the log has to grow.[/quote]

I...

All log backups are necessary.

A great article.

One question about transaction log. I have my databases in full recovery and I don't run backup logs. Every night I do a full backup and only...

Today I had this problem today. Thanks for the solution. It's easy and simple.

Microsoft team are crazy with his workaround.

Hi,

I don't want to attach/detach the database or backup/restore it because I have differents security users or groups in both servers and then I only wanted to transfer the Data.

I thought that...

I didn't remember this sp. It worked perfectly.

Many thanks for your help

In SQL2000 the store procedure works perfectly, besides you can change it in system tables directly.

I think in 2005 it would have to work the same way.

it did work perfectly.

Thanks Steve

I can't view the screen in your message about Collation Setting. I was receiving an error.

In the installation I only can choose Latin1_General_CI_AS.

In the text box I only can choose Latin1_General...

Thanks for your reply, but I am installing the server and I need to have the master database with that collation too.

I could install with SQL_Latin1_General_CI_AS and later to use...

I want to deny the access to the users with rights in the database. I don't want that they can see the content of the users o roles views.

I suppose...

Hi Mark,

I've just seen the error to move my diagrams one per one with your script.

Firstly, I ran just de SELECT portion as you told me and the result was always...

I ran the script in QA but I had the result 0 rows affected when I inserted the values into dtproperties table in the destination database.

Firstly, I created the dtproperties...

Thanks for your help.

I moved the diagrams perfectly.

Regards

UPDATE:

I have just tried to move another diagram to another database but in the "Select Source Table and Views" page I can not...

My MSDTC settings are:

• I put a tic in Network DTC access and below of this option I have enabled in Network Administration and Network Transactions
• Enabled XA Transactions too
• DTC Logon Account is...