Mahesh Bote (2/2/2009)

---

[font="Verdana"]Parameters in SProcs are not optional. You have to mentioend them while calling the SProc. You can instead mention 'DEFAULT' keyword while passing the parameters. Like:

EXEC dbo.sp_Sample Default,...

SeaBee (1/30/2009)

---

MarkusB (1/30/2009)

Just to confirm from your previous mesage - you say there's no way to move the actual install directory (INSTALLSHAREDDIR)? Well, that's what my frustrated efforts also shows...

SeaBee (1/30/2009)

---

I am actually trying to do both.

We want our system databases on a different drive than our installs. We also want SQL install to be done on a...

I don't know for sure, but if I remember correctly this acount must be sysadmin or at least very close to that.

The reason if that the MOM agent needs...

You can move the system databases to any directory you want and in fact it's much simpler than in SQL 2005. I think what you tried was changing the directory...

A Little Help Please (1/30/2009)

---

Need some advise!

I have several databases in my SQL 2005 environment which all have several jobs associated with them.

I would like one central DB which holds...

Check out the following links

http://blogs.msdn.com/psssql/archive/2006/11/27/sql-server-2005-sp2-will-introduce-new-messages-to-the-error-log-related-to-timing-activities.aspx

http://support.microsoft.com/kb/931279

And by the way, it's called Management Studio in SQL 2005.

onlo (1/29/2009)

---

I installed SQL 2005 Failover Cluster on the node 1 successfully.

However, when I switch it to the node 2 (the passvie node), I clicked "Start", "Program" and "SQL Server"...

Shaun Stewart (1/29/2009)

---

Hi,

If all you are doing is comparing passwords you will not need to decrypt anything. Simply encrypt the supplied password and compare it with the password stored...

Congratulations Steve and everybody else who made this community so succesful.

Reading those questions I really...

In QA the setting "Quoted Identifiers" is by default on.

In SSMS (or EM) this setting is by default off. SO in your job either enbale quoted identifiers or...

:unsure:

I assume you mean the transaction log is full.

If that's the case...

The problem is that IIS 7 by defualt has not all components which are necessary for SSRS. Check out this link for more details: http://www.jameskovacs.com/blog/ReportingServicesOnWindowsVista.aspx