Viewing 15 posts - 196 through 210 (of 210 total)
Following is my learning today. MS_Foreachtable can execute more than one command simultaneously.
exec sp_MSforeachtable 'select ''?'', count(1) from ?'
exec sp_MSforeachtable "print '?' DBCC DBREINDEX('?')"
exec sp_MSforeachtable "print '?' SELECT count(1) from...
July 22, 2009 at 3:54 am
Hello Chandra Mohan
I need to install reporting services as well and this is the reason I need IIS.
Could you give me some link that defines how tio install...
July 22, 2009 at 3:50 am
Job 1, on success, kicks off job 2. No need to worry for the time when job 2 is kicked off. This totally depends on job 1's execution.
-LK
July 22, 2009 at 1:20 am
Steve,
Does it mean that when we rebuild the index for large DB as 1000GB, we should make the recovery model = SIMPLE
-LK
July 22, 2009 at 12:59 am
No don't use instead of trigger.
I would like you to go ahead and enable default trace on by using sp_configure command. now you can easily see all the logs by...
July 22, 2009 at 12:43 am
How this will recur every 16 hours when you are asking this to execute at some specific time everyday? You need to have at least two jobs to perform this...
July 21, 2009 at 10:38 pm
Following comment give your answer:
@@DBTS returns the last-used timestamp value of the current database. A new timestamp value is generated when a row with a timestamp column is inserted or...
July 21, 2009 at 9:22 am
use http://msdn.microsoft.com/en-us/library/aa964122(SQL.90).aspx for sliding window partitioning.
July 21, 2009 at 8:27 am
report any error log from sql server error log folder. You will find some error log in bootstrap folder. Go and find error log from event viewer and post them...
July 21, 2009 at 6:15 am
You don't need subject_id(fk) in TableAnswer again. You can always take this by using Quiz.question_id.
-LK
July 21, 2009 at 6:04 am
Possibly because you have one Databases that have a compatibility level of 70 (SQL Server version 7.0).
Can you change this compatibility level and run once?
-LK
July 17, 2009 at 9:53 am
Hello marty streetman,
I don't think that your statement is correct in your first paragraph. This can never happen that sql query analyzer or management studio is causing open transaction issues......
July 10, 2009 at 7:36 am
How to see what is there in the BCDEdit.exe file? Following link gives information about this file but is not enough
July 10, 2009 at 5:22 am
same issue for me... I restarted sql server... NO gain... Pls give address of registry....
Also one question. How can I use BCDEDIT.exe to add /3GB switch?
July 10, 2009 at 5:04 am
Might be there be some sql server 2000 as well. They would have been talking about sp4 for them. But Truly there is no sp4 for yukon.:cool:
July 10, 2009 at 3:34 am
Viewing 15 posts - 196 through 210 (of 210 total)