Viewing 15 posts - 31 through 45 (of 67 total)
I have never used this loginproperty, until I saw your question... New learning every day 🙂
September 1, 2011 at 8:29 pm
What is the max memory setting for SQL Server? and the total ram on the server? is it 64bit or 32?
August 26, 2011 at 5:18 pm
As far as I remember, Express edition do include BIDS package. But I think there will be some limitations...
use this link to compare it with different editions..
http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx
August 26, 2011 at 5:10 pm
You will not be able to schedule SQL Server agent jobs in Express edition as SQL Server agent is not supported.... Just incase you have plans to schedule jobs later...
August 26, 2011 at 5:04 pm
To do it easy way, I think you have to create multiple jobs for each set of recipients and schedule the job for specific day and in sp_send_dbmail you can...
August 24, 2011 at 5:11 pm
create a job on your test server with following steps:-
1) Copy backup file from prod to test server. you may use command like
xp_cmdshell "copy source destination"
where source will be...
August 21, 2011 at 3:57 pm
You are right 🙂
Sorry, I missed this point..
August 21, 2011 at 3:51 pm
I believe this database is in full recovery mode. If you are not able to shrink the database log files then you can try changing the recovery mode to simple...
August 21, 2011 at 3:30 pm
Viewing 15 posts - 31 through 45 (of 67 total)