Viewing 15 posts - 466 through 480 (of 648 total)
Grant Fritchey (8/25/2011)
August 25, 2011 at 10:28 pm
SQL DBA-909494 (8/24/2011)
You need to add the IP address details in all the sections during configurations whereever you find the IP field. Also if you are using dynamic/static port also...
August 24, 2011 at 3:29 am
Hi Florian Reischl, One more help require from your side.
There were 76 non-clustred Index created in sql 2000 as of now data pages and index pages are same MDF file....
August 20, 2011 at 5:09 am
Hi Thanks for reply...
Yes ...you are correct. there was bug in SQL 2000 also.
Developemnet team build this query and project. after that they are not tested properly for all reports...
August 20, 2011 at 5:03 am
No..
If removed ")" as folllowing error comes
Msg 207, Level 16, State 1, Line 11
Invalid column name 'mac'.
Msg 145, Level 15, State 1, Line 1
ORDER BY items must appear in the...
August 20, 2011 at 4:36 am
Hi thanks for reply.. It is working fine in SQL2K8 after remove the ORDER BY
thanks
ananda
August 20, 2011 at 4:10 am
yes, I tried ssms.exe at command line,
Error is - Windows cannot find ssms.exe.
August 16, 2011 at 1:28 am
I log off domain id in report server,
It is work then again login administrator account.
August 12, 2011 at 3:39 am
yes, I added domain Id in destination server.
August 11, 2011 at 9:37 pm
There is no memory issues.
total server RAM 4GB.
I have checked through SQL Server cache manager Tool. It showing as blow output one of the stored Procedure. this one SP...
August 6, 2011 at 4:06 am
Hi, Thanks for reply...
SELECT session_id ,status ,blocking_session_id ,wait_type ,wait_time ,wait_resource ,transaction_id
FROM sys.dm_exec_requests WHERE session_id = 53
In this case wait_resource is - Blank. I could not find out...
August 3, 2011 at 1:53 am
select distinct req_transactionUOW from sys.syslockinfo where req_spid = 53
kill 'UOW' <-- The distinct UOW's except all 0's.
result is - 00000000-0000-0000-0000-000000000000 - please clarify me little confused, It means...
August 3, 2011 at 12:59 am
sujitkmishra (8/3/2011)
select distinct req_transactionUOW from sys.syslockinfo where req_spid = 53kill 'UOW' <-- The distinct UOW's except all 0's.
Thanks for reply...
select distinct req_transactionUOW from sys.syslockinfo where req_spid = 53
result is -...
August 3, 2011 at 12:18 am
Hi ,
As you reply...
If it's CPU or I/O is not being utilized then try killin git with Kill SPID. If still it's not killed then check the Unit Of Work...
August 2, 2011 at 11:50 pm
max degree of parallelism
min - 0
max - 64
config value - 0
Run_value - 0.
as per above sp_configure only default setting. not extra configure on this server.
and there is not MAXDOP...
August 2, 2011 at 11:47 pm
Viewing 15 posts - 466 through 480 (of 648 total)