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...

Prasad Bhogadi (10/11/2007)

---

But it is not a bad idea to use CASE with a SELECT prefix as such you are not going to lose any thing.

SELECT CASE WHEN @value =...

It works fine for me when I do the create and the alter. Are you using SQL Server 2000? I notice that the error was in line 3......

Frank

To run the backup automatically, schedule it as a job, or use a database maintenance plan. You can read about those things in Books Online.

The reason your restore failed...

Ravi

Have a go yourself and post back with what you come up with - then we can see if we can help you further. Here's a hint: look up...

Start with precisely that, I would say - revoke access from all of their technicians, get rid of BUILTIN\Administrators, and make sure that sa has a strong password known only...

Have you outsourced your DBA support to that company as well? If you have, then the DBAs there will need full access to the database. But you should...

If you wish to do it this way then I think your only option is to use dynamic SQL to build your SELECT statement, then either EXEC or sp_executesql to...

Yes, I think that would work as well as backing up and restoring. The only problem I see is that you...

There is an undocumented stored procedure sp_execresultset in SQL Server 2000, but unfortunately it wasn't carried over to SQL Server 2005. Is this what you were thinking of?

I think...

Ajay

It's not easy to see what your requirement is. Please will you provide table DDL in the form of a CREATE TABLE statement and some sample data (preferably that...

I would recommend using INFORMATION_SCHEMA.COLUMNS instead of syscolumns, since it doesn't rely on system tables, which may change from version to version (or even service pack to service pack). ...