Hi Steve,

well, I can give it a try.

In the SQL statement you see above is one 'GO' at the end to drop the temporary table.

That´s the only one I have...

Hi Lowell,

thanks for the quick reply.

Well, I have several databases where I have the condition TrivPages > 1000 so the script itself works fine.

The strange thing is that I cannot...

Hello Brian,

First, thanks for your endeavor.

I just created an ODBC conenction and it works fine.

Also, the backup server can access other database engines (SQL 2K and 2K5).

Greetings

Dirk

Yes, other remote access is possible and there are no errors in the sql log.

Hi again,

I have just checked the sec-logs.

Nothing unusual to see.

It is really a strange behaviour.

My colleague runs a workaround.

First, creating a dump file via SQL manager and afterwards just backing...

Yes, TCP is enabled.

Browser is running and we even tried to connect via IP and Port number.

Everything looks fine.

We also see the server with the instance in the BackupExec Browser.

But...

Yes, beside the Builtin-Admins there is a service account (windows auth), which connects to that instance to get access to a virtual center database.

The Builtin-Admins never got removed.

Also, I put...

Hello Sergio,

thanks for the reply.

In our company environment we´re using SQL 2000 and 2005 servers.

So both scripts will be useful.

I think, I will try both after my 2 week holidays....

Hi,

thanks for the reply.

I just took the code from here, as it is.

http://www.sqlservercentral.com/scripts/SQL+Server+2005/63287/

Hi all,

I´ve tried to create the procedure but I got an error during the parsing process.

Msg 170, Level 15, State 1, Procedure USP_ExecReorgRebuildIndex, Line 48

Line 48: Incorrect syntax near '('.

I...