You would need to give them a SQL Server authentication login. Then provide them the connection information (Server name or IP Address, instance name, port number). Then make sure...

When you restored the database, users become orphaned. They exist in the database, but not in the 'instance'. In Enterprise Manager, expand the database and look at the users. Compare...

Check out RSA. They have tools that will encrypt data as it moves from the front-end application to the back-end database.

-SQLBill

The WITH MOVE is only used as part of the RESTORE DATABASE command.

From the BOL:

D. Restore a database and move files

This example restores a full database and transaction log...

In the BOL, use the Index search, look up LIKE. Choose the option for the Transact SQL entry. Scroll down until you see Pattern Matching with the Escape Clause.

-SQLBill

Scheduled every hour from 12:25:00AM - 11:59:00PM

Is that true, are you really trying to restore a differential backup EVERY hour? Can't do it. You can only restore one Full...

First, it would help if you told us what the error is instead of making us guess.

Next, guessing I would say that your database is still in LOADING mode. ...

Can you provide sample data as it looks in each of the tables? That way we can compare the original data to the results that you want.

-SQLBill

Check out this link:

http://msdn2.microsoft.com/en-us/library/ms345193.aspx

-SQLBill

Why not break the delete into smaller batches?

-SQLBill

A lot of times, weird questions are just asked to see how you think and if you can defend your answer. Then there are the 'trick' questions to see...

Try this.

In Enterprise Manager, right click on Microsoft SQL Servers. You will see an option for Export List. Export the list, copy it to the new location.

-SQLBill

What is the datatype of the column? I'll bet it's VARCHAR. That will drop trailing blanks.

-SQLBill

This is the way a JOIN is done in an UPDATE statement. The tables Item and Sectn_Dept are being joined to limit the values that get updated.

In other words, the...

Since we don't know what your schema/data looks like and what you did, it's difficult to tell what the error means.

My guess....you have a Primary Key or Unique Key set...