yes you can.

easiest way would be to right click the database and then script the database as a create, then change the name and filepaths, then restore the backup into...

I shall remember that Lowel, copy and ftp home.

Kyrpto, was just making sure that the data wasn't going to breach any standard like PCI-DSS if it was credit card details...

out of interest what is the data when it is un-encrypted? credit card numbers, passwords, sensitive information?

did you try my script?

Your talking about object level restores which are not avilabile in SQL as standard.

I know LiteSpeed for SQL server from Quest Software has object level restores built in but this...

what account is the SQL Agent running as on A? Is it local system? Could you add a login to B which is DOMAIN\A$ and give it the...

can you post the error details from event viewer for the starting of the service?

have you followed the steps which opc.three gave?

if...

you will need to alter the column to be not null and then create the primary key

GilaMonster (3/14/2012)

sys.sysobjects and sys.sysindexes are deprecated, included only for backward compatibility with SQL 2000 and should not be used in any new...

its the same, but you need to specify 0,2 where 0 is the log number and 2 means SQL Agent Log, so say you wanted the 10th rolled over log...

you need to join sys.dm_db_index_physical_stats to sys.sysindexes

the below is what i use to get all the indexes in all databases which have more than 8 pages, more than 0%...

lots of good links on google, do a search for ssis 101 or ssis basics and take a play in BIDS, knock up a couple of packages and test them...

different ways to do it

you could as I said, copy the data from server 1 into server 2 and then do a update on server 2

or

you could use a data...

You could transfer the data from Server1 into a staging database on Server2, then write a stored proc which joins to the staging database and does the update.