He's right in some aspects, but not all. Bad code is still bad code. You need to get him to define exactly what he intends to use and do. See...

Correct. Unless there's an explicit deny along the way. It trumps everything.

You can through disk administration move what drive letter the CD-ROM sits on. Of course, this might affect other processes, but it is always a possibility.

Start | Run | Compmgmt.msc

Disk...

If you're getting a script timeout error, you can set that value within the ASP.NET code.

First day of training was fairly interesting. I'm taking the Enterprise Security course. Basically it's looking at a model for putting into place a sound security mechanism within an organization....

Two things. Check statistics on the database and make sure they are up to date. Check possible fragmentation at the file level. If you're writing a bit each each it's...

OK, I see the issue. You're using Enterprise Manager to create a backup device. If I recall correctly, it only looks at the SQL Server drives, etc.

You can do this...

If neither is going to change their settings, then you're pretty much stuck to a web gui solution. Unless Fasthosts allows some sort of secure tunnel in via VPN or...

You can script the jobs.

How to script jobs using Transact-SQL (Enterprise Manager)

Yup, it's up for the beta team as well. Lot of good stuff it looks like.

Listening on 127.0.0.1 means localhost, and that's not a cause for concern.

Is the computer multi-homed? Does it have more than 1 IP address configured? You can check this by running...

You can do this....

Create a directory on the C: drive. Map that directory as E:. Create the MSSQL and the Scripts directories underneath that directory.

It's the quickest approach. A...

Please do not cross-post. I have replied here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=128031

You're going to need to configure at least one of the servers as a domain controller. The command dcpromo allows you to do this if you're using Windows 2000 or...

Looks like MSDE installed as an instance. You don't have to specify this in Query Analyzer?