I'd figure it doesn't matter - probably dot net will open more microsoft house doors. Never believe those who tell you one something will replace another. When I started 16...

My workstation has sql 2000, 2005 and 2008 all installed. I have all services set to manual and start up which ever one I want. Generally you don't need the...

I think that sometimes the desire to achieve a goal masks the requirement. I've seen many hours spent trying to replace cursor statements on pieces of code which run once...

sorry I'm still no wiser - I'd log a call with microsoft at least you should eventually get an answer.

btw. I actually cycle my logs every night on prod and usually weekely on dev boxes - more simple solution.

it may be the proc is returning some output. I'd use EXEC master.dbo.sp_cycle_errorlog; in place of the dbcc and I'd make sure that the return statements are consistent if...

not seen this proc used for this before, and having read up on it am still no wiser. It did seem to indicate it would only run single threaded which...

I think it's what works for you is best. Using schemas to group objects is one way in sql 2008, but if you have too many schemas it may lead...

I did actually think that CDC could store who made the change - sorry not implemented yet so having to think back to the demos of it I sat through.

You can only really enforce this if all your data access is through stored procs, or you place triggers on the table.

user_name() and similar functions will capture user info. But...

as I'm just in the process of migrating from sql2000 to sql2008 for my current client I'm using

dbo.sp_help_revlogin_2000_to_2005 , you should also have a proc called ...

for step by step you can replace the cursor with a while loop. But to be honest " if it ain't broke don't fix it ".

Do you want to remove...

it may be the log is too big. Try using wordpad to view it

sorry - should have said that any timeout messages are usually a client issue not a server issue.

There's actually quite a lot of free stuff available for monitoring if you have a search, and writing your own stuff isn't too difficult - there are some examples on...