Stephen

Use the ROW_NUMBER function. You'll find it in Books Online and there are some examples of how to use it in there as well.

John

Ewan

Are you saying you have two instances on the same computer: a default instance and a named instance called mssqlserver?

John

Ed

Did you check the destination file for triggers? Is there an error message? Have you checked the errorlog and the Windows Event Log? Try opening the text...

Ed

Have you worked out which rows are missing to see whether they have anything in common? Is it the last 1656 rows from the text file? Is there...

Do you have a backup of your database when it was 512MB? If so, perhaps you could restore it to another server, or on the same server with a...

There is another way, and that's to use the information in sysreferences and sysconstraints (I think) to write a script that will give you the tables in a hierarchical order....

One way of doing it, if you have the patience, is to use the database diagram tool in Enterprise Manager. This will show you which tables have relationships with...

roger clarke (6/20/2007)

---

Well, I'm afraid I am not at all impressed with this article ... just one more example of the painting by numbers crowd who will never really get...

Frank

Please will you post the RESTORE statement your trying and the exact error message it returns.

Thanks

John

Jon

How about a job that runs every day at midnight and checks the values in the StartDate column against today's date and copies them over if it's identical? Here's...

Sorry, I don't understand what you mean by "from 2 days". What sort of database is it, how many users use it and what sort of transactions does it...

I would go for option 1. If you went for option 2 and loaded your data after creating the indexes then you'll probably find that loading the data is...

I can't think of any reason why this should not be possible. Make sure you take regular backups of all your databases and test them so that you know...

Frank

There are sample scripts for RESTORE DATABASE in Books Online, so I won't repeat them here unless there's anything specific you're having a problem with.

I would advise restoring the full...

Frank

You would create the job using either the GUI or the sp_add_job stored procedure. Jobs are actually stored in the msdb database.

To restore a differential you need to restore...