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

If you're using SQL Server 2000, then DBCC DBREINDEX will lock the table it's indexing. That means you're likely to encounter timeouts and so on in your application as...

Simon

I think this is what I'd do:

(1) Back up all your databases

(2) Test that you can restore your backups to a completely separate server from your cluster

(3) Uninstall SQL Server...

What have you tried so far? I would advise you to read about the RANK function and see if that helps you. If you're still having trouble, please...

You seem to have run out of steam a bit there, Aaron! When you get round to posting the rest of your select statement, please will you also provide...