I don't think a trigger can do this since a trigger can only handle inserts, updates, and deletes, and if one of those fails then the trigger will likely not...

The tool you are using can help, BUT you need to extract all...

I agree that finding useful indexes is the key, you seem to be worried about space, 8GB is really nothing. You incur costs for indexes on the write, not...

ISO is a standard format that defines a CD or DVD disk as a single file. You can use something like the daemon tools or Nero's Image drive to...

Automagically no, but you could capture the highest value in a variable and then reset the table after..

DECLARE @maxid int

SELECT @maxid = MAX(Field1) FROM dbo.sometable

TRUNCATE TABLE dbo.sometable

DBCC CHECKIDENT( "dbo.sometable", RESEED,...

While the index tuning wizard does an ok job, performance tuning is as much an art as it is a science, the single greatest advantage we have is that mush...

How many rows are in that table? If the answer is one then fine, but I think you need to be more explicit in what you are trying to...

I have always used the one in the solution folder and not the bin folder, while they are often the same, the one in the solution folder is the last...

There is a component on Codeplex to do it from SSIS.. Let me find it...

http://smstask.codeplex.com/

If nothing else, it could give you some ideas on how to implement it in...

Also a good recommendation, the only reason I caution against is experience, replication is not for the faint of heart and this gentleman has expressed limited experience.. I think...

What version of SQL? 64/32?

I have to admit an 8GB db isn't all that big..

While you may have an IO bottleneck now I'm wondering if the hardware just highlighted...

1. Users and permissions are in the backup, but NOT logins, logins only exist in master, the copy may or may not need all of this depending on how the...

I have resolved that by using a lookup component to determine existence and adding a set value to the pipeline (usually a new column with the value 1), for records...

I just did a bit of research and the answer is, you can't directly in 2000.

But you could schedule a job yourself that periodically looks at sysjobs in msdb and...

For number 2, move it to a different directory like c:\wk , 2008 is REALLY particular about stuff in the boot root...

CEWII