Viewing 15 posts - 361 through 375 (of 405 total)
This can be due to any reason. Why don't you check for blocking to begin with.
select * from sysprocesses where blocked0
June 19, 2009 at 3:28 am
Table sample returns random set of rows. There is no guarantee for the number of records returned. It can be used for sampling
While top will give you the same set...
June 19, 2009 at 3:21 am
Only in 2005 its disabled by default for security reasons.
In 2000 you need to have sysadmin fixed role to use it.
Pls see the below link
http://msdn.microsoft.com/en-us/library/aa260689(SQL.80).aspx
June 19, 2009 at 2:40 am
Thanks pklotka. But I would stick to the table. It gives me control over which all servers to check among my long list of linked servers. Thank you for the...
June 13, 2009 at 4:36 am
I have achieved the same using cursor. But sure of course there might be an easier way.
June 11, 2009 at 4:55 am
Did you check your error log/event log for timeouts or any other errors?
June 10, 2009 at 7:27 am
Have you tried manually growing the file?
June 10, 2009 at 7:13 am
Configure alerts for every errors with severity greater than 17- to start with
June 10, 2009 at 7:10 am
Ravish,
I think you should put it in the connection string
(I am not sure this is what you are looking for)
June 10, 2009 at 6:57 am
Thanks Tim.
I was wondering how it just stopped after restart.
My tempdb is pre - sized. I think the messages might have started after it filled the initial size. ...
June 10, 2009 at 6:46 am
Thank you all for your help.
But now the main cause of concern is no more there. I no longer get the IO warnings after a fail over. I think...
June 10, 2009 at 6:16 am
Kailash,
If you are looking for a kind of undo ctrl+Z for committed data, its not there in SQL Server
You can get the data back provided you are taking regular backups,...
June 10, 2009 at 5:31 am
Yes try to give more info if possible.
By the way if you need something to start with, Use activity monitor for blocking, use system monitor and sql profiler to...
June 10, 2009 at 5:22 am
Yes the best place to do this is crystal reports. You can use grouping in crystal reports based on tenants. And the repeated column can be placed in detail section.
June 9, 2009 at 10:58 pm
Viewing 15 posts - 361 through 375 (of 405 total)