First a tutorial on how Windows Authentication works.

A user logs into his/her computer. That computer is part of a domain and the user's login is authenticated by the domain...

What is your access (permission) level? Maybe that's the problem.

-SQLBill

Best of luck. With the great job you've done with this site so far, the move should go smoothly. You've done all the proper steps...plan it, notifiy users (and family)....

I thought there was an Oracle forum (maybe there was one and now it's gone).

Sukhoi,

Since this site is SQL Server specific and not Oracle, I would like to suggest...

There is an undocumented stored procedure called sp_MSforeachdb. This lets you run upto three commands on each database. You can find the syntax by using Enterprise Manager, expanding Master database....

Downsides:

1. takes longer to backup to tape instead of disk.

2. normally a third-party software is used. This is not always trustworthy.

3. tapes wear out. You have to make sure your...

Now I look at it the other way...I answer 80 easy questions, get all right, and have 100% right. You answer 500 questions which are easy and hard, get half right, and end...

Chris,

Sukhoi is out of place with the comments made. You did a good job on answering a person who isn't even willing to post in the proper forum.

This site...

What is the error message?

Possibilities: 1. your SQL Server is set for Windows Authentication only and S1 is not on a domain that is 'trusted' by S2's domain.

2. A firewall...

Don't forget that the free space is included in the backup. The free space IS part of the database. This might be causing your problem. Try to shrink the database...

Does your friend have SP 2 installed on XP? If so, it might be due to SP 2 blocking TCP Port 1433 and UDP Port 1434.

Another issue might be the...

Read the BOL, it's your best source of information.

The transaction log keeps track of all transactions (trans). When a trans is stopped before completing, the log is used to rollback...

Never heard of anything like that and I definitely wouldn't want it on my system!

One of my tables has 111,273,436 rows. I definitely wouldn't want ALL of those returned just...

First try to PING the SQL Server machine from your client machine.

Start>Run type cmd and click ok. Then at the prompt type PING servername and see if that returns anything....

To add on to what everyone else is saying....

Remember you can not concatenate numbers. You can only concatenate strings. So you must convert numbers into string values.

If you don't have...