Our app maps Windows users to generic SQL users who do have access to the DB.

Could you explain the reasoning for this?  Why can't your app just pass (delegate) the...

I agree with Mark in whole, I do this also, capturing the created_date, created_by, updated_date, updated_by along with a GUID and rowstamp (just incase replication is implemented at a later...

I assume you are referring to SQL Server database roles as opposed to Active Directory groups?  Have you tried using sp_helprolemember and passing in the name of the role, e.g:

EXEC...

Graeme,

That should be fine, make sure you don't change any account information from the Services MMC snap-in, that causes problems, always use EM.

ll

I tend to restore a backup I know contains the objects I need information about then run something like Red-Gate SQL Compare between the two databases to see the differences.

What...

Have you tried copying the file to a share on the SQL Server in the step when you change the extension from *.csv to *.txt?  This way the file will be local to...

I wouldn't say cumbersome is the word, I would say maintainable, stable and also upwards compatible if you plan to upgrade to 2005.  How long do you want this solution to...

Roger,

It sounds prefectly feasible but I would suggest stearing clear from writing scripts against your system databases.

Have you investigated the use of the 'SQL Server Agent Procedures' BOL: System Stored...

I think you'll find, in the 'Database Maintenance Plan Wizard' at least that you can only select 1 database for a particular Log Shipping configuration!  This is by design and makes...

Sounds like you have a problem with your MSDB database.  Have a go and see if any of the followuing helps?

- Is the 'current job history log size' also displaying...

Are you using an ActiveX object to copy the .txt file?  If so are you cleaning up in your code, for example by setting the object to nothing e.g. 'Set...

Adding on from John's response, we use Visual Source Safe (VSS) and if you add the following Keyword Expansion Header to the top of all your scripts VSS will fill...

Ethan,

Your choices really depend on your budget and how savvy the rest of your technical staff are.  I don't have much experience of any of the big change management solutions but...

John,

Personally I tend to go the same route as you for disk allocation, i.e. Logs on RAID1 (fault tolerance with normal read and write performance) and data on RAID5 (fault...

Happycat is correct. 

See http://support.microsoft.com/kb/329329/ I would suggest either installing SP3a directly or go straight to SP4 ASAP as all may look good but you may get anything from incorrect...