Hi Todd - thanks for the tip!

I was able to get the startup parameters in an also connect without any issues...

I got this to work by using these steps...

Hi Todd and p.van.rixel,

I am trying to move msdb and model datafiles to different locations on my sql server 2005(sp3) cluster per KB224071(sounds like what you were trying to do)...

Ah - that kind of stinks. We are grabbing the backup files from disk now but would like to back up to tape directly to take advantage of the high...

Great post! Have you had any experience doing this with SQL Server 2000? Is there a way to do this with 2000 or just with 2005?

Hi Steve,

I am in the process of putting together a plan to consolidate 60+ servers onto a clustered environment...should be interesting!

I enjoyed your article and am looking forward to hearing...

SQL Mail can be a headache...I've tried that myself in the past as well and was not happy with it. (see: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=122828)

I've also tried using CDO to send...

Nevermind...turns out there was a stored proc that used this UDDT as a parameter. I didn't notice it at first because sp_depends did not return this as a dependency....wierd

Thanks for your...

Worked like a charm - I'd definitely be interested in seeing an article published w/ all those reg settings!

Thanks!

John

Saw something similar once: I noticed 19 consecutive login failures from each login on one of my SQL Server instances - all in under a minute! I immediately started a...

Hi All,

I ended up creating a new role in master and granted EXEC for all of the sp_OA procs to the new role. Now if someone needs to run sp_send_cdontsmail(regardless of...

Thanks for all of your feedback!

The installation instructions on the xp_smtp_sendmail website read:

"4. Grant rights to the correct set of users using OSQL or SQL Query Analyzer by executing:grant...

I have a server where there is heavy file fragmentation but it is quite busy and cannot be down for long periods of time. Is there any way other than...

Hi Brian,

Thanks for your response. I'm sort of new to the networking part of this. What does the SQL Listener Service do exactly?

Also, these two boxes are Windows 2000...

Thanks for your response. I selected the hide server option but I noticed that by doing this the port is automatically changed to use 2433. It looks like you cannot change it...

Thank you both for your responses...I've began looking into removing the BUILTIN\Administrators account.

Brian- that article you wrote is a great. Thanks!