Viewing 15 posts - 16 through 30 (of 107 total)
SELECT
DATEPART(dd,MST.backup_start_date)) + '-' + CONVERT(VARCHAR(3),DATENAME(mm, MST.backup_start_date)) + '-' + CONVERT(VARCHAR(4), DATEPART(yyyy, MST.backup_start_date)),'') ,
ISNULL(CONVERT(VARCHAR(100), MST.database_name), ''),
ISNULL(CONVERT(VARCHAR(100), MST.name), ''), ...
February 14, 2011 at 4:50 am
U can execute sp_helptext stored procedure name in the msdb database and u will get the required information.
Cheers,
Satnam
February 14, 2011 at 4:27 am
U can query the msdb database which contains the tables storing the backup information.
Cheers,
Satnam
February 14, 2011 at 4:23 am
High availability solutions are designed so that in case of any disaster the database can be brought back to its original state.
Cheers,
Satnam
February 14, 2011 at 3:36 am
Is there any space left on the drive where the tempdb is hosted. I feel that you will most probably need to restart the SQL Server Services.
Cheers,
Satnam
February 11, 2011 at 3:23 am
I believe that the distribution jobs gets created automatically when you configure the Replication.
Cheers,
Satnam
February 11, 2011 at 2:17 am
Check this one, I hope it helps,
http://www.ebook3000.com/Pro-SQL-Server-2005-Replication_100219.html
Cheers,
Satnam
February 11, 2011 at 2:06 am
1 Why not set the auto-growth feature as ON for the database.
2 Regarding SQL Server Restart, the information can be found in the SQL Server Logs or you can check...
February 10, 2011 at 12:10 am
Something innovative and out of the box thinking, appreciated.
Satnam
February 9, 2011 at 12:02 am
A login is created on the server level. When this login is mapped to the database, it becomes a user for that particular database.
Satnam
February 7, 2011 at 9:33 pm
Normally, u can set the Autogrowth feature as ON as suggested by Ashish, but in my past experience I have noticed that when the Autogrowth feature is set ON it...
February 7, 2011 at 2:09 am
Yes, u can do it. When u right click on database and select Properties , then select Filegroup,it will show you the mdf and ldf file size in MB.
Consider ur...
February 7, 2011 at 1:52 am
My mistake, actually in SQL 2000 you don't have database mail profile, instead you use xp_send_dbmail
Refer the books online for the exact syntax for the same.
Cheers,
Satnam
February 7, 2011 at 12:56 am
Refer the article below:
http://www.sql-server-performance.com/articles/dba/dml_triggers_multiple_triggers_p1.aspx
For email notification use the below code in the trigger:
exec msdb..sp_send_dbmail @profile_name = 'Profile Name'
,@recipients ='Email Address'
,@subject = @mail_subject
,@body = @mail_body
,@body_format = 'HTML'...
February 7, 2011 at 12:53 am
Can you let us know the error message if any?
Cheers,
Satnam
February 4, 2011 at 12:26 am
Viewing 15 posts - 16 through 30 (of 107 total)