ksrikanth77 (6/24/2012)

---

I mean we need not add anything post installation, this is taken care automatically. Please find the below link.

http://technet.microsoft.com/en-us/library/ff182359(v=WS.10).aspx

Note

There is a change in the way the Cluster service...

Adam

In 2005, you had to create the account yourself if you didn't want it using BUILTIN\Administrators. I think the security is a bit more sophisticated in 2008, so I'm...

Happy to help, Adam. I've done a bit more digging, and, by default, the "Is Alive" check runs every 60 seconds when the cluster service connects to SQL Server and...

So that...

ganeshkumar005 (6/19/2012)

---

Although log file size was 22 gb only on drive (and 10 gb data internally), the backup job consumed 73 gb space on backup drive and failed with...

If you can't get the error in any other way, try running a trace while you execute the maintenance plan.

John

What do you want to do with the variable in your Execute SQL task? From the information you've given, it sounds as if you need to use an input...

Yes, I noticed that only last week. The size of the trace file in Explorer is 0KB until the trace has stopped.

John

Good question. I fell for it. But I don't think we should make too many assumptions about how common the clustered primary key myth is with knowing how...

It does seem a strange name for the action. I...

You can right-click on the package in Solution Explorer and choose Reload with Upgrade. It's a bit easier than coming out of BIDS altogether.

John

I think what I would do is alter your stored procedure so that it gives a return value of the number of rows inserted, then either insert that value into...

Sounds like you're looking at the design surface of your package, and not in...

Try it out. It also returns last_run_date and last_run_time, which gives the last time that the job started - whether it's still running or not.

John

Mmmm... that's a good point. SQL Server 2000 had an "In Progress" value for run_status, but that seems to have been dropped from later versions. One way round...