Keith Thomas (4/29/2009)

---

I created a simple Maintenance Plan to backup a database. I no longer needed the plan, so I deleted it. I assumed it would also delete...

Nilesh (4/29/2009)

---

I would like to know what replaces Temporary tables in T SQL Stored Procedures.If I have to write the same stored Procedure in Oracle. Taking into consideration same tables...

Every user has automatically access to the master database via the guest account. And yes, that is necessary, don't remove the guest account.

So in your case, I would simply...

You prosted this into the SQL 2000 section, so I assume you're using this version.

But EXECUTE AS was implemented with SQL 2005.

Have a look into SSMS tools pack.

Among other very useful feautures it also offers the option to run a TSQL script against multiple database.

http://www.ssmstoolspack.com/Features.aspx

You can compress your backupfiles by calling a compression tool through xp_cmdshell, but personally I would advise against it for two reasons. First of all you need even more diskspace...

You should use a Join instead of the subquery for the id.

Try this:

UPDATE TABLE1

SET statutSpecifique =

(SELECT dpStatut FROM @tempTableStatutDp)

FROM Table1 JOIN @tempTableStatutDp t

ON Table1.id = t.dpid

Hi TECHBABU,

Thanks for your replies. The articles are useful, but don't really offer an explanation for what is happening on my machine. In the mean-time I was able to do...

In SQL 2005 you can query the DMV sys.sql_dependencies for dependent and depending objects.

Another option is using the stored procedure sp_depends which will also work with SQL 2000.

Both machines are actually virtual machines running on the same type of hardware. The OS is Windows 2008 Standard 32-bit. I don't have the Perfmon data for CPU usage since...

What are you actually trying to achieve?

Do you want to make the table read-only or do you want to restrict access to a table so you can run a...

I assume you're using SQL Express...

SQL 2008 supports the replication of certain DDL commands like ALTER TABLE. So you should be fine with the changes you mentioned.

For more info see http://msdn.microsoft.com/en-us/library/ms151870.aspx

and http://msdn.microsoft.com/en-us/library/ms152562.aspx

Look up ALTER INDEX in Books Online.

When using the PARTITION option you can define which partition to rebuild or reorganize.

If you're database is logshipped it's in a restore state. Inorder to make ik available read-write you need to exeute this:

RESTORE DATABASE database_name WITH RECOVERY