Server Configuration

Maintenance plan
Hi After the maintenance run at the end when it has to delete old backup files, therer is an error. error 208. Any idea? SQL 2005 64 bit with sp3 and all the patches on win2003 R2 64bit sp2 and all the patches. Than'x Shay ... 26 May 2010 00:33

sysmail_mailitems
The sysmail_mailitems table in the MSDB database will not shrink. It currently has 0 rows, 18,999,600 KB reserved, and 18,997,888 KB of data. I have rebuilt the single index that is atached to that table. It looks like all of the table that are labeled with a type_desc of "LOB_DATA" have the same issue....0 d... 21 May 2010 16:09

Propiedades del SQL Server
Para cambiar el idioma en las propiedades del SQL Server De Espa�ol (Espa�a) a Espa�ol (Mexico) ... 20 May 2010 23:47

Next Greater Value after Min
I want to find the next greater value after min for "NextOrder". I'm currently using Max but I know there are orders that have a date greater than the Min but less that the Max....can this be done? SELECT CNumber, Min (CreateDate) as FirstOrder, Max (CreateDate) as NextOrder FROM dbo.tblOrder (nol... 30 May 2010 05:45

Simple model and T-log
Hi, I have a question about model recovery: if I am in "simple recovery model" I can't backup my T-log it is backuped only during a backup database so my T-log can be very big between to database backups am I right ? Thanks in advance ... 22 May 2010 07:17

UPDATE [table] WITH (PAGLOCK) xx OPTION (SHRINKDB PLAN)
Hello, I am trying to troubleshoot a stored proc which as increased it's execution time from 2hrs to 9hrs. The original code was written for SQL 2000 and I've found an update stmt with the syntax above. I've not seen the "option (shinkdb plan)" before. Does anyone know what it is and what it does? ... 20 May 2010 18:20

User id executed stored procedure
Is there a way to find out in SQL 2005 who executed a particular stored procedure? Thank you, T. ... 20 May 2010 16:08

Error making target server on multiserver envmnt
Hello, adding a target server into a master I do the following steps: 1) On Target server: Right click on agent -> Multi Server Administration -> Make this a Target... 2) Next 3) Pick Server 4) Type in the master server and put in [B]SQL Server Authentication[/B] (sa, which even has same password on both serve... 20 May 2010 12:48

Error when trying to schedule job in SQL 2008
I am trying to schedule a job in SQL 2008 using a proxy however get an error: The job failed. Unable to determine if the owner (NICE-PAK\SVC_Sostenuto) of job Sostenuto AD Import has server access (reason: Could not obtain information about Windows NT group/user 'NICE-PAK\SVC_Sostenuto', error code 0x5. [SQLST... 20 May 2010 12:48

How to correctly uninstall SQL Analysis service form SQL Server 2008 cluster?
Hello, I need to reinstall SQL Analysis Service. How to correctly uninstall SQL Analysis service form SQL Server 2008 cluster? Mindaugas ... 20 May 2010 09:28