Normaly the SA password are null, if you don´t change it at the instalation

The hardware is the same, including memory and configuration.

About the tip I’ve some doubt:

To rebuild a clustered index I can do with dbcc dbreindex or I need to dorp and...

The procedure runs 2 or 3 times most at the end of the month.

Its very complex, but I've the same procedure in another servers and this didn't show the problem.

...

Hi,

I don't know how to avoid this problem.

To solve, I create the login and after that I use the command sp_change_users_login.

Maybe it works for you to.

Takeda.

Hi,

I'm new on this busines, but if you put the user like owner of this table. In this way they can truncate the table.

I don't know, its a good idea?

Takeda.

...

Thanks Andy for the tip.

But my problem is something like that:

command:

xp_cmdshell 'dir c:\'

result:

03/16/01 01:30p 0 AUTOEXEC.BAT

03/16/01 01:30p 0 CONFIG.SYS

But whem I´m doing on Windows Me the...