I hadn't seen error 7391 in the log files (SQL log or Event Viewer). However I saw wether I had MS-DTC enabled and it was enabled but in Security Configuration I...

Yes, the windows login has the same permissions as SQL login.

In fact, when you launch the query after the connection with SQL login then the query work perfectly.

I think that...

Although I saw in the web that the tool was for W2000, I did a registry backup and I run the MDAC repair.

After I take a look into ODBC Administrator and, surprise,...

No.

There aren't any drivers listed in ODBC. I think is very strange. I have W2003 SP1 installed.

Only there is the value that I told you.

There aren't anymore.

I can't delete this value.

I received the message "Unable to delete all specified values"

The value into this key is :

• Name: Default
• Type: REG_SZ
• Data: (value not set)

I tested to delete all key...

In the Control Panel I haven't SQL driver.

I run component checker but it shows the message "The following products releases were matched: UNKNOWN"

After, I have installed MDAC 2.7.1 but in...

I installed SQL Server and Analisys Services and later I un-install Analisys Services. When I wanted to connect to the server from EM, it's was imposible. The MSSQLServer service is started...

Hi,

you can take a look in the BOL the "Using Startup Options" and you can use these parameters to specify an alternate master database file or master database log file.

I...

He creates the tables as dbo because he write the sentences like this "create table dbo.mytable ..." and after everyone can read or work with this object.

The problem begins...

He creates the tables through QA because he has db_ddladmin role but when he wants to modify the design or to add data from EM then he received the message. I...

About db_ddladmin role, from EM he opened the table which he was own and he received the message. I think that it's a warning because he could save the changes, but,...

Hi Chris,

I have another test database and here he can do everything but sometimes he ask me something that he can't do it in the production environment, for example to...

Hi,

I think is better attach/detach instead backup/restore because is very simple and quickly.

If the db size is very large I would choose the first method too.

Regards

Thanks wz700,

the method was right