Hi Steve,

I guess the test and testtype together would make it unique. I mentioned joins because someone else mentioned it in another posting. Could it be possible to use a...

Hi there,

If I have the same situation multiple rows unique ID but the number of rows are dynamic would I have to create a join for each and how in...

Thanks so much! That was it. Thanks again.

Laura

Thanks, I'll check it out.

Laura

Okay,

I got it to work, this is how:

1. I stopped the SQL server

2. dropped the offending database

3. restored the database in EM calling it the name of the...

Thats what I was afraid of. The exact message is :"The backup set holds a backup of a database other than the existing 'campus6' database. Backup or restore operation...

Hi there,

deleted, backed up using the syntax,tried to restore got the same message. Any thoughts?

laura

Hi there,

Here is the syntax to create the backup file on the secondary server:

BACKUP DATABASE [Campus6] TO DISK = '\\secondary_server\ABTSql\campus6Live.bak' WITH

INIT , NOUNLOAD , NAME =...

Thanks Steve,

That would explain it.

laura

David,

Stored procs I can do! I'll try to make it on my own, if I have problems I'll come back. Can xp_sendmail work with SQL 7.0 or is that just...