Viewing 15 posts - 451 through 465 (of 1,166 total)
Take a look New Roles in the msdb Database
SQL Server Agent in SQL Server 2005 adds three new roles to the msdb database:
• | SQLAgentUserRole Users added to... |
January 26, 2007 at 11:55 am
select cast(salesdate as varchar(10)) as 'date',
datepart(hh,salesdate)as 'hour',
count(1)as PR
from TableName
where salesdate >= '' and salesdate < ''
Group By cast(salesdate as varchar(10)),
datepart(hh,salesdate)
Order...
January 25, 2007 at 11:19 pm
Are you sure it is not MemToLeave memory?
I have seen lot of cases of MemToLeave memory only which requires a reboot to fix it...
January 25, 2007 at 5:28 pm
Almost 1.5 times of th table size not db size...
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspxThe
amount of free space needed varies and is dependent on the number of indexes being created in the transaction....
January 25, 2007 at 5:25 pm
Check windows COMPACT command with /U switch...
January 25, 2007 at 5:16 pm
max indicates that the maximum storage size is 2^31-1 bytes
January 25, 2007 at 5:10 pm
I didn't fine the way to uninstall ..
2000 BOL gets from C:\Program Files\Microsoft SQL Server\80\Tools\Books folder ....
January 25, 2007 at 5:02 pm
Restoring user database should be fine between the editions where as you can't restore system databses.
January 25, 2007 at 1:55 pm
Check SAC to make sure you have enable remote connections...
For Express, developer and Eval. edition by default it is configured to local connections only...
January 25, 2007 at 1:48 pm
Try...
ControlPanel/Add or Remove programs/Microsoft SQL Server 2005 Books Online (English)
then click remove...
January 25, 2007 at 1:37 pm
If you are looking for monitoring tools...
QUEST and IDERA has good tools ...
http://www.sql-server-performance.com/spotlights.asp
January 25, 2007 at 1:31 pm
if (@whatever = 'myvalue') OR (@whatever = 'myvalue 2')
January 25, 2007 at 1:24 pm
If you want to use use VARBINARY(MAX)...
I believe IMAGE datatype is depricated in 2005...
January 25, 2007 at 11:31 am
If I am not mistaken all these option are automatically added when you create the backup using BACKUP wizard.
May be they have created the backup job using backup wizard...
January 24, 2007 at 11:39 pm
Viewing 15 posts - 451 through 465 (of 1,166 total)