Sorry, I typed too fast - I should have written SQL Server 2000 Unleashed

xyz, I think emailing them will only let me see the summary as I can already do.

amitjethva, I really need to understand and document the steps before I try and...

Just to confirm when doing an install, SQL Server only asks for an SA password if you change the Authentication from NT to mixed mode.

Brian, our Server is only accessible...

Thanks for the link - unfortunately I can not read the article unless I subscribe. Also I want to document and test a total disaster this article seems to be...

If we leave the default BUILTIN\Administrators with System Administrator privileges. Doesn't this mean we will never have a requirement to use SA.

In this case, as long as the SA password...

Thanks for the replies. I used Nigel's suggestion which works fine. The only problem I had is if users were still logged in.

I resolved this by using nhamilton script...

I had the same problem running SQL Server under a local system account. This problem and others with debugger were resolved after have a new specific NT Login created and...

Where possible Jet will send efficient SQL to SQL Server when using linked tables and only retrieve the rows required.

However there are circumstances where Jet will return complete tables from...

I am fairly new SQL Server but have some Access 97 experience.

I have gone down the Access 97 front end (unbound) / SQL Server backend route because I did not...

For info - my copy ordered on 19 Sept arrived in the post this morning. Just over 4 weeks to United Kingdom.

Many thanks - that looks just the job

Stefan

I have experienced problems transferring logins so this article will be very useful if I have to do it in a live situation. Just one clarification.

Would it be necessary...

Thanks, that worked perfectly. I just changed the first check to

if (SELECT Count(sid) FROM Master..SysLogins WHERE name = @UserId)=0

because I think there was a typo. This now runs...

I want to create HTML pages but not quite sure where I run these scripts? In the Query Analyzer? Procedure? DTS? I am sure the answer is obvious but would...

phillcart, thanks very much for your very helpful reply. Problem I am finding with DTS is that none of the books I have go in to sufficient detail.

Hopefully there...