The simplest solution I can think of is to disable the DDL trigger on the Production DB, backup the production DB with the trigger disabled, re-enable the trigger on your...

Let's not forget that too many indexes, especially on a small table, will probably cause more performance problems than they resolve.

Best case is to do 1 clustered and maybe 1...

I'm guessing, but have you tried the sqlncli.msi? If MS is using proper naming conventions, I would read this as SQL Install Client... But I could be wrong.

The readme...

John,

How are you trying to restore? Via the GUI or via T-SQL?

Also, did you check the sys.files table on the database in question? See what files SQL Server...

What type of DDL trigger did you create?

Remember, even if you're talking about the trigger being set up on a database scope, if the DDL trigger has anything to do...

Which direction are you going? Are you creating 2005 as a linked server on 2000? Or vice versa?

I don't think the first one will work. I...

I've had problems before in 2k5 where using the GUI to attach the DB wasn't working properly and while the database showed as attached, the sys.databases table didn't know it...

Make sure to notify your end users about the restart of services BEFORE you do it. They may lose data if you don't. (Data not commited to the...

I'm fairly new to the db design world myself, but here goes my opinions...

My first thoughts are purely datatype related.

Rating is 1-5. Why is it an int? If...

And Divide By Zero errors can kill your query if you don't use Try..Catch or some other test for income being zero, so make sure to take that into account...

Just an FYI to the original poster, init does NOT overwrite backups that have not expired or the set name in the t-sql doesn't match the name on the backup...

The business logic of only attaching copies of the .mdf and .ldf is that if these files get corrupted or set suspect when you're trying to attach them to 2k5,...

The problem with splitting TempDB is that it doesn't work very well if you're putting all the files on the same logical drive. The idea behind there being a...

Then take what I said and reverse engineer it a little. Since you're already inside, you know what the weaknesses in the system are. Start documenting them.

One of...

Xintanaka,

It sounds to me like you're trying to justify to this small company why they should hire you, correct?

In that case, don't take impersonal data and usethat as a justification....