Viewing 15 posts - 466 through 480 (of 1,365 total)
Check [ @file_attachments = ] 'file_attachments' parameter of sp_send_dbmail in BOL.
MJ
May 19, 2009 at 3:04 pm
Nope, it justs applies to connections opened thru tht SSMS.
MJ
April 29, 2009 at 7:29 pm
Check the creation date of tempdb database fot that.
MJ
April 29, 2009 at 6:59 pm
The output will display the name - which is the name of the drive; low free displays the available free space and media type displays the type of media namely...
April 29, 2009 at 2:52 pm
Better use catalog views for this.
Check-->http://msdn.microsoft.com/en-us/library/ms190365.aspx
This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views...
April 28, 2009 at 4:02 pm
Execute this:
ALTER LOGIN sa WITH PASSWORD = ‘your_password_here‘ UNLOCK
MJ
April 27, 2009 at 7:22 pm
Rather than exporting it out why don't you log the maiintenance plan output to a log file.
MJ
April 27, 2009 at 7:14 pm
Please post the error message that you are receving at your end.
MJ
April 22, 2009 at 12:54 pm
MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 - Implementation and Maintenance
http://www.microsoft.com/learning/en/us/exams/70-432.mspx
MJ
April 22, 2009 at 12:42 pm
Better run a profiler trace and analyze the statements that were under execution when agent broke out.
MJ
April 21, 2009 at 8:18 pm
Is there any other sysadmin account using which you can login thru management studio?
MJ
April 21, 2009 at 1:12 pm
Modify the query then:
select d.name as DatabaseName, mf.name
as FileLogicalName, mf.physical_name, type_desc, max_size
from sys.master_files mf
inner join sys.databases d on d.database_id = mf.database_id
where max_size in (-1,268435456)
April 20, 2009 at 7:37 pm
Check DMV named sys.dm_fts_active_catalogs.
MJ
April 20, 2009 at 7:05 pm
Viewing 15 posts - 466 through 480 (of 1,365 total)