When installing or patching SQL Server in a cluster, it is very important that there are no users logged into the passive node when the upgrade is performed.

If there is...

Steve Jones - Editor (4/16/2009)

---

The VSTS tool is Red Gate's under license.

There are other compare tools, but there is no best one. Try one or two, pick the one that...

I am not aware of a native tool that can do the same things. You can build your own (sort of) using SMO with Powershell or other utilities.

I have...

My guess would be that either the schedule is not enabled, or the fact that you are using the network service account instead of a domain account or local system...

If you have the delete task execute before the backup - the files will be deleted and then the backup will run. If the backup then fails, you've lost...

If you have the maintenance window to run it (with a full scan) every night, then there really is no harm in doing so. Most of the time, it's...

To add to what Flo has shown you - if this is not going to be executed a lot, then the recompile option works well. But, if it is...

Try adding the column list to the insert statement:

If object_id('tempdb..#mytemptable') Is Not Null

Drop Table #mytemptable;

CREATE TABLE #mytemptable

(

myserverrole VARCHAR(50) DEFAULT @@SERVERNAME

,mymembername VARCHAR(Max)

,mymembersid VARBINARY(Max)

,mycheckdatetime datetime default...

Yes - you can use a default, or computed column, or even add it to the select statement....

Yes - executing something like that would fail due to the multiple result sets.

One of the things you can do is view the code used in those procedures and extract...

Stamey (4/15/2009)

---

After 2 hours, 53 minutes, the restore finally finished and now the transaction log is almost empty. Time for a shrinkfile.

The shrinkfile worked, on both data and log files....

Don't I know it - I was also involved in that thread, that's why I don't think it will make a difference.

You would use:

INSERT INTO {table}

EXECUTE {procedure}

It is documented in books online under the INSERT INTO topic. The caveat for this is that the procedure cannot return more than one...

The sad thing is - I don't think it will make a difference at all. We'll see though...

When you say it doesn't work - what does that mean?

When you state that it runs manually - but not scheduled, what does that mean?

And, I would recommend that you...