Viewing 15 posts - 736 through 750 (of 1,179 total)
It's depend on the size of your database, nature of your database i.e. transactions, Recovery model of your database, frequency of your T-log backup etc. As a thumb rule if...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 21, 2010 at 4:08 am
Howmany rows the specific table contain? what is the size of the table?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 18, 2010 at 6:22 am
Make sure the OS Backup is not conflicting as it folder is accesse by other os backup than also SQL Server won't able to delete the file.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 18, 2010 at 1:18 am
Above link is working fine just eliminate period (.).
http://msdn.microsoft.com/en-us/library/ms188917.aspx
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 18, 2010 at 12:38 am
You can refer the following link for reference:
http://www.sommarskog.se/mssqlperl/unix.html
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 16, 2010 at 4:42 am
If I am not worng
sp_OASetProperty
will work in 2000 too while sp_send_dbmail is available from sql 2005 onwards. Hence this will have more flexibility with respect to version.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 14, 2010 at 6:49 am
I am not sure to consider this question as good or bad?
But the fact is I have fixed the syntax and opt for answer 1 and lost 3 points.
Here is...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 13, 2010 at 11:51 pm
You can also use DBCC SHOW_STATISTICS
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 9, 2010 at 2:02 am
Check the ALTER AUTHORIZATION (Transact-SQL) which may help you. Refer the following link:
http://technet.microsoft.com/en-us/library/ms187359.aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 9, 2010 at 1:42 am
Hello Paul
Perfect Question!!!
To be specific I like the Answers provided are superb.
Anyway I pass it 🙂
Cheers
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 8, 2010 at 1:43 am
You can also set up to send mail with required information as soon as DDL trigger fires.
I hope as a DBA no body is doing like this deliberately. But it's...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 8, 2010 at 12:13 am
refer the following link which might userful:
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 7, 2010 at 6:49 am
It is not advisable to update the system tables.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 7, 2010 at 6:40 am
You can shrink tempdb
dbcc shrinkdatabase (tempdb, 'target percent')
this will shrink tempdb. Also you can use dbcc shrinkfile to shrink primary or log file.
Refer the following link for tempdb:
http://technet.microsoft.com/hi-in/library/cc966545(en-us).aspx#EBAA
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 3, 2010 at 6:53 am
looks like some of the supporting services are not running or not enabled...
check the services "Remote Desktop Help Session Manager" is running
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 2, 2010 at 7:41 am
Viewing 15 posts - 736 through 750 (of 1,179 total)