jhindman (6/26/2008)

---

Scott,

Thanks much for your reply. When I try to use the osql -E command, I get a Login failed for user 'domain\username'

I assume that means the logged on user...

Try using osql to connect to SQL Server (you should be able to connect using [font="Courier New"]osql -E[/font] from a command line). Then run these commands:

[font="Courier New"]sp_grantlogin 'NT AUTHORITY\SYSTEM'

go

sp_addsrvrolemember...

Are the regional settings the same for each server (check via Control Panel)? Check the time/date formats as well.

Check Books Online:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/ce3aa9eb-300d-46e7-b56b-505fc5d84571.htm

John Bates (5/27/2008)

---

In the 3 companies I've worked for, none had the Enterprise Edition.

It would be interesting to see a survey of the percentages of DBAs who have only Standard...

It will depend on how your application is configured to access the database server.

If you use ODBC DSNs, then you may need to reconfigure the DSN per computer.

If the application...

Check to see that your queries are using the indexes that are there.

I haven't tried it myself, but you shouldn't have any problems. SQL only logins will be unaffected (not dependent on Windows at all), SQL logins from local Windows accounts...

Make sure you configure SQL Server Agent to use your DBMail profile (right-click in Object Explorer, properties). And restart SQL Server Agent once you have done so, otherwise it...

You cannot backup the log for the master database. It is in SIMPLE recovery model which does not require a log backup to be done. This cannot be...

Remember that the connection used to connect Object Explorer to a server can be different from a connection used to open a Query window.

If you fire up a connection to...

1. I don't think you can avoid the reboot. Besides which, it would be better to reboot to ensure everything is going to work properly afterwards, now. ...

I can see how defragmenting works on a single physical drive (after all, that's where it all started).

I've always wondered though - how does it handle drive arrays? Windows...

It depends on what the app is doing. I've got a web app that hits the database server about 2600 times an hour (user initiated). And that's still...

If the global group was not already in the local group when the account was added to the global group and restart wasn't done after adding to the global group,...