Viewing 15 posts - 106 through 120 (of 268 total)
If the two server have the same paths a backup and restore may work
Mike
June 12, 2006 at 1:44 pm
Interesting! Can you share the query that returned distributed/not distributed?
Mike
June 12, 2006 at 1:38 pm
Any connection would come across to the database as an spid and that can be back tracked to the connection if that is what you are interested in ...
Mike
Mike...
June 12, 2006 at 1:35 pm
Derek
Not sure you are fully understood but the intervals seem to be a bit too close.
Again not sure I understood you properly
Mike
June 12, 2006 at 1:33 pm
There is also a GUI tool tool that could help resync logins (Good if you have just a few logins )
http://www.dbmaint.com/SyncSqlLogins.asp
Mike
June 9, 2006 at 8:35 am
Enclose the complete paths in double quotes since there are spaces enclosed.
Start with a simple notepad file when it works move on to the files you need to move
xcopy...
June 9, 2006 at 8:23 am
Cannot blame you.I dragged my feet too.But was bitten by joining a couple of views .After a week of calling microsoft and the hardware vendors I installed SP4 as a...
June 7, 2006 at 6:40 am
Try it and see what the user can do/view
Mike
June 5, 2006 at 8:56 am
Forgot to mention our server was patched to sp4 and the problems disappeared
Mike
June 2, 2006 at 2:05 pm
Thanks everyone for your time especially Tom and Steward
Mike
June 1, 2006 at 6:48 am
Additional information:
Discovered that all the long queries are related to views but all the table queries run as expected.Not sure wether that gives any more clues or not.
The explain plan...
June 1, 2006 at 5:12 am
Not sure my indexes need to be rebuilt .This is showcontig .The explain plans are the same as explained at the start but the subtree costs are higher...
May 31, 2006 at 8:48 am
Tom this is the information you requested
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server parse and compile time:
CPU time =...
May 31, 2006 at 7:45 am
FASTER less beefed up workstation
*************************
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server Execution Times:
CPU time = 0 ms, elapsed...
May 30, 2006 at 1:11 pm
Tom
Thanks for your time .
The data is exactly the same on both servers .
Auto create and auto update stats is enabled.
Statistics for all tables involved in the query were rerun just...
May 30, 2006 at 12:47 pm
Viewing 15 posts - 106 through 120 (of 268 total)