This should be something similar:

RESTORE DATABASE restore_db

FROM DISK = 'C:\temp\GSBDThursday.bak'

WITH NORECOVERY, REPLACE

, MOVE 'GSBD_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL$SQL2K\data\restore_db_Data.MDF'

, MOVE 'GSBD_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL$SQL2K\data\restore_db_Log.LDF'

RESTORE LOG restore_db

FROM DISK =...

The definition of the maintenance plans are stored in the system database msdb. Take a look at the sysdbmaintplan* tables. I assume you can also use SQL-DMO for it, but...

If you do want to use scripts however you need to use the WITH NORECOVERY option for every backup file that you restore except the last one.

You can still use EM. Just make sure that in the dialog where you specify the backup file to restore and the database to restore to you also switch to...

1) A trigger is code that is executed when an action occurs on the table that the trigger is created on. How could you 'have a trigger inside a stored...

It was quite some time since I worked with Component Services, so I cannot say for sure. There are two timeouts you can set. The first is for object creation...

Good advice, and yes it is always worth pointing out. As I said in another thread, if we start using physical properties telling the DBMS how to access the data...

Are you getting any specific error message?

i am seeking some way to do a timeout or something, well if no way to do it, the only way is to implement it in the method itself but...

No, there is no such construct in SQL Server, and it is not something that is missed. A record number is a physical property and not something that we should...

OR are you saying you are getting data in the main View that you do don't have in any other views ?

That is the problem as I understand it.

Jan, you are still not clear enough for us to be able to post anything helpful. Is this your real DDL? If so I would be surprised if you are...

Nice! Glad that you liked the article.

SQL Server 2000 does not have that functionality built-in, like SQL Server 2005 will. You could do it using for instance a temp table where you insert the result rows...

How do you mean? This example would return a single row with three columns, with the values 1, 2 and 3 in those columns.