Viewing 15 posts - 2,986 through 3,000 (of 7,429 total)
Based on this line
2003-05-08 07:40:30.28 spid2 Recovery complete.
I would have to say this SQL Server was stopped (either just service or whole box).
If those DB are highly accessed and had...
May 13, 2003 at 6:28 am
I think in what I stated it is a limit of the filter interaction with the event. Capture only what you need in regards to events. For example things like...
May 13, 2003 at 5:21 am
Anything occurr such as a close db action or an error occurr around in the error log at that time? And did you check Event Viewer to see if anything...
May 13, 2003 at 5:15 am
To the best of my knowledge there is nothing like this in SQL.
May 13, 2003 at 5:13 am
If you can find how to reproduce from yuor logs then send to MS. But I sure would make them aware as this is supposed to be unique within a...
May 13, 2003 at 5:07 am
Might be wrong and cannot find any of my servers with this on it. But I believe if the ox stops unexpectedly it actually is checking the DBs for potential...
May 13, 2003 at 4:38 am
I agree your query looks right.
But try changing
FROM salesdetails sd, products p
WHERE p.prod_id_id=sd.sale_prod_id
to
FROM salesdetails sd
INNER JOIN products p
ON p.prod_id_id=sd.sale_prod_id
to see what happens.
Also what do you end up with?
May 13, 2003 at 4:32 am
Ok I am gonna start as from the top.
1) On the new server create your suer without a default DB or any permissions to DBs accept those that already exist...
May 13, 2003 at 4:25 am
I believe you are correct and just before or after you should see a blue forked arrow as the data streams are seperated or brought together.
May 13, 2003 at 4:20 am
When you open in EM the code is run locally to your machine. When you run thru QA it will be executed at the server. If the server and your...
May 13, 2003 at 4:16 am
There are multiple ways to do this but none actually take one command in most cases (especially when you count the copy). The way I generally use if I can...
May 12, 2003 at 2:46 pm
1) Look at sp_changeobjectowner in BOL.
2) Look at sp_change_users_login to sync the old account to the new one on the new server. Access will be same it is that the...
May 12, 2003 at 2:38 pm
You should still consider a Clustered index even on a small table. It will add very minimal overhead to storage (statistics stuff which you generally see created anyway, table will...
May 12, 2003 at 2:36 pm
Housing yes uns on average about $100,000. ANd as a hint if you move to the area live on the Florida side of the line for tax purposes (no personal...
May 12, 2003 at 9:24 am
quote:
60 - 78K for a 8 - 10 year guy?I know guys graduating from college this year with 0 yrs experience,...
May 12, 2003 at 7:43 am
Viewing 15 posts - 2,986 through 3,000 (of 7,429 total)