ah

In short: you have project category in Visual Studio: Other Project Types/Setup project. You have to create one and add a custom action...

Seems that if you create a nonclustered index on idaccount, dateEffect which is partitioned using your partitioning scheme, you can gain some benefits.

I made a simple test and seems that...

That's what I would do. In my opinion, this user instance mode feature can make more problems - say - someone has a Standard or higher edition of SQL Server...

If you want to do it this way, you must not use temp tables. They exist only in scope they were created in, in this case within context of your...

BOL says that select expression in CTE has to meet same requirements as the one for view, so no dynamic SQL inside.

I would use a DDL trigger for the database. You can specify which changes should be prevented. Any modification to the diagram would fire the trigger and you could raise an error and...

my guess is that it calculates fragmentation of the index - this seems to be the only 'variable' property displayed on the dialog. maybe you would consider rebuilding indexes using T-SQL...

look at the bcp utility in books on line. it has functionality you need.

Is the error reported on IIS machine? Can you run perfmon with log and try to monitor mem usage on both machines? Is it possible that there is a web...

Strange. You could try to run SQL Server setup and install Client components once more. I just noticed that when client tools for SQL 2000 are installed on machine, Client...

Probably you have to use SMO to do this.

You can modify deadlock resolving using SET DEADLOCK_PRIORITY per session, but I don't know if it will help you. I suppose you would have to change this setting for all connections...

I wonder, would it be possible to change at least one of the drives to RAID 1 or 10? Would it improve performance if log files of most loaded databases were...