Viewing 15 posts - 466 through 480 (of 1,363 total)
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
If SORT_IN_TEMPDB is set to ON, there must be sufficient free space in tempdb to store the collection of sort runs for the largest index, typically the clustered index, and...
April 20, 2009 at 6:21 pm
Please run sp_spaceused @updateusage 'true' on both the databases and compar the size thereafter.
MJ
April 20, 2009 at 6:20 pm
Viewing 15 posts - 466 through 480 (of 1,363 total)