Indeed, it matters not.

Right click on databases, select restore.

In the box type in the new database name, hit the options tab and change the RestoreAs filenames.

RESTORE DATABASE <NEWDBNAME>

FROM DISK  = ' <FILENAME> '

WITH MOVE ' <DATAFILEFROMSYSFILES> ' TO ' <NEWDATADISKFILENAME> ',

MOVE ' <LOGFILEFROMSYSFILES> ' TO ' <NEWLOGDISKFILENAME> '

Depending on the MDAC version on the front end I believe that it will connect to udp1434 to learn the port that SQL is running on, so it shouldn't be...

If you're database connections are using DSN's to connect you can just change the port in the DSN. I'm not sure about using strings built directly within an app however.

I would certainly change the firewall rules, I would also change the port that SQL is listening on from 1433.

Also if you are managing a lot of users it's far easier to manage their access through Windows groups as opposed to individual logins.

Check the share and directory level permissions for the SQL Server Agent account putting the files out on the server. The rights might be restrictive for the account.

The main thing is that SQL Auth uses sends the password in plain text accross the network. Windows Auth doesn't.

Has anyone changed the server side regional settings overnight?

Try detaching the database, dropping the login, adding the login again making sure that the sid matches the sid on the original server. Then attach the database, you should have...

How can you set up a raid 10 array with an odd number of drives?

Looked at this from the newsletter...followed the link http://www.cooljules.co.uk/ntl.htm

Kinda freaked me out, this person is from my hometown and went to my school.....hate getting freaked out like that

You're really kinda in a bind having the 4 drives, ultimately you are going to be wasting 1.

I'm not sure what kind of disk space you are looking to have,...

You can put the inserts, updates and deletes within a proc, you just have to build and execute a dynamic sql statement to do so...

CREATE PROC INSERT_ORACLE_DATA @INSERTVALUE VARCHAR(25)

AS

DECLARE @sql...