Yeah that's what I thought. It's going to be much easier to rebuild my master DB as it's just a test server at this point. There will be too many...

Thanks for a fantastic DDL tracking tool. I wrote a similar one using server wide trigger auditing logon events.

Is there a way to stop the deletes coming through as...

Thank you Gail - very helpful as always.

I am using logon triggers because once management decide which logins they want to prevent, it will be easy to roll them...

Hi Gail,

Just wondering if you have any clever suggestions for preventing the login trigger from stopping logins altogether? I've written a trigger which logs all logon activity to a database,...

Yes exactly - it is because we upgraded from 2000 to 2005.

Thanks all for your help.

Joanna

Thank you everyone for your responses.

That is correct - AWE is not required in 64 bit SQL Servers, however lock pages in memory is imperative.

Kind regards

JPea

Thanks Rbarry, I think you may be right. Intersting that it works this way.

The stored proc just grabs a whole bunch of connection information based on the SPID passed via...

You will need to install the DTS Designer Components on the SQL 2005 server to allow you to manage the DTS packages via Management Studio in SQL 2005.

Once this...

If SQL Server is installed on the server you should see a list of services in configuration manager when you click on 'SQL Server 2005 Services'. You can also check...

Nevermind - it seems that the FTE domain account was not in both SQLServer2005MSFTEUser$%1$MSSQLSERVER AND SQLServer2005MSSQLUser$%1$MSSQLSERVER which it needs to be.

Thanks Gift - I know you can, the problem is that i get the error message posted above indicating that it will only work if you run it under the...

You will need to temporarily remove the servers from the Oranisational Units in AD that the GPOs are currently applying to and then add them back in once the app has...

Yep, looks as though i had to just uninstall the office web components and then the install worked. Cheers.

California,

Unfortunately there is no single authorative text which will give you a step by step guide. Each environment is unique and has different requirements. Start by finding out what requirements...

In a default installation of SQL 2000/2005 the BUILTIN\Administrators group is a member of the sysadmin server role. So unless it's been removed for security reasons, you should be able...